I am generating between 5 - 15 dynamic checkboxes in a specific database search. The user will at most only select 1-2, maybe 3 checkboxes at a time. Through a form, i want to find out what checkboxes were clicked and get the value contained in the checkbox.
Can any of you suggest a suitable method of doing it? i assume i'd be using a 'for' loop, if i can get a foot up on how i'd go about doing this
I am working in ASP and Access database.
I have a page with a form, inside the form there is a SELECT statement that pulls all relevent 'yes/no' columns from all relevent tables in the db and makes them checkboxes inside the form.
Now when i check or uncheck these boxes and submit them i need to have the db updated with all the relevent changes in all the various tables.
How can this be done? maybe there is a "FOR EACH CHECKBOX.." statement that can be used?
I have a page with a form, inside the form there is a SELECT statement that pulls all relevent 'yes/no' columns from all relevent tables in the db and makes them checkboxes inside the form.
Now when i check or uncheck these boxes and submit them i need to have the db updated with all the relevent changes in all the various tables.
How can this be done? maybe there is a "FOR EACH CHECKBOX.." statement that can be used?
I have some checkboxes that are generated from the results of a database search. At the moment, the checkboxes are part of a table making up a form. Users are going through the form, clicking the boxes and saving to the database at the end with the 'Submit' command button.
Is it possible to save the changes as the checkboxes are clicked? I suppose I'd need to write some dynamic ASP event handling at the same time as creating the checkboxes.. Code:
I have a form that users use to register with the site. On this form there are checkboxes all with the same name but different values. I am creating another page that will allow users to login and edit their information.
Since all the data from the checkboxes are stored on the database under the same field name and separated by commas; how do I dynamically create a set of the checked checkboxes that the user originally entered along with the other checkboxes the user did not click?
I have a feedback form which user completes and data is submitted to db. I then want to allow user to edit this form so I retrieve values from db and populate the textboxes. This is working fine. My question is how do I set checkboxes and radio buttons to reflect these values?
It must be something like 'if value is ?? then check the box', but what is the correct syntax and is this code placed within the actual radio box/checkbox?
ie. Radio: <input type="radio" name="Gender" <%if strGender = "1" then value="Check Checkbox" %> />Male
Checkbox Mail <input type="checkbox" name="ReceiveInfoByMail" value="<%=strReceiveInfoByMail%>" />
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;
}
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)
i want a tutorial for hiding/unhiding textbox with dynamic values when checkbox is clicked and vice-versa.
View Replies View Relatedif I create a dynamic selectbox from the table tblRewardsDetail - I can submit what is selected to tblLineItems BUT not the corresponding values.
For example if I select Item2 the corresponding value associated with that Item 50points does not write to the tblLine Items but ItemIden2 does. Code:
I have an asp page where im creating dynamic rows on an onclick function and textboxes are created in the dynamic rows and when i submit the asp page it goes to another asp page, where i whant the values entered in the textboxes of dynamically created row of the previous asp page. Code:
View Replies View RelatedWe use an ASP application in which we send out emails using cdo for various
events.
At present the email text is hard coded into the code. for example
strMessage = "Dear " & rs("firstname")
strMessage = strMessage & "Your request has been approved with reference id
" & rs("id")
This causes an administration overhead as everytime the text of the message
needs to be changed we need to alter the code to incorporate text or
database values.
What we want is to store the message text into a table so it can be altered
by the application administrators through GUI by adding the text through
freetext entry and field names though a dropdown. Code:
I've writen the code below which displays a drop down select menu and can be displayed by writing the variable 'sjobs'. The code works fine as it is and the menu is populated with the requested info from the database ok. The problem I'm having is adding url links to the menu values. Code:
View Replies View RelatedA page displays the Product literature that a customer can request to receive by postal mail by clicking a check box. The literature selections are created by a dynamic record set based upon what the company enters into the Literature table (currently 10 selections). The checkbox form tags are:
<input type="checkbox" name="LiteratureID" value="<%= rs("LiteratureID")%>">
LiteratureID is the Access autonumber primary key field. I can use the LiteratureName in the "name" attribute if it is easier.
The form processing page needs to Insert each selection into its own record in another table. This "requested" table also inserts the database ID for the customer that is created after first inserting the customer contact info. In other words the "requested" table needs to record the customer autonumbered db ID and each selected checkbox value.
Here is my current code:
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
View Replies View RelatedI want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
i need to convert the escape values which are by mistake updated in DB.
example:
this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string
here %20 is the space.
like wise there are many entries for :,'
is there way that i can update all this in a update statement?
or use asp to to update the records?
I have a form that has checkboxes. I would like when the user clicks the
process button the next page will display the value of the boxes that were
checked.
Do any of you guys know what the value of a check box is.
I am offering two ways to download, posting to a diff form and using info from there but do not know which check box has been ticked??
To get the checked value of checkboxes I use this code:
Code:
For Each subitem In oFileUp.FormEx("imgCheckBox")
...
Next
How can I get the value of those unchecked checkboxes?
I am trying to set up a page, with some input fields, which
are mandatory. Then there is a checkbox, when it is
checked, the input fields do not need to be filled
(not mandatory anymore). At the moment, even though
the checkbox is checked it asks to fill the mandatory
fields.
I need to add a master checkbox, clicking on which, will select all the child checkboxes. Unclicking it, will unselect all the child boxes.
Exactly the same way as hotmail does. I know, I need to write a javascript for that. But the problem is, the child checkboxes are being
populated from the stylesheet code (embedded in the .asp page). It is also not under the <form> </form> tag. Following is the code:
I've never used checkboxes in ASP, well nows the time i do it.Im creating a login script, and want the user to be able to click on "remember me"it keep them logged in.
how would i get that in ASP. how would i make it detect wether or not the checkbox has been selected or not?
I'm trying to create a form that has checkboxes on it that when a user checks the particular boxes, and submits the form, it performs the query based on the selections.
I'm using MS Access and FrontPage. I'm having problems passing the information from the form to the query and then to the database.
How can I use checkboxes to send out an email based on which checkbox was clicked?
For example, I have an html table that is constructed dynamically which contains information about events stored in a database.
The table has checkboxes out to the left side (similar to hotmail) and when I check however many boxes, and click submit, I want to send an email to each address that is associated with each record that I checked its box.Something like "for each checkbox clicked, select the ID and email address associated with it, and dispatch an email"
I have everything set up except the asp loop and select statement that will help me achieve this.
i have some 15 checkboxex on a form... i want to 1st check the no. of checkboxes that are checked?? and then loop it that many times adn insert the quantities the user enters in the text boxes.
do i need to group the checkboxes....hwo can i do that??? how to know which checkbox is checked because out of the 15 checkbox say 1,5,7, 9th are checked then i 1st need to get the id from the database adn then based on htat id retrieved i need to insert values on another table.
give me a working example on how to use checkboxes ?
View Replies View RelatedA list of names is printed out from a Table as a list of checkboxes:
<tr>
<%while not rstLogin.EOF%>
<%
dim name
name =rstLogin.Fields(0)%>
<td><input type="checkbox" name="<%=name%>" > <%Response.write (name)%> </td>
</center>
</tr>
<%
rstLogin.MoveNext
wend
What I then want to do is add "Checked" names to another table. How do I do this?
I've been using Dreamweaver to develop some simple database connectivity. So far everything works, but could be more user-friendly and flexible.
I have an Access database with 4 document types. I have search forms which allow users to enter a keyword and search for one specific document type. The problem is I need four different search forms this way. What I would like is to include 4 checkboxes and one keyword textfield. Code:
I have a page with checkboxes which are created from a database as below:
<% while not rs.eof %>
<%=rs("contract_name")%><input type="checkbox" name="<%=rs("contract_name")%>"><br>
<%
rs.MoveNext
wend%>
I need to be able to tell which ones are checked on the next page. How do i do this when they all have automatically generated names?
I have a series of dynamcially named and id'd checkboxes. each one has the same name but its id value is different. The ID value tells me which checkbox relates to a particular record in a recordset. I need to obtain the id of the checkbox and its value - so far I can only get the value as follows :
<%
For x=1 To request.form("BillNumCheckBox").Count
aSelected = request.form("BillNumCheckBox").Item(x)
response.write x & " = " & aSelected & "<BR>"
Next
%>
I have two related tables in my database. One stores events and the other stores a list of key topics.
I have an interface set up where users can add / edit events.
In the add event page, I am querying the "key topics" table and returning them as options (array of checkboxes). The user makes their pick, and submits. All the data saves in the 'event" table, including the primary id of the "topics".
That part works great. The problem I am having is when the EDIT event page resolves, I am trying to "check" the options that were previously saved.
First thing I do (at the top of the page) is to query the events table to pull all of the data out. I use the 'events" table to do this.
For the checkboxes, I am once again looping through them in a query that uses the "key topics" table. So the boxes are displayed, but I can't seem to get the logic right to have the appropriate ones checked. here is my current code:
I Have this form in page1:
<form method="post" action="page2.asp">
<input type="checkbox" name="numb" value="10">
<input type="checkbox" name="numb" value="20">
<input type="checkbox" name="numb" value="30">
<input type="checkbox" name="numb" value="40">
</form>
Now what I want is to add the checked values in page2.
For example :
if checkbox1 and checkbox3 gets checked I want to add the values in the
checkboxes which in this case is 10 + 30 and get the total sum (40).
Hope this makes sense?
So how do I retrive the checked values and then add the checked values
with eachother to get the total?