Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    ASP




Multiple Checkbox Only Passing One Value


I have a series of checkboxes:

<td><input type="checkbox" name="reportTo" value="Rob"></td>
<td><input type="checkbox" name="reportTo" value="John"></td>

etc...

but I only get a value passed to the database if just one is selected. If more than one is selected, no value is returned. I thought the value passed was s'posed to be a comma delimited string of all checked boxes?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Passing Checkbox Value
I have a simple problem:

page 1:
<input type=checkbox name=addValue value="Y">

page 2:
<input type="hidden" name="addValue" value="<%=Y%>">

page3:
<%=request.form("addValue")%>
<%if "addValue" = "Y" then addTax="30,00" else addTax="0,00" end if%>
<%=pCurrencySign & (addTax)%>

There is a problem in transfering the value from page 1 to page 2 and 3.

Add Multiple DB Entries By Checkbox
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).

Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.

Updating Multiple Records Thru Checkbox
I need a code that will update multiple records on a list thru checkbox.

If the record is selected, the details that was updated on the selected
record will copy the same value as what is updated.

Persits.Upload - Submitting Multiple Checkbox
I am using a form to upload images with Persits.Upload object. Now my problem is I cant use multiple checkboxes in the form.

In general forms I can use Form("checkboxName").Count to get the number of checkboxes selected and use Form("checkboxName")(i) to retrieve the value of each check box.

This doesnt work with Upload.Form

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:

Passing Multiple Sets Of Variables Into SQL
Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.

Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).

I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.

I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:

Passing Entered Value To Multiple Pages
Is it possible to take a value entered on one page and access it on several different pages? For example, I want the user to enter their email on the first page, make a selection on the second page, and the third page will display a form based on their selection on the second page. I then want to submit all the data entered on the form on the thrid page along with their email address from the first page to a database.

Passing Hidden Fields Into Multiple Forms
I'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:

Error In Passing Multiple Variables In A Href
I need to pass multple variables in a link in order to go to a asp page with
the two varables.

The following are the values of the variables using response.write:

<%'Response.Write Mypage & "<br>"%>
Exp

<%'Response.Write GrantID & "<br>"%>
4836

The link which I wrote is as follows:

<A HREF="mainreportagain1.asp?grantid=<%=GrantID%> & page=<%mypage%>">Report
Main Page</A>

However, when I am refreshing the page to click this link I am getting the
following error: Microsoft VBScript runtime (0x800A000D)
Type mismatch

Passing Multiple Selected Items To A Forms Page- How?
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.

I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.

Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.

HERE IS MY MAIN QUESTION:

What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?

I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?

SQL Server - Update/Insert Multiple Cols Into Multiple Tables
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.

I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.

If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.

Searching Multiple Memo Fields In Multiple Tables In Access
I have a search option on my website, which should perform a search on 4 fields, as follows:

tblNews
headline
content

tblDatabank
filename
description

It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.

I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?

How To Update Multiple Records With Different Multiple Value
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.

based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.

Checkbox Value?
is there a way of having a dropdownlist and a text field with a checkbox so that you can check a box and have the vaule assigned from a option selct list or check another box and have the value assigned from a textfield?

Asp And Checkbox
I would like to make an interaction with a database using ADO and SQL. I would like to display some parts of the database using checkboxes to choose the different parts. But I don't know how to build the SQL command in fuction of which checkbox is checked.

Checkbox
I am new born kid of this block and want some help from my seniours.
I am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table).
I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve.
On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table.
Now my problems is...
1) how can I know which checkbox user selected ?
2) Are there someway to get the value of checkbox without making form ?

Checkbox
i have a update page the pulles date form a database. and two the these
fields have Y or N in them and if the RS("Value") = Y the i want the
checkbox to be checked how do i do this??

Checkbox
I know this is gonna sound silly but when I submit a form with a checkbox
html control "mychk", how can I see if that is checked or not ?

I have tried :

if request.form("mychk") = true then
' code
else
' code
end if

But it always executes the code in the else statement meaning it is never
true despite the fact I have given the checkbox a value of true.

Checkbox Value
how to write sql to give value true in db?

If Else Using Checkbox Value
I have a checkbox which is used to determine whether or not the user wants to display a map of their business with their listing the value of which is being written into a database.

When I am outputting the listings I am just trying to use a simple if else statement

