I usually do so in the sql select statement. By adding something like:
Select *, LNAME + ', ' + FNAME AS FULLNAME order by FULLNAME
Then I use the column FULLNAME in the cfselect.
Athelene Gieseman
[EMAIL PROTECTED]
-----Original Message-----
From: .elizabeth. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 11:23 AM
To: CF-Talk
Subject: cfselect question
Okay, pretty simple question here:
I have a cfselect form field that is being populated by the LName column in
my Contacts table:
<cfselect name="ID" required="yes" query="qContacts" value="ID"
display="LName">
The code above works fine; my select box gets populated with all the last
names in the contacts table. BUT, I need to display the contact's first AND
last name (two separate columns in the database), and not just the last
name. Is there a way to get the select box to display both columns?
Thanks a lot,
elizabeth
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
