Monday, March 26, 2012

recursiveness vbs array to sql

recursiveness vbs array to sql

i always wanted to convert a jagged array to a sql database
i did it

first a jagged array is an array with array inside it
example:
ara01 = array("subject01", array("sub subject 01", "sub subject 02"))

the vbs jagged array to sql converter will:
initialise global variables for a recursive script
browse throught all elements
process the element if its not an array
call itself if a sub array is found
create a sql element (row) for each element in array, related to the array before
all that with a column unique ID in sql
all that in one table

(will post code later, it's late)