The cfselect help is here:
http://www.cfquickdocs.com/cf8/#cfselect
I notice two things with the query: you need an alias for the column
you are building
SELECT CONCAT_WS(" ",p.`playerfirstname`, p.`playerlastname`) AS PLAYERNAME
FROM players.players p
WHERE p.`club`=hometeam
and I'd add an ID in the select list so that you can populate the
cfselect values with an ID.
On 9/4/07, Paul Smith <[EMAIL PROTECTED]> wrote:
> 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!.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2938
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
