Well, I believe the answer to your question would be to set a var as
follows:
<cfset wholename = "#firstname# #middlename# #lastname#">
Unless I'm missing something here.
By the way... I'm just curious. Why in the heck would you do this anyway?
I mean wouldn't it make more sense to just split up the names into three
fields?
----mark
------------------------------------
Mark Warrick - Fusioneers.com
Email: [EMAIL PROTECTED]
Phone: 714-547-5386
http://www.fusioneers.com
http://www.warrick.net
====================================
> -----Original Message-----
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 6:20 PM
> To: CF-Talk
> Subject: List question
>
>
> I have three "memo" database fields delimited by commas:
>
> 1. FirstName (eg: John,Michael,James)
> 2. MiddleName (eg: Pat,Tony,Peter)
> 3. LastName (eg: Smith,Affleck,Cousins)
>
> So the three names should come out as:
>
> John Pat Smith
> Michael Tony Affleck
> James Peter Cousins
>
> How can I extract these and wrap them up into a single variable? (so I can
> insert each name into a form as a seperate record).
>
> Thanks!
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
