SELECT SPRFNBR, SPFNAME +' '+ SPLNAME AS FULLNAME
FROM SPEAKERS
Should do the trick.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:41 PM
To: CF-Talk
Subject: CFSELECT
brain melt-down... please assist! :-)
Here's my SQL: SELECT SPRFNBR, SPFNAME, SPLNAME as Name from SPEAKERS
Here's my CFSELECT: <cfselect name="COSPEAKER" query="getSpeaker" size="1"
value="SPRFNBR" display="SPFNAME" selected="SPRFNBR"></cfselect>
Works great!
However, I would like to add the first and last names together....and I know
this can be done inside the SQL statement, and this is where I would like to
do it. I know there are other solutions, but does anybody know how to
concatenate the two inside a SQL statement? I've done it before but for the
life of me, can't get it to work.
Any feedback is of course, highly regarded and much appreciated!
Erika
"Age is in the mind of the beholder." - Unknown
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
