Oh just in case anyone is interested - here is a link to the development site:
http://202.157.179.158/csandbdirectory Cheers -----Original Message----- From: Pete [mailto:[EMAIL PROTECTED] Sent: Friday, 19 January 2007 1:03 PM To: CF-Talk Subject: Advanced Search Hi all I'm trying to finish something and its just not working. Here is what I am trying to do Display to a user a list of states in a drop down menu where they can either select an individual state or they can select All States. If they select an individual state everything works fine. If they don't select anything or select ALL STATES then I am receiving an error. Here's the code I am using for the search: <cfquery name="qGetAdvertisers" datasource="#request.db_dsn#" username="#request.db_login#" password="#request.db_pwd#"> select * from tbl_advertisers a, tbl_procedures p, tbl_advertiserprocs ap, tbl_advertiserstates r, tbl_states s where a.advertiserid = ap.advertiserid and a.advertiserid = r.advertiserid and p.procedureid = ap.procedureid and s.stateid = r.stateid AND p.procedureid=#form.procedureid# AND s.stateid=#form.stateid# </cfquery> I know I am missing something but just not thinking. Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=22600.17148.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4