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
ICT Development Manager
John Cabot City Technology College
Tel 0117 976 3000 Ext 2112
Mobile: 07734395347
E Mail: [EMAIL PROTECTED]
Alt: [EMAIL PROTECTED]


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
 Save $10 Download ZoneAlarm Security Suite 
http://www.houseoffusion.com/banners/view.cfm?bannerid=66

Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1404
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