View Single Post
  #1 (permalink)  
Old June 11th, 2006, 01:39 AM
mateenmohd mateenmohd is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default multiple checkbox store one field


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



Reply With Quote