Graham Pearson
|
Posted: 09/20/2004, 6:24 AM |
|
Does anyone know how to combine two fields from a table to populate
the text portion of a listbox using coldfusion. I have first_name and
last_name fields seperated within my table and when I display the
listbox selection I would like it to show Last_Name, First_Name
Any Ideas?
---
Graham Pearson, System Administrator / Web Developer
Northern Indiana Educational Services Center
56535 Magnetic Drive, Mishawaka IN 46544 http://www.niesc.k12.in.us
|
|
|
E43509
Posts: 283
|
Posted: 09/29/2004, 11:07 AM |
|
Depending of the database
In oracle select last_name || ', ' || first_name fullname, myid from mytable
In access select last_name & ', ' & first_name as fullname, myid from mytable
Now you can reference the text portion as fullname in the ccs list builder.
|
|
|
|