Sure. Do it in your query
SELECT Name AS FName + LName (use syntax for your DB here)
best, paul
At 12:23 PM 11/28/00 -0500, you wrote:
>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/[email protected]/
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
