asp arrays and MSSQL database

Emagine

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

thanks in advanced
 
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
 
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
 
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
 
Back
Top