Skip to main content
nikos101
Inspiring
January 27, 2009
Question

Insert a array of arrays into a ms sql

  • January 27, 2009
  • 2 replies
  • 876 views
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 🙂
This topic has been closed for replies.

2 replies

Inspiring
January 27, 2009
> 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
Inspiring
January 27, 2009
It would take a bit more than 5 lines, but you want to use nested loops. Hopefully the outer array is one dimensional.