there is five checkbox to select users
to insert records.


checkbox1=Request.Form("checkbox1")
checkbox2=Request.Form("checkbox2")
checkbox3=Request.Form("checkbox3")
checkbox4=Request.Form("checkbox4")
checkbox5=Request.Form("checkbox5")

Response.Write(checkbox1)
Response.Write(checkbox2)
Response.Write(checkbox3)
Response.Write(checkbox4)
Response.Write(checkbox5)


set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="..." // connection string
cn.Open

but videoname field is one in the table. ie.
user have choice the to select the checkbox to acknowlege
that which safety video he view.

how insert the records in table of five checkbox of one user ?

it is not good to save separate videoname of each user.
like following..

isql1="insert into safetyvideo (user_id,checkbox1,checkbox2,checkbox3,checkbox4,c heckbox5) values ("
isql2="'" & user_id & "',"
isql3="'" & checkbox1 & "',"
isql4="'" & checkbox2 & "',"
isql5="'" & checkbox3 & "',"
isql6="'" & checkbox4 & "',"
isql7="'" & checkbox5 & "')"

I want to store user records of checkbox like following how ?
how five checkbox value store in one table field ?


isql1="insert into safetyvideo (user_id,videoname) values ("
isql2="'" & user_id & "',"
isql3="'" & videoname & "')"


sql=isql1+isql2+isql3
cn.Execute sql

regards

Mateen