A starting price grabbed from querystring is shown to begin with. Then the options are shown(prices next to them) with checkbox(populated with over 90 options) and the user selects the options and a new total comes up upon submit. So the total of the options is a subtotal and the home and options together is the grand total. Code:
View RepliesI am trying to generate a querystring to a URL from a DB Value. Is this the right way of adding a querystring?Code:
<a href="Organization_UL_Revised2.asp?ID="<%=aTopManagers(c_Owner_Payee, 0)%> class="a_style" onclick="s_Hide('<%=aTopManagers(c_Owner_Payee, 0)%>'); return false;"><%=aTopManagers(c_Mgr_Name, 0)%></a><font size=1>(<%=aTopManagers(c_Mgr_EmpID, 0)%>)</font>
I don't want to try and reinvent the wheel so I'm looking for an ASP 3 script that will dynamicaly populate a nubmer or dropdown boxes from an access database, read a price from the the database and write both the selection and the price to a form and total all the prices too.
View Replies View RelatedI have a drop down list that is populated by a database, all the items are pure text.
I am using this line of code:
msgbox(listAccom.Items(listAccom.SelectedIndex).text)
but no matter what item is selected it always returns the very first value. However Identical code works on a different page I have created. Can anyone offer suggestions as to why this might be.
I have a simple form on my site with a drop down list for users to search for a specific category. The search works fine and populates my results page with the correct responses.
Alongside the results I have included the search form again so that users can modify their search, however I am unable to pre-populate the drop down menu with the previously selected category.
I have tried an IF statement but this only works when I hard code the variables in. Please can you cast your expert eyes over my code, I have a feeling I am suffering from fatigue as I have been trying to solve this for some time now. Code:
I am hoping a mixed ASP- Javascript programmer could help me with this scenario:
I have a list box populated with randomized records (NewID()) from a Broker (Salesperson) sql server table.
Each time the user selects one of the broker items I need to display a Image of the broker in the table cell next to it.
I have found a number of online js scripts that use the image selector route but I am unable to work out to populate the list item from the database AND at the same time utilize the JS...
Are there any coders who come across a solution like this. Here is an example of my ASP code populating the List box: .....
I'm using .getRows() with a local var array instead of doing a recursive
loop so that I'm being a good ASP newvbie and closing my object i/o's (the
recordset in this case) as quick as possible.
My problem is that I can't seem to use this to complete good effect because
the IsArray statement doesn't seem to work with a local var array that has
or has not been populated with the .getRows() property.
To explain, I used to do the following recursive loop (simplified to show a
concise example): Code:
i cant open any project in ASP.Net and neither can a create a new one
I have two strings that instead of adding them together to get the sum the are concatenating together.Does anyone know how I can get these two to add
while not rstemp4.eof
vservdate = rstemp4("servdate")
vdesc = rstemp4("desc")
vservhours2 = rstemp4("servhours")
vtravelhours = rstemp4("travelhours")
vtech = rstemp4("tech")
shvar = shvar + rstemp4("servhours")
thvar = thvar + rstemp4("travelhours")
rstemp4.movenext
wend
I am trying to add the values of a form. The results keep getting treated as a string and not an integer. So with :
theForm1 = Request.Form("number1")
theForm2= Request.Form("number2")
thetotal = theForm1 + theForm2
Response.Write(thetotal)
If the value of theForm1 is 4 and the value of theForm2 is 5, thetotal is 45, instead of 9.
how to add two numbers from two different textboxes and display it in the third box.
View Replies View RelatedThe problem i am having is adding 2 rs values to each other to come up with an amount.
so i have something like the following:
sql1 = "select sum(col1 + col2 + col3) as result1 from table where col4 = "y" "
set RS1 = Conn.Execute(SQL1)
pastdue1 = formatnumber(rs1("result2"))
sql2 = "select sum(col1 + col2 + col3) as result2 from table2 where col4 = "y" "
set RS2 = Conn.Execute(SQL1)
pastdue2 = formatnumber(rs2("result2"))
pastduefinal = (pastdue1 + pastdue2)
But when i do a response.write (pastduefinal) i get "0.000.00"
Does anyone have any idea? I replaced the formatnumber with formatcurrency but still didnt work. Am I using the addition incorrect?
I have a database with three feilds
Tbl_counter
ID
NAme
Count
Evertime the user clicks on a button in the asp page. I want to subtract on from their Count feild and then reinsert that value back into the database as ther new count value.
<%
dim n, c, t
n = request("number")
c = request("cost")
t = c+n
%>
This code returns 43 for c=4, n=3 instead of the sum 7. Do I need any thing else?
I presume it simply does not hold the variables?
On selection (could just as easily be a text field) I want to do two thing.
1) See how many times the script is run, after 5 attempts go to next page.
2) When a number is selected/typed in it should be added to the previous number
Basically I want to stop the page at either a number of loops if it reaches 5 or when the total summing of numbers equals say 4. Code:
Can I add two request objects?
View Replies View RelatedI have 2 radio buttons, Yes and No. I have a text box with a value entered by the user. If the user selects the Yes radio button, I need to add 339 to the value they entered. They will submit the form to add the value...but the problem I am getting is, it keeps adding 339 more than once. If there is also a way...where they select yes and submit and go back to no...to set the value back to the value they entered.
How can I add 339 to a value the user entered without continuing to add 339 if the form is submitted multiple times?
I am trying to build the code that will add a specific column's column where something = something
Example
ID Name Amount
1 Bill 10.00
3 Ted 15.00
1 Bill 25.00
1 Bill 35.00
4 Jude 5.00
In basic word terms, this will describe what I am seeking:
SUM(amount column where ID = 1) ..... answer would be 70.00
I am already connected to the database and can pull out one specific field in a column, just can not add that column.
I have current date and iam getting by GETDATE() function. Now i would like to add coming 12 business days in this date. e.g ( today is 1st Feb and if i add 12 business days in this date then the date i will get 17th Feb).
how to do it. I know there are some functions in SQL server which can be used to get the business days. Please some one tell me how is it possible.
below is the code which is used for adding items and then displays the item
which is working fine i have a problem when i display the item if the user press f5 or does refresh it increases the qty.
so if u look at the code i get the product details from a earlier page if the qty which i get is 2 and then i do a refresh on the page the qty becomes 4 is there any way to stop it Code:
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?