p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Basics (http://p2p.wrox.com/forumdisplay.php?f=61)
-   -   multiple checkbox store one field (http://p2p.wrox.com/showthread.php?t=43809)

mateenmohd June 11th, 2006 01:39 AM

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





All times are GMT -4. The time now is 09:07 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.