multiple values insert into one field
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
|