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: [email protected] > [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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
