Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 29th, 2007, 02:11 AM
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 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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Values In One Field lefty4080 Access 1 December 12th, 2007 08:59 AM
insert multiple records into a table from values Deepak Chauhan Oracle 3 May 12th, 2006 10:35 PM
insert multiple checkbox values in to database muthumari_p2003@yahoo.com Pro JSP 0 March 29th, 2006 08:23 AM
How t o insert multiple values qazi_nomi Access ASP 2 May 3rd, 2005 12:45 AM
multiple values in an access field katie456 Access 11 October 23rd, 2003 08:36 AM





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