asp arrays and MSSQL database

[Emagine]

does anyone know if there is a way you can save an array into a MSSQL database?

thanks in advanced

 

[jonyah]

only way i know is to use a loop.

 

[Emagine]

sorry wasnt quite clear i ment

i have a ASP array

and i wanted to save that array into a MSSQL field so the field holds the whole thing.

i think im gonna have to use a deliminators system

 

[tetranz]

Joining it all together into a long string with a delimiter is probably the easiest way to go. The other way is to convert to XML.

If I recall correctly, VB has a function called Join which does what you want and a function called Split to convert back to an array. I don't recall if those are available in the VBScript you get with ASP. They probably are. I assume you're using "classic asp", not asp.net.

Cheers
Ross

 

[Emagine]

thanks,

i had a thought on this im going to use XML because i can then query the xml instead of having to split or create the data into an array. saving processing.

and store the XML in the database