I realize this particular requirement might be rare, but it comes in handy when you have an XREF (cross-reference) table which ties two tables together. Many times, when this is the case, it is a common requirement to perform multiple SQL inserts into the table within one request.<\/p>\n
If we are performing the inserts from an AJAX call, we might have the required insert data right in our query parameters. This would allow us to loop over the url<\/em> structure to perform a bulk update.<\/p>\n But wait! There's one problem. When you loop over a structure, you don't know where the loop ends, so you really don't know when to stop placing that comma between insert blocks.<\/p>\n For instance<\/p>\n So with a simple loop, you could do the following:<\/p>\n Then, run the query in a <cfquery><\/em> statement.<\/p>\n But, wait again! What about securing our queries with <cfqueryparam><\/em>? That's a problem here because <cfqueryparam><\/em> can only be nested inside a <cfquery><\/em> block.<\/p>\n That's where <cfsavecontent><\/em> comes in. See the example below:<\/p>\n I realize this particular requirement might be rare, but it comes in handy when you have an XREF (cross-reference) table which ties two tables together.…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[15,34],"tags":[94],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/262"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=262"}],"version-history":[{"count":3,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":265,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/262\/revisions\/265"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}INSERT INTO table (key, value)
\n\tVALUES ('key1', 'value1'), ('key2', 'value2'), ('key3', value3)
\n\t<\/code><\/p>\n<cfset sql = "INSERT INTO table (key, value) VALUES">
\n\t<cfloop collection="#url#" item="key">
\n\t <cfset sql = "(#key#, #url[key]#),">
\n\t<\/cfloop>
\n\t<cfset sql = Left(sql, len(sql) - 1)> <!--- to get rid of that trailing comma --->
\n\t<\/code><\/p>\n<cfquery>
\n\t INSERT INTO table
\n\t (
\n\t key,
\n\t value,
\n\t )
\n\t VALUES
\n\t <cfsavecontent variable="inserts">
\n\t <cfloop collection="#url#" item="key">
\n\t (
\n\t <cfqueryparam value="#key#">,
\n\t <cfqueryparam value="#url[key]#">
\n\t ),<\/cfloop><\/cfsavecontent>
\n\t #Left(inserts, len(inserts) - 2)#
\n\t<\/cfquery>
\n\t<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"