<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