I had an interesting situation where I needed to Tag orders as “Reviewed” in a database so they could be filtered out in future queries.<\/p>\n
I wrote my standard query form form to limit results as usual, added filter (reviewed, not Reviewed, All) as a select box myCFMname.cfm (called by ajaxLink) I had an interesting situation where I needed to Tag orders as “Reviewed” in a database so they could be filtered out in future queries. I wrote my standard query form form to limit results as usual, added filter (reviewed, … Continue reading
\nand then added a column to my output results which allows the user to click a link\/checkbox to update a table.
\n
\n<cfoutput query=\"myqueryname\">
\n-- all the query results in a table displayed as web page plus one more column
\n<td>
\n<cfdiv name=\"cboxdiv\"
\n <input type=\"checkbox\" name=\"tagthis\" onclick=\"#AjaxLink('myCFMname.cfm?order_number=#order_number#')#\" \/>
\n<\/cfdiv>
\n<\/td>
\n<\/cfoutput>
\n<\/code><\/p>\n
\n
\n-- Full page with doctype, head, body tags
\n<cfquery name=\"ins_tag\" datasource=\"myDSN\">
\n insert into MYTable (order_number reviewed_flag, reviewed_who, reviewed_when)
\n values('#order_number#', 'Y', '#gettoken(user_email,\"1\", \"@\")#', getdate())
\n<\/cfquery>
\n-- replace the checkbox with message
\n <p>Reviewed<\/p>
\n<\/code>
\nAt a later date I added an UNDO\/Delete Flag feature. <\/p>\n","protected":false},"excerpt":{"rendered":"