Currently i am using this function to update the database for the values of the checkboxes. Anyidea on how to go about including the values of those not selected. 0= not checked 1=checked
MenuName | Super | IT Menu1 1 1 Menu2 0 1
Code:
for each chk in Request.Form("opt") sSQL = "UPDATE GroupAccess SET IT = 1 WHERE MainMenuID = " & chk Conn.execute(sSQL) next
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:
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?
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.
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.
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.
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.
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?
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.
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?
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.
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 ?
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.
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??
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?
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?
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.
