SQL select statement problem

shrisangeeta · June 1st, 2006, 02:59 AM

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

ChrisScott · June 1st, 2006, 03:43 AM

Hi shri

If you are adding double quotes to a string in VB you need to add two double quotes e.g.

Code:

... AND price="">""" & ...

But a little confused by the =">" part of you statement, I think it should be...

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 & " AND price <= " & pmax & ";")

You may also need to add quotes around some of your field values if they contain strings e.g.

Code:

... AND zip='" & zip & "' AND ...

HTH,

Chris

shrisangeeta · June 1st, 2006, 05:20 AM

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

woodyz · June 15th, 2006, 10:28 AM

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

Woody Z http://www.learntoprogramnow.com