Splitting and Storing...
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:
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)
any help is appreciated!!!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)