i have written the code like this fro sql execute statement;

set rs = conn.Execute("SELECT * FROM estaterec WHERE country=" & country & " AND state= "& sstate &" AND city= "& city &" AND zip=" & zip &" AND propertytype="& ptype &" AND intetion=" & intetion & " AND price=">"' & pmin &'" AND price="<'"& pmax &"')

all variables get the values form the Request.form object.. from a .htm file..

when i preview this page i m getting the following messange;
Technical Information (for support personnel)

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/test/infoseek/realestateshow.asp, line 26, column 251
set rs = conn.Execute("SELECT * FROM estaterec WHERE country=" & country & " AND state= "& sstate &" AND city= "& city &" AND zip=" & zip &" AND propertytype="& ptype &" AND intetion=" & intetion & " AND price=">"' & pmin &'" AND price="<'"& pmax &"')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^

can any one get this problem and solve for me... please it is very urgent project... please help me.....

shri

__________________
shri

Hi shri

If you are adding double quotes to a string in VB you need to add two double quotes e.g.
But a little confused by the =">" part of you statement, I think it should be...
You may also need to add quotes around some of your field values if they contain strings e.g.
HTH,

Chris

this code has been worked......

but the problem is that.. it is displaying all the records in the DB....it should display the records filtered by the given sql statement conditions; any how here is my code....;

set rs = conn.Execute("SELECT * FROM estaterec WHERE country='" & country & "' AND state= '" & sstate & "' AND city= '" & city & "' AND zip=" & zip & " AND propertytype='" & ptype & "' AND intetion='" & intetion & "' AND price >= " & pmin & " ;")

please .. solve this ....

shri

Did you find your problem? The statement you provided should work as far as I can see.

Woody Z http://www.learntoprogramnow.com