Insert a array of arrays into a ms sql

[nikos101]

What is the best way to insert a array of arrays into a ms sql table using coldfusion. I suspect it will be some nice cf loop thing to do this in about 5 lines of code 🙂

[Dan_Bracuk]

It would take a bit more than 5 lines, but you want to use nested loops. Hopefully the outer array is one dimensional.

[Newsgroup_User]

> What is the best way to insert a array of arrays into a ms sql table using coldfusion. I suspect it will be some nice cf loop thing to do this in about 5 lines of code :)

You suspect right.

How about you try it, and come back to us if you encounter any problems.

An array of arrays is an interesting data structure to have to want to be
inserting the whole lot into one table. How did they data get into an
array of arrays?

--
Adam