>- see footer for list info -< Hi Guys Just want to check if there is a more efficient way of doing what i am doing?
If i have a list of text string values: list1 = a,b,c,d,e,f and I want to use the list as part of an 'IN' SQL statement: select * from xxxxxx where yyyyyy in (list1) but i want each element in the list to be in single quotes in the 'IN' clause... I am guessing i can't use preserveSingleQuotes if the list values aren't already in single quotes? and I can't use quotedvaluelist if the list isn't from a query column? I was thinking of using listchangedelims from , to ',' and then appending and prepending a single ' ? but i thought there must be a function for this already? (the origin of the list is a load of check box values from a previous form page) Cheers -- Rich _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
