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