Using CF8, MySql 5 & Dreamweaver CS3
Ok as you all know I'm thick so please address your replies as such.
I have created a hyperlink from page 1 to page 2 passing the the variables
"hometeam" "awayteam" & "recordnum", ignore the latter 2 for this query.
I have a database named players with a table named players (yes bright spark me
is!)
I want to create a CFSelect box populated with the following
SELECT CONCAT_WS(" ",p.`playerfirstname`, p.`playerlastname`) FROM
players.players p
WHERE p.`club`=hometeam
Can anyone help as this is really driving this newbie nuts
Thanks for your time its always appreciated!.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2936
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
