Asp, Access, multi insert 2

[tran008]

hi all,

I need to insert multi row from a text box which contain multi email address separate by comma field. Anyone have example any where?

thanks

 

[Sheco]

If you are using VBScript with your ASP then you can use the Split() function to create an array from a string.

Something like this:
MyArray = Split(Request.Form("PutTheNameOfYourTextBoxHere")

Then you can just do a For/Next loop through the array elements and insert them one at a time.

 

[ethorn10]

doesn't Split() require a delimiter to split on? like ";" or "," or something similar?

i.e.

MyArray = Split(request.form("textboxname"),",")

 

[Sheco]

Yes it does...

but tran008 said the values are "separate by comma"

 

[Sheco]

Oh, duh

Now I see what you meant.

Yeah, I forgot the second argument to the Split() function!

/blush