Thanks guys, Should have seen that one coming. Just got a BRAND new coffee machine the thing is like one of those really old Computers you would see from the 60's. Think I might get one.
Thanks again!!! Jeremy > Jeremy > > Straight from the docs: > > QuotedValueList(query.column [, delimiter ]) > > rob > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy > Sent: Wednesday, 12 January 2005 2:09 PM > To: CFAussie Mailing List > Subject: [cfaussie] List Function > > > Heya, > > Quick question, Firstly been up since very very early. So me not making > sense to muchly. > > I have a list. > > Sydney, Melbourne, Perth, Mars > > This comes from a query which I then set into a list. Now previously i > was able to make this list work to the way I wanted because it was all > numeric. BUT NOW...They want to use AlphaNumeric. > > <cfset branchlist = "#valuelist(GetBranches.BranchCode)#"> > > I need to put '' marks around each branch code. Do you know if this can > be done. i.e. 'Sydney','Melbourne', etc etc. > > I'm sure this can be done. Just a bit lost and tired on how to go about > doing it. > > J > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > __________ NOD32 1.968 (20050111) Information __________ > > This message was checked by NOD32 antivirus system. http://www.nod32.com --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
