Start again. You have a drop down, when the user selects something from this drop down you want the selected value to filter the results of another query?
Show us your code in full, or better yet, a stripped down version(as in little HTML). Ade -----Original Message----- From: Colin Coles [mailto:[EMAIL PROTECTED] Sent: 04 October 2005 11:27 To: CF-Newbie Subject: Re: Form variable in a where clause Thanks for having a look. I have tried that but it still does not filter the names based on the selected group: <cfquery name="GetTG" datasource="sports_qs"> SELECT tg FROM tblTg </cfquery> <cfset TG =""> <cfquery name="getName" datasource="sports_qs"> SELECT name, names_tg FROM tblNames WHERE names_tg = <cfqueryparam value="#getTG.tg#" cfsqltype="cf_SQL_VARchar"> </cfquery> (names_tg and tg have the same values in both tables and are joined in a relationship) Colin Coles ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
