I know this is not the most secure method of writing multiple records but for now I am stuck with it in our secure environment.
Using the below sample - I would like a way to somehow relate all of the records that are inserted with the "Insertstuff" query. In other words; if the Insert is run 5 times I'd like a way to know that those 5 records were all submitted at the same time by a person...with this query. Could someone assist with the code or offer a recommendation?
<CFLOOP QUERY="data" startRow="2">
<CFSET sqlins = sqlins & "INSERT INTO myTable
(col1, col2, col3)
VALUES ('#col1#', '#col2#',