we have 44 check box
44 checkbox value inserting into 44 fields
ie.. video1 to video44


video1=Request.Form("checkbox1")
video2=Request.Form("checkbox2")
video3=Request.Form("checkbox3")
....


isql1="insert into safetyvideo2007(user_id,vdate,video1,video2,video3 ,
...

,video44) values ("
isql2="'" & user_id & "',"
isql3="'" & vdate & "',"
isql4="'" & video1 & "',"
isql5="'" & video2 & "',"
isql6="'" & video3 & "',"
....

isql47="'" & video44 & "')"

sql=isql1+isql2+isql3+isql4.....

cn.Execute sql

how can insert the 44 checkbox fields value into one
field ie. VIDEO ?

when user insert 44 fields by clicking checkbox, we want to
insert 44 checkbox fields into one fiels ie.. video how ?

ie.
table
--------
user_id
vdate
video

regards
Mateen