[cfaussie] Re: Converting comma-delimited lists to quoted value

2006-07-10 Thread grant 
Jeremy, you need to use listQualify()look it up in the docs...

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Converting comma-delimited lists to quoted value

2006-07-10 Thread Ryan Sabir 


How about just replacing , with ',', and putting an extra pair of ' 
around the whole string?

I'm pretty sure ValueLists only work from queries.
 

 -Original Message-
 From: cfaussie@googlegroups.com 
 [mailto:[EMAIL PROTECTED] On Behalf Of cfgroupie
 Sent: Tuesday, 11 July 2006 11:49 AM
 To: cfaussie
 Subject: [cfaussie] Converting comma-delimited lists to quoted value
 
 
 Hi guys,
 
 I'm pullin my hair out here(whats left). I have a list which 
 is coming out of the database
 
   MailIndustryList = '#JobPositions#';
 i.e. 24,45,67,343
 
 Now I want to put little quotes around each one of those numbers.
 i.e. '24','45','67','343'
 Me thinking.no worries cf has quoteddelimted
 
 #QuotedValueList(JobPositions, ' )#
 
 Don't work...does the QuotedValueList function only work with 
 queries...cause I was sure it worked with lists.
 
 Jeremy
 
 
  


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Converting comma-delimited lists to quoted value

2006-07-10 Thread Darren Tracey 

I ran into exactly the same problem just a week or so ago.
QuotedValueList only works with query results.
Bizaare, I know, but that's how it is.
Put a quote front and back and change the delimiter to be ','


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Converting comma-delimited lists to quoted value

2006-07-10 Thread cfgroupie 

rockin man...didn't know that function...now I do.. thanks
man...worked!

J.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---