try this...

<cfset newTemp = #ListChangeDelims(tempList, Chr(39)&Chr(44)&Chr(39), 
Chr(44))#>

HTH

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  ----- Original Message ----- 
  From: [EMAIL PROTECTED] 
  To: CF-Talk 
  Sent: Wednesday, December 12, 2001 4:37 PM
  Subject: Problems with single quotes and comma list


  Hey there, right now I've got a little puzzle I can't seem to solve 
right
  now I have a string

  91766,91777,91778 (basically a comma delimited list of zip codes)

  That I need to fix up with single quotation marks so I can search 
against 
  in
  a database string, basically like this

  '91766','91777','91778' etc.

  How would you go about doing this? All the functions I've tried seem 
to 
  have
  problems with the single quotes vs. double quotes.  Thanks!


  Gregory Harris
  [EMAIL PROTECTED]
  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to