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

Reply via email to