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
