The code works to create strings, however, I need to somehow insert the single quote
marks around each entry in the lists in order for the SQL query to work.
Any ideas?
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 18, 2000 7:19 PM
> To: CF-Talk
> Subject: RE: String Confusion - RESOLVED
>
>
> You're awesome. That works! Thanks.
>
> --------------------------------------------------------------
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --------------------------------------------------------------
>
>
> > -----Original Message-----
> > From: Walker, Matthew [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 18, 2000 7:06 PM
> > To: CF-Talk
> > Subject: RE: String Confusion
> >
> >
> > > I know I need to loop through each of the location records
> > > passed through the form, but how can I split apart the 3
> > > fields: city, state, country?
> >
> > If you have multiple locations selected they will be separated by
> > commas so
> > you should use a different delimiter between city, state and
> > country -- e.g.
> > "|"
> >
> > Say if Form.location is
> > "city1|state1|ctry1,city2|state2|ctry2,city3|state3|ctry3"
> >
> > <cfset city_list="">
> > <cfset state_list="">
> > <cfset country_list="">
> > <cfloop list="Form.location" index="CurrentLocation">
> > <cfset city_list=ListAppend(city_list, GetToken(CurrentLocation, 1,
> > "|"))>
> > <cfset state_list=ListAppend(state_list, GetToken(CurrentLocation,
> > 2, "|"))>
> > <cfset country_list=ListAppend(country_list,
> > GetToken(CurrentLocation, 3, "|"))>
> > </cfloop>
> >
> > ------------------------------------------------------------------
> > ------------------------------
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
