Hi Dan,

First let me update the code to it's current state since the post;

<cfloop index="x" from="1" to="#ArrayLen(arr1)#">

<cfloop index="y" from="1" to="#ArrayLen(arr1[x])#">

<cfquery datasource="#request.dsn#" username="#request.dsnUsername#" password="#request.dsnPassword#">

update tbl_skuoptions

set option_name = '#arr1[sel]#'

where option_Type_ID = '#arr1[optiontype_ID]#'

</cfquery>

</cfloop>

</cfloop>

Right now I'm getting "Object of type class coldfusion.runtime.Struct cannot be used as an array" in the second loop but an example I found worked perfectly on the old CF7 server that we're stuck with on this website. It seems that looping 2D arrays is a pain to do.

Thanks for taking a look.

The info comes from repeating form fields in another page creating the strings, it's CartWeaver and I can't change that aspect or I would. I turned that into an array and thought it would be easy to loop through and cfquery/update the existing table.

Since there is more than one string I don't see any other way of doing this at the moment, I've been on it for a long time already and this error is at the very end of about 230 lines so I'm not giving up on it.. When I figure it out, I'll post it all over the darn place!

"sel" and "option_Type_ID" to match the data table. See something I missed?

Here's what I have, I think I tried that and got an error.

<cfscript>

arr1 = ARRAYNEW(1);

arr1[1][1] = "#listgetat(form.optiontype_ID, 1)#";

arr1[1][2] = "#listgetat(form.sel, 1)#";

arr1[2][1] = "#listgetat(form.optiontype_ID, 2)#";

arr1[2][2] = "#listgetat(form.sel, 2)#";

</cfscript>

<cfloop index="x" from="1" to="#ArrayLen(arr1)#">

<cfloop index="y" from="1" to="#ArrayLen(arr1[x])#">

<cfquery datasource="#request.dsn#" username="#request.dsnUsername#" password="#request.dsnPassword#">

update tbl_skuoptions

set option_name = '#arr1[sel]#'

where option_Type_ID = '#arr1[optiontype_ID]#'

</cfquery>

</cfloop>

</cfloop>