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

2006-07-10 Thread 

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
-~--~~~~--~~--~--~---

[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 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 
> 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 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  -~--~~~~--~~--~--~---