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