Splitting a Dynamic String

[toddsalcedo]

I have a dynamic string (1, 2, 3, 4,) that can contain numerous different numbers (they are ID numbers). I need an easy way to split the string so I can use each number individually to access the database and query for those records. I tried the following but it doesn't work.

id = request.form("id")
Replace(id, "") 'removing spaces
Split(id, ",") ' split at ","

 

[PHV]

Something like this ?
id = Replace(Request.Form("id") , " ", "")
a = Split(id, ",") ' split at ","
For i = 0 To UBound(a)
MsgBox "ID" & i & "=" & a(i)
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244