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)
No comments:
Post a Comment