I'm having difficulty with a search page. I followed the instructions in the Dreamweaver Help under "Building search/results pages (ColdFusion, ASP, JSP, PHP)" and this forum post on DMX Zone, but it seems like the recordset is not recognizing the variables that are coming from the form. The variables <b>are</b> being passed to the page; I put in a simple "echo($_REQUEST['varFamily']);" line and they show up. If you load the page without trying to pass it any variables it will return all possible results.

Below is the code being used for the form (most options have been cut for the sake of brevity):
<img src="img148.imageshack.us/img148/8509/searchformuu4.gif" border=0>

Here's a screenshot of the recordset window...
<img src="img68.imageshack.us/img68/6353/recordsetbx3.gif" border=0>

Any ideas what I'm missing here? Thanks! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Edited by - Theora on 02 Sep 2006 00:29:49

The problem is in the query, you use AND in it, so it will only find results when all criteria match.

--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------