i.e. If(ShowMap = true)Then
Response.Write("<td>Show Map</td>")
Else
Response.Write("<td>No Map</td>")
End If

Problem is I know the database contains different values for ShowMap i.e. some true, some false. Yet when I use this code, No Map is output for all records.

Checkbox
I populate my checkboxes in a table written in asp. Each checkbox has the same value but a different name. I want to say for checkbox in the asp table, call a procedure that will do the changes. Code:

Using A Checkbox
I have a profile search where people can search through our dating profiles. I want to add a checkbox which when checked filters out those records where the recordfield pictures is empty.

I have problems figuring out what the checked value of the checkbox should be and how to use the information from the checkbox in the searchresults page to build the record set. For understanding, if a user does not have a picture the picture field is empty.

Value In Checkbox
I am trying to display the value of a true/false value in my table through the use of the following:

<input type=checkbox name=FieldLabCheck value=" &
objRecordset("FieldLaborSuper") & "></input>

it doesn't work though.... what am I doing wrong.

Value Of Checkbox
I have a checkbox in a form from which I want to collect the value.
<input type="checkbox" name="Question11a" value="a">

In the asp page that is called on submit of the form, I declare a variable, iQuestion11a, and request the value of this checkbox:
iQuestion11a = Request("Question11a")

When I print out the value to an html page <% response.write(iQuestion11a) %> it is empty.

Checkbox Set To OFF
When using checkboxes on a form, if you uncheck them, the unchecked name/value pair in the Request.Form collection doesn't show up. It only shows when the checkbox is set to ON. Is this correct? What's the workaround if it is?

Checkbox With Textbox
anyone have any idea how to do checkbox with textbox beside.

Checkbox Disable
if i want to display many records from database with each record has one checkbox.. if the record do not meet the constraints.. e.g. if supplier name has no email address.. then that checkbox will be disabled....the rest will appear.. i tried the disabled/// but no result.

How To Update Checkbox !!
I have problem in updating checkbox (true-false) using SQL statement.

Checkbox And Javascript
I have a JavaScript function that gets a boolean value and checks or unchecks a checkbox based on the boolean value.

