List to quoted SQL IN list

Posted At : January 3, 2008 2:32 PM | Posted By : Admin
Related Categories: Code Snippets

<cfset list = "one,two,three">
original=<cfoutput>#list#</cfoutput><br>
<cfset quotedList = "'#replace(list,",","','","all")#'">
sql in list=<cfoutput>#quotedList#</cfoutput>
Note the single quotes before and after the # characters.
Source: bennadel.com

Comments (0) | Print | del.icio.us | Digg It! | 1351 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner