ASP :: Insert Checkbox Values From Dynamic Record Set

Is It Possible To Insert All Checkbox Values Into 1 Field In The SQL Database?
Is it possible to insert more than 2 checkbox values into 1 field in the SQL database?

I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.

Dynamic Checkbox
I have a table in ASP page which displays records and it has a checkbox whose name is ChkBox<%= intRecID %>

<%= intRecID %> is the ID of that record. Now how should I chck whether check box is not checked.

Dynamic Checkbox
I have a form with x amount of checkboxes called "majestic". But i only want the user to select one.How do i go about this in javascript or is there an asp alternative.

Checkbox Values
im not that good at asp, infact im using dreamweaver to make my pages up! what i would like to do is show a list of items and price in a table, with a checkbox next to them, the form is submitted and then on the next page i would like to display the the items that have been checked.
I think i have the first page sorted, i have linked the checkbox to the product ID value in the database, so i can pass that value to the next page. the problem is the second page, i can get it to show the values of the checkbox (eg items 1, 4 ,26...) but only the numbers.How do i go about using this value (number) to pull the rest of the data from the table (stored in a mdb)?

im using this in the first page form to pass the checkbox value
<input type="checkbox" name="checkbox" value="<%=(rs_stock.Fields.Item("ID").Value)%>">

on the second page i get the values get shown with
<%= Request.Form("checkbox") %>
im at a loss on how to do this

Getting Checkbox Values
I have a page with a checkbox on it (chkMyBox). I want to be able to click on it and redirect the page back to itself, showing the box checked when it resubmitts. How can I do this?

Checkbox Values
I need to get the values of a number of checkboxes without A) Resorting to calling them all the same thing and using the below to sort it out: Code:

ValueA = Split(Request.Form("a"),",")
For i = 0 to uBound(ValueA)
response.write(i)

Response.Write(trim(valueA(i)))

Next

or

B) Having a request.Form for each one (There could be in excess of 40 checkboxes; the number changes).

Dynamic Checkbox With Database
i have list of items as a list.Now user can select any item in that list. Now what i do is create checkboxes to enable user to check the item which has to be selected.

1. Checkboxes are dynamic.

2. I create checkboxes with one name assign value = Itemcode value so that when form is submitted i can get the itemcode value as a comma seperated list and which would be easy for me to put it in a database query.

3. the part i have problem is i have to display those checkboxes ticked back to user , ie after form submit i have to make the checkbox which are previously checked, to be in checked state.

request.form("Chkgroup")="1,4,5,6,9,10"

assume this is an arrray i am getting from form element.what is the easiest and efficient method so that i can make those checkbox checked again.

Dynamic Checkbox Problem
i have a few fields in my db that are true or false and i want to link them to my asp page on to checkboxs.

i've tried to set the checkbox value to Code:

value="<%=rs.fields("yn").value%>"

but it doesn't work How can this be done?

Checkbox To Insert Data
Is it possible to insert values in a Database with a
checkbox? Say I have a recordset and if the check box is checked I
want to insert the value of the of the field in the DB.

<%=rsqa.Fields.Item("recini").Value%>

That is a persons initials, i want to insert those initials in a column
if it is checked, if it isnt checked nothing is inserted..

Insert Value Of Checkbox To The Database
what Im trying to do is to insert into the database the values of the checked checkboxes of the recordset fields the appear in the table I've written the following code:

Multi Checkbox Insert
I have a form that is passing a number to check box values with the same name (productID) but different values (numerical values). It is also passing a warehouseID as a hidden field.

I need to dump these values into an access table called wtbProductWarehouses with fields titled ProductID and WarehouseID. What is the code that I need to write to have it loop through all of the productID values and individually add each one to the db while also adding the warehouseID with it.

Multiple Insert With Checkbox...
This is my problem... its for a mailing list with categories...

I have 3 table...

1 : Name,City,Email

2 : Categorie

3 : Name_id , Categorie_id

So when a user fill up the mailing list form, he can check as many categorie he want...

but how i can insert 1 row in my table #3 for each checkbox checked...

Can someone post me a simple script...

Insert Record Goto Last Record
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?

Adding Checkbox Values
I am trying to create a 'build a quote' page in which a user can checkoff checkboxes and have the total add up once the submit button is clicked. An example of the code I am using is

<form action="add.asp" method="POST">
option 1 value is 5<input name=""check"" type="checkbox" value="5"><br>
option 2 value is 9<input name=""check"" type="checkbox" value="9"><br>
option 3 value is 1<input name=""check"" type="checkbox" value="1"><br>
option 4 value is 2<input name=""check"" type="checkbox" value="2"><BR><BR>
<input name=""Submit"" type="submit"> <input type="reset" value="Reset">
</form>
<hr>
<%
arrB = Request.Form("check")
arrA = split(Request.Form("check"), ", ")
If arrB<>"" then
For each x in arrA
total = x
next
response.write(total)
end if
%>

Adding Checkbox Values
I have 2 pages - form.asp and result.asp. in form.asp, i have multiple checkboxes with varying values, like:

<html>
<body>
<form action="result.asp" method="get" name="form">
Name1: <input type="checkbox" name="1" value="5">
Name2: <input type="checkbox" name="12" value="7">
Name3: <input type="checkbox" name="12" value="9">
Name4: <input type="checkbox" name="12" value="11">
<input type="submit" name="submit">
</form>
</html>

I seek to capture these values and add them up in the result.asp page. e.g. if name1 and name3 are selected, i want the total of 14 to be shown up in result.asp page. I need help here for the asp code for the above. Or, may be some advice on how the above can be accomplished.

Dynamic Checkbox Form Processor
I have a form with dynamic checkboxes, and normal text boxes. If the user doesn't fill out the required items and submits the form they get returned back to the form with their checkbox selection gets lost.

How do i retrieve the values already checked and placed them back.

Insert Checkbox Vaule To Database
I am having problems inserting checkbox data into my database. The string data from the text files in my form have no problems being inserted in the db. Code:

Sending Checkbox Values To E-mail
I am trying to Send the values of checkboxes to the user's email
and display in the form of List <li></li>. The values of checkboxes
are sourced from a table in my access DB. I am using Jmail to send
this info. Can anyone please help me how to retrive values from the
check boxes, split, make a list and send in the body of e-mail.
Here is wht I 've done so far :

uname = Request.Form("name")
uemail = Request.Form("email")
chk = Request.Form("checkbox")
chk = Replace(chk,",","<br>")
chk = " " & chk
mailserver = "my.mailserver.net"
recipent = uemail

msg = "<html><body> Dear " & uname & ",<br>Thank for requesting our product list." &_
"<br>This is what u requested : <br>" & swnp & "</body></html>"

Set Mail = Server.CreateObject ("JMail.SMTPMail")

Mail.ServerAddress = mailserver
Mail.Sender = "email@mydomain.net"
Mail.Subject = "Your Request"
Mail.AddRecipient recipent
Mail.Body = msg
Mail.Execute

Validate Fields When A Dynamic Checkbox Is Selected
I am trying to make several fields in a HTML form validated, but only
when a dynamic checkbox is selected. I am not sure how to do this.

Here is a snippet of the dynamic checkbox code:

<%
Set RSLIST = Server.CreateObject("ADODB.Recordset")
SQLLIST = "SELECT * FROM Newsletters ORDER BY Newsletter_Name"
RSLIST.Open SQLLIST, Conn, 1, 3
%>
<%Do While Not RSLIST.EOF%>
<input type="checkbox" name="Newsletters"
value="<%=RSLIST("ID")%>"><%=RSLIST("Newsletter_Name")%>

I would like to make three fields (company, phone_work, license)
mandatory when one of the "ID" (i.e. ID 2) is checked.

