Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple queries based search criteria

Status
Not open for further replies.

potinenip

Programmer
Jul 12, 2000
35
0
0
US
Visit site
Hi,<br>Can i use multiple CFQuery tags in a single file? I have tried and its working but i didn't get the proper reselt.<br>I have a form which searches for houses based on some search criteria.<br>Fields are PropertyType, Bedrooms, Bathrooms, StateCode, PropertyPrice.<br>If my criteria is House, 2 beds, 2 baths, TX, $100000.<br>It doesn't look for houses that meet all the criteria.<br>Query works on only one field. I want the query to work based on all the fields.<br>Can someone help me with the code.<br>Thanks<br>Praveen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top