Ooops.
You're right.
Well, Jeff Garza's repsonse was accurate (I tested it).
Try it:
<cfset firstname = "John,Michael,James">
<cfset middlename = "Pat,Tony,Peter">
<cfset lastname = "Smith,Affleck,Cousins">
<cfset NumberIterations = ListLen(firstname, ",")>
<CFLOOP FROM="1" TO="#numberIterations#" index="i">
<CFSET fullname = "" & ListGetAt(firstname, #i#, ",") & " " &
ListGetAt(middlename, #i#, ",") & " " &
ListGetAt(lastname, #i#, ",") & "">
<cfoutput>
#fullname#<br>
</cfoutput>
</cfloop>
---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:50 PM
> To: CF-Talk
> Subject: RE: List question
>
>
>
> That comes back as:
>
> John,Michael,James Pat,Tony,Peter Smith,Affleck,Cousins)
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
