CFSelect Problem

[mcaselle]

I am having a problem with CFSELECT (w/ in a FLASH FORM) and SELECTED.

The query that populates the drop-down select box is:

<CFQUERY NAME="GetUsers">
select last_name || ', ' || first_name as uname
from users
</CFQUERY>

Example: uname= Doe, John


The query that the form uses is:

<CFQUERY NAME="GetDetail">
select id, type, name
from activities
where activity_id = '#URL.ID#'
</CFQUERY>

Example: name = Doe, John


The CFSELECT:

<cfselect name="user" query="GetUsers" display="uname" value=uname" label="User Name:" queryPosition="below" selected="#GetDetail.name#"><option value="">Select a Name</option> </cfselect>

The problem is that the CFSELECT is deliminating by the comma and separating the first, last names into multiple fields which do not match the SELECT value.

I need to be able to format the names in this manner any suggestions on how to accomplish the use of the CFSELECT with a comma in the name?

Thanx
Mike

[ranger]

select last_name+', '+first_name AS uname

seems to work ok

couldn't even get || ', ' || to work...? using msSQL2000

[mcaselle]

The bars "||" work fine in Oracle for concatenating two fields together in the SQL. The problem I am having is in displaying the field that has a comma in the data in the CFSELECT.
Thanx anyway.

[ranger]

try this....

use tilde "~" or something weird as deliminator in query
replace in select -option... don't know if will work in cfselect because the variable is not ##'ed

[Dan_Bracuk]

My suggestion is to not store the user's name in your activiities table. Store the user_id, instead. Then you can use the user_id field, which is hopefully numeric, in your cfselect and you won't have any problems with commas.