Updating Via An INSERT Query Controlled By Checkbox
I have a form that if a user selects a certain option from a dropdown list a checkbox will appear. This checkbox references information from another table and then multiplies a figure before it is submitted (well, that's the theory anyway!)

I can't seem to get the multiplier to work. Can someone please give me some advice to this? I've included some simplified code that concentrates on the areas that I'm having difficulty. Code:

INSERT Multiple Records From Checkbox Form With Unique Ids
I have an .asp page with a form to copy job responsibilites form one
job to another. It is a hotmail type interface with checkboxes
besides each responsibility. After submitting, it should copy the
selected resp's to a different job. After that it should renumber
that job's responsibilities.

This is the code I am using now to copy:

copySQL4 = "INSERT INTO
jambue.RESP(POSCODE,IDCODE1,IDCODE2,RESP_NUM,RESP) SELECT '" & id & "'
POSCODE,'" & dept & "' IDCODE1,'" & unit & "' IDCODE2, '999' RESP_NUM,
RESP FROM jambue.RESP WHERE (POSCODE = '" & POSCODE & "' AND IDCODE1 =
'" & sourceDept & "' AND IDCODE2 = '" & sourceUnit & "') AND RESP_NUM
IN (" & Request.Form("chk") & ")"

As you can see the value '999' is hardcoded in there as the new
Responsibility Number to go with the copied responsibility. I use
this because there are no jobs with that many responsibilities. This
works fine if I only select one resp. to copy over. But if I select
more than one that part still runs fine but I get an error with the
below. It says too many rows would be affected. Of course, this must
be because there are now at least 2 responsibilites with the same
RESP_NUM. Code:

Dynamic Record
I am trying to create a recordset that is dependant on who is logged in. Here is a look at the SQL I have tried with no luck.

SELECT *
FROM picks
WHERE (((picks.PlayerID)={Session.MM_username}));

Sorry if this belongs in the sql forum, I wasnt sure as I am using an asp page.

Insert Record
Is it possible to, whilst inserting a new record, use a session variable from a previous page for one of the fields?

Insert Record
am trying to get my ASP page to write session variables into an Access database. However I'm getting error messages. I'm not sure if I used the right syntax (using double " for example) Can anyone see a problem:

'Command1.CommandText = "INSERT INTO tbl_quotewedding (coverllevel, weddingdate, marqueecover, publicliability, quote) VALUES ('"" & session(""svCoverLevel"") & ""','"" & session(""svWeddingDate"") & ""','"" & session(""svMarqueeCover"") & ""','"" & session(""svPubLiab"") & ""','"" & session(""svTotalCost"") & ')"

I know that the code below works OK so it must be something to do with how I've included the session variables

Command1.CommandText = "INSERT INTO tbl_quotewedding (coverllevel, weddingdate, marqueecover, publicliability, quote) VALUES ('silver', '30/11/2004', 'No', 'No', '55')"

Insert A Record
ive created a database using access, and ive successfully created a ole db connection to a webpage using dreamweaver. i can view records without any problems but when i try to add a record tothe database from a webpage form i get the following error msg

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/guitarguide/guestbook.asp, line 115,

the field names in the database table start with txt_ e.g. txt_name, txt_email etc.

Insert Record
need to retrieve a record from a table (tblBookingForm) in one database and insert it into a table (tblNetServ) in another database on the same server,leaving the original record in place.Cant get my head round it though, doesn't seem to want to connect to 2 databases at the same time.

Insert Record
I want to submit a record to my db via a simple form but return the user to the same page upon submission ie place a form on index.asp and the form action="index.asp".

My logic isn't quite right, can someone guide me in the right direction? This is what I have, upon submitting the details the page just reloads and the record is not inserted.

<form method="post" action="index.asp">Name<br><input type="text" name="Name" id="name"><br>Email<br><input type="text" name="Email" id="email"><br><input type="submit" name="submit" value="submit"></form>
<%
If Request.Form("submit") = "submit" then
call MailList
End If
%>

Insert A Record
I am inserting a record into a table to hold information about photos and what to create a folder with the same name as the primary key value of the inserted record. Eg if I have a table (tblAlbum) with two fields (albumID, albumName) and run an insert statement 'INSERT INTO tblAlbum (albumName) VALUES ('test album')`.

I want to then create a folder with the new value for albumID. How do I retrieve this new value just created?

Insert Record
I am using Dreamweaver to create the insert record code for an access database. When it adds the code, I can not see the page on the website. If I remove the code the page works fine. I'm not sure what is going on?

Dynamic Record Updating
I am dynamically building a query from an access db to output on a separate page. This is working fine.

On this page (the query results page), I want to have checkboxes and a text field where the user can input text and select the records to update (by checking the box). Once they select and hit submit, I want to update only the records selected.

Problem is, I am trying to figure out the most efficient way of doing this...any ideas?

Add Dynamic Values Into Css
if you can add dynamic values into a css. I have an image which i want to set as a backgroung image but depending on who is logged in will depend on what image is being pulled out. I dont want the image to be repeated though out the region it is in so i have used the following syle sheet code. But i have had to adda an actual image name in. Is there any way to make this dynamic image value or not. And if not is there another way i could create a similar effect? Code:

.image
{
background-image:url(images/maps/bangor.gif);
background-position:center;
background-repeat:no-repeat;
}

Waiting For Db To Insert Record?
Just a quick question more about the flow of an asp page. IF I have code as
below: -

MyDBConnection.Execute "Insert Record Into A Table"
MyRecordset.Open "Retreive the same record from the table"

Is there any chance that the connection process (Inserting the record) will
not have completed by the time I try to retrieve the record. I.E. will the
asp page wait for the insert to complete before continuing to open it (the
next command in the page).

Multiple Insert Record
i want to insert some records to Access Database using the checkbox.i've try all the example i've found but it does't work.it's like checking our yahoomail.but i want all the tick checkbox insert to database

Recalling A Record Insert
I want to insert a record into a DB and then immediately recall what
the ID is. I have heard that there is a way to do this with SQL Server
(although I haven't done it yet). Unfortunately this is for Access.

I've done some workarounds for this in the past but want to know if
there are better ways. What I've done in the past is to recall the
file name or something from the FORM collection against the DB
(assuming this file is unique).

Using aspupload, if the overwrite
attribute is set for FALSE I can use that as a way to better ensure the
file name is unique as it renames the file if it is not unique. The
problem is I need to to this without aspupload now.

I had thought of recalling the last record ID from the DB on the FORM
side and putting it in a hidden field but this seems risky. Any
suggestions?

Insert/update Record
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.

Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?

Error On Second Record Insert
Working on a order sys for a client. I go to create an order, no problem IF There are no other records in a specific table. It is working like this:

create order #1...creates "order" in order table and adds 1st item in orderdetail table...add items to order in orderdetail table...no error.

create order #2...creates "order" and gives an "HTTP 500 - Internal server error".

this involves one ASP page, two tables and one SP. Here they are: Code:

Multiple Record Insert
I am trying to insert multiple records into Access DB from a form. Code:

Insert Values
Iam trying to insert values into my database, but i keep on getting this error, Code:

Subscript out of range: '[number: 1]'

I have tried to check my insert values but i can't pickup anything, can anyone assist me in this regard. Here is the portion of the code:

Record Values Are Being Passed
When i submit this form all the record values are being passed to the next asp page. But i want only those records which the user has changed in this page.

Dynamic Form Values
If I have say 10 fixed variables, how can I set their values = to that of a form that is built dynamically?

column1column2
email=formvalue(0)
fname=formvalue(1)
lname=formvalue(2)

etc..

lastvar=formvalue(9)

Insert Record With Constant Text
I have a quick question regarding a text field for inserting record, I have a page which inserts various fields including area code an phone number for a new record, however I am curious if there is a way that I can either make the area code appear with brackets around it in the text field which is sent so that the user does not have to type it in each time.

I was thinking I could concantenate the value i send in each time with brackets but am not sure what the syntax would b for this. or perhaps there is another way of doing this?

Restrict Insert If Record Exsists
Can someone point me in the right direction on this? There are 3
fields in the DB: model, rma, bagqty. If the values on a certain row
are I530, 1108, 50 and a user goes to input the same data I dont want
the insert to be allowed and force a new insert.

I dont need someone to do this for nor do I want that, just need a push
in the right direction.

INSERT Record To Database AND CDONTS
Is it possible to use CDONTS to send an email and INSERT a record to a database, once a form has been submitted. They work individually but I cant get the scripts to work together.

Insert Database Record Problem!
I'm having a trouble to insert data into the database. I can't understand what do I do wrong. I've got 2 pages , one is html with user registration form and another one is asp with the following code:

Insert Multiple Values
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent

Insert A Column Values
Here's the link for the db table:

http://k.domaindlx.com/gemetria/pageing.asp

How do I insert a field of values?

Looping Through A Record Set And Summing Values
I have a record set with returns the following :-

"stringId","typeId","count"

e.g.

A, A, 3
A, B, 7
...
B, A, 19
B, B, 3
...

I can't change the query I have to work with this record set as it comes from a view which is the only DB object I can access.

I could requery the view using

SELECT SUM(count) FROM table WHERE stringId = 'x'

however this is very very slow and results in a lot of round trips to the SQL server.

What I need to do is get totals for each stringId and I am puzzling over the best way to do this in ASP.

I then need to use the totals I have calculated to work out percentages of the count column. Code:

Unable To Insert Record To My MSaccess Database
I am trying insert a record to my database from my webpage customeradd2.asp Code:

Insert Statement Dropping Values
i'm reading in a .csv file and then inserting the data into a mssql db. batchid sometimes shows up blank. the values that are disappearing begin with the letter "N", such as "NP2338" or "N00312". outside of those that begin with "N", the rest are a five digit number. the table field is varchar. why is it dropping those that begin with "N"?