Hello. I have a form with several checkboxes... Right now, they all have the same name, so when i do a request.form on the name, i will get a value comma-spaced string.

Basically, i would like to know how to split this up and store it into the database.

I have this so far:

g_input=split(prj2002,",")
num_inputted=ubound(g_input)

response.write(num_inputted) ' This will return how many were checked.

So I'd do

x = 1
for x = 1 to num_inputted

SQLINSERT = "INSERT INTO retdata (empid, prjid, year) VALUES (" & "" & empid & ", ??? ....... ???, 2002)
set update = Conn.Execute(SQLINSERT)

next



any help is appreciated!!!
dep