cfselect values

[TheEngineer]

:confused; Im trying to populate a drop down select menu with the first and
last name of a customer in the form of (last_name, first_name) but the first
and last name are too different columns of the database and all i can figure
out is only firstname , or only last name.

[eastinq]

<option value="#last_name#, #first_name#">#last_name#, #first_name#</option>

[TheEngineer]

im trying to do it as a cold fusion form and that doesn't work, heres the code
that i have

<cfselect name="tenant" query="tenants" value="last_name">
<option value="#last_name#, #first_name#">#last_name#,
#first_name#</option>
</cfselect>


Thanks for the help, if you havent noticied Im a super newbe.

[zoeski80]

Hi TheEngineer

I haven't really used CFSELECT before but the attached code works

It looks like wtih CFSELECT you can only specify one query column for the
VALUE attribute - SO make first name and last name into one column in the query
....

Not sure if there is a better way but like I said, I haven't used CFSELECT
before.

Zoe

[zoeski80]

whoops, code might help ...

<CFQUERY NAME="tenants" Datasource ... >
SELECT first_name + ' ' + last_name as user_name
FROM users
</CFQUERY>

<CFOUTPUT>
<CFFORM ACTION="test.cfm" METHOD="POST">

<cfselect name="tenant" query="tenants" VALUE="user_name">
</cfselect>

</CFFORM>
</CFOUTPUT>

[TheEngineer]

Thanks that solved the problem. I never even thought about combining the 2 columns in a SQL statement prior tocalling them in the drop down menu. Typical newbie move on my behalf.