ListQualify is another good one. <cfset myList = "a,b,c,d,e"> <cfset myList = ListQualify(myList, "'")> <!--- defaults to a delimiter of comma, of course --->
myList now contains: "'a','b','c','d','e'" Cheers, Chris Nathan C. Smith wrote: > For those of us in <cf_cutteeth> > > * Do not use 'client' as the name of a variable. Try to avoid the word > 'client' as a database field name - alias it if you have to. Client is a > Coldfusion Variable scope and can cause strangeness when used as a variable. > > * valuelist() and quotedvaluelist() can save you from doing a lot of stupid > lists and concatenation. You can immediately get a list (and a string) of > the elements of a column in a query using these two handy functions. > PreserveSingleQuotes is helpful in league with quotedvaluelist to prevent > single quotes from being stripped. > > * Learning a language is easy, mastering one takes time. > > </cf_cutteeth> > > > Nathan Smith McKee, Voorhees & Sease, P.L.C. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4