Friday, October 14, 2011

ColdFusion elimination of double quotes

<cfset mylist = Replace(Form.chkNumberList, '#chr(44)#', "'#chr(44)#'", "All")>
                                                               

<CFQUERY name="qryMarkAsPaid" datasource="#Session.DSN#">
     UPDATE dbo.table
     SET status = 99
       , PaidDate = GetDate()
     WHERE myNumber IN ('#REReplace(mylist, "''", "'", "ALL")#')
</CFQUERY>

No comments:

Post a Comment