function initialize_p(thevalue) {
if (thevalue) {
document.form.cbx1.checked=true;

}
else {
document.form.cbx1.checked=false;

}

In the example, I want form.cbx1 to be checked if 'thevalue' is true and unchecked if 'thevalue' is false. However, it's not working as desired. I used the alert stmt to see what it does:

- When 'thevalue' is true, it goes to the 1st part of the if stmt and checks the checkbox.
- When 'thevalue' is false, it still goes to the 1st part of the if stmt and checks the checkbox

It looks it never goes to the else!! I used alert stmts to see where it goes if the 'thevalue' is false (used alert to show me the value of 'thevalue' and where it is in the if stmt). I don't understand what's going on. Can anybody see what is wrong with the function?

Checkbox And Two Variables
I need to assciate two varaibles dyanmically in value of the checkbox.
How can I do that? For ex., I have the following:

<td><input type='checkbox' name='chk<%=i%>' value='<%=rs("Field1")%>'>

Above, I need to add second fields value from database in value
property of the checkbox.

Checkbox Vs Text Box
I have a form with multiple records.

My intention is to have the user click a checkbox for each product he wants.
Then submit the form placing multiple items in his cart.

If I use a text box like the following and enter a 1 for each product,
submit, no problem.

The user gets the products he wants.
<input name="qty" type="text" value="0">

However, if I use the following checkbox code, and assuming the user checks
4 products half way down the page, he will get the first 4 products in the
recordset. If he clicks 1 checkbox, he will always get the first product,
not the product he chose. <input name="qty" type="checkbox" value="1">

What I have found is when I submit the form to a blank test page using
checkoxes or text boxes, there's a considerable difference. The text boxes
deliver a comma delimination for each occurance. The checkboxes only offer
comma delimination for each checkbox that is selected. At this point, I'm
assuming that's the difference between the two and it cannot be changed
through HTML.

Checkbox Question
I have a sql database with bit datatypes and I am trying to create a asp
webform which will display and update the data from checkboxes.

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.

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

Return A Checkbox
How do I return the true/false value from the database to be either a checked or unchecked box using ASP?

Checkbox Required
Anyone know how to make a checkbox required in a form?

Dealing With Checkbox
I want to design a page which has lots of criteria on which I want to be selected by using checkbox's. I then want to pass only the criteria that have been checked and store them in an Access DB, and leave the items that have not been ticked alone.

Anybody any ideas?

Update Db With Checkbox Value
I want to use a check box to update a field if it is checked. I have:

<input name="expr_date" type="checkbox" id="expr_date" value="<%=newExprDate%>" />

this doesnt work in either way - the record field stays the same if the box is checked or unchecked.

Is this possible - where am I going wrong?

Checkbox Updating A DB
I'm trying to add a checkbox to a form which updates a DB (access). Dreamweaver generated this and then doesn't work.

<input <%If (CStr((RS_UpdateProfile.Fields.Item("fldReadTerms").Value)) = CStr("true")) Then Response.Write("checked=""checked""") : Response.Write("")%> name="fldReadTerms" type="checkbox" id="fldReadTerms" value="-1" />

This checkbox doesn't update the database nor does it display the value in the field in the table.

As I grow to hate dreamweaver by the day I still am not any closer to solving my little problem.

Checkbox In Repeater
I use a Checkbox in a Repeater, how can I know which Checkbox have changed in OnCheckedChanged?

I have tried to set id then checkbox is binding data, but it will not work.

ASP/Checkbox Array
I have a form with checkbox array and I am using the database to give uniqe values to the checkboxes. This form shows some of the checkboxes are already checked based on certain criteria.

When the user checks the check boxes I am able to get the ids of that record and be able to update the database. But when the users uncheck the check box that already checked, I am not getting anything when I do response.write. So I have no way of knowing which check box is unchecked and so I can't update the database.

Is there anyway I can get the values of the unchecked checkboxes? Or there any method that I can use to make my form work?

Checkbox Combine
I want to let users select one or more of my 5 choices in checkbox format, but also want to have a choice that is "all 5 choices". When "all 5 choices" is selected, I want to make sure they can't check any of the 5 choices. Is this possible?

Readonly Checkbox In ASP
how can we set the checkbox to readonly mode so that its state can't be changed by the user. i used readonly = true but its not working. remember, i am doing this is ASP.

HUGE Checkbox
i have a single ASP page with an access DB, no separate html page involved.This ASP page searches the database and displays all the fields by default, then a user can select certain information they would like to narrow it down to. I have all the text based search working, i can display textbox checked based on the value stored in the access DB.
now my only part left is how do i create a TEXTBOX on the ASP form, where when a user checks it off it will only show the data that has that particular checkbox checked,
this is what the page look like
http://e.domaindlx.com/kaztro/sample.asp

Simple Checkbox To / From DB
I have a form that only has one check box in it for active / inactive. This form is when viewing a member record. My 2 questions are:

How do I get the checkbox into the form showing the state that it is in the database? - I can get a check box to show, but can not get it to show ticked / not ticked according to the database Code:

How To Use The Checkbox In ASP Code ?
<input type="checkbox" name="c1" value="c1" />

<%if request.form("c1") = "c1" then
response.write ("Hi I am checked")
else
response.write ("Hi I am not checked")
end if
%>

<input type="submit" name="b1" value ="submit">

what I want : if the check box checked print ("Hi I am checked")
else print "Hi I am not checked"

Checkbox Problem
In my previous program, I make 1 drop down menu which consist of author, dates, category,etc.

If it looks like that, I just need 1 variable which is name of drop down menu.

Now, I was asked to make like this: I have some check box which are: check box for author, check box for dates, check box for category, etc.

If I tick author, and type keyword "xyz" then the program only search for keyword "xyz" in scope author. The same condition if I want to tick author, category and title with keyword "xyz". Then, the program only search for keyword "xyz" in scope author, category and title. Code:

Checkbox Question
I have a script that will work on it is own, but the problem is the site I
am trying to implement the checkbox on a site with attachments on the same
form. In my testing I check LOW. Code:

Asp: Delete Using Checkbox
I have an asp page that will delete using checkbox. This checkbox I have assigned the username field as the delete refference.

value="'<%=viewLec("username")%>'">

But now..I want to assign an no field to the checkbox as the delete refference, but it did not works!!!

value="<%=viewLec("no")%>">

I think it has to do something with my delete sql command! Code:


Copyright © 2005-08 www.BigResource.com, All rights reserved