Inserting structure to table

I have kept it generic. It will work generally for any struct, as the keys don't have to be spelled out.

I have assumed all the data is of string type. You may want to take the challenge to make the code more efficient.

<!--- comma-delimited list of keys --->
<cfset keyList = structKeyList(st_datachanged)>

<cfset keyValueList = "">
<cfset counter = 1>

<!--- create comma-delimited, single-quoted values of respective keys --->
<cfloop List="#keyList#" index="listItem">
    <cfset keyValueList = keyValueList & "'#st_datachanged[listItem]#'">
    <cfif counter LT listLen(keyList)>
        <cfset keyValueList = keyValueList & ",">
        <cfset counter = counter + 1>
    </cfif>
</cfloop>

<!--- insert row to table --->
<cfquery name="yourQueryName" datasource="yourDSN">
insert into yourTable(#keyList#)
values (#preserveSingleQuotes(keyValueList)#)
</cfquery>

insert into yourtable

(firstname

, lastname

etc)

select distinct #firstname#

, #lastname#

etc

from somesmalltable

where not exists

(subquery to prevent duplicates)

but with cfqueryparam, checking for nulls, etc.