I have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
I have a Stored Procedure with a Where clause for a date range, I would like to know is it possible to add onto my Classic ASP two select input boxes for filtering my date column?
For instance filtering January 15, 2008 thru February 14, 2008. If so would you be able to show me what that might look like?My where clause starts on 01-01-2005 and end on a future date, for example 12-01-2040
Can anyone point me in the right direction for dealing with a dynamically created table of shopping cart items? Each row (or Item) has a column where the user can change the quantity. Is there an easy way to grab and use these changed values when they hit the form submit button?
Or, do I need to bite the bullet and write code that filters through the form fields named "quantity1," "quantity2," "quantity3," etc... And then determine which one goes with which cart item?
I have sent form data through email using .asp before but I have never done it when you are using a form that has createelements involved. I have a form w/ 3 inputs, two text inputs and one select combo box. if i click an add user button it will appear with another row of 2 text boxes and a combo box, and you can repeat up to as many as you need. I am trying to figure out how to mail all of those values to someone. Is there an easy way. Below I will attach the code that I use to name the fields when they are generated maybe it will help....
<SCRIPT language="javascript">
counter = 1
function addRow(id){
var tbody = document.getElementById(id).getElementsByTagName("TBODY")[0];
var row = document.createElement("TR");
row.setAttribute("id","tr"+counter);
var td2 = document.createElement("TD");
var input2 = document.createElement("INPUT");
input2.setAttribute("type","text");
input2.setAttribute("name","pName"+counter);
input2.setAttribute("id","name"+counter);
td2.appendChild(input2);
var td3 = document.createElement("TD");
var input3 = document.createElement("INPUT");
input3.setAttribute("type","text");
input3.setAttribute("name","userName"+counter);
input3.setAttribute("id","prc"+counter);
td3.appendChild(input3);
var td4 = document.createElement("TD");
var input4 = document.createElement("select");
input4.name = "Role"+counter;
input4.id = "Role"+counter;
option = document.createElement("OPTION");
option.value ="Admin";
option.text = "Admin";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read";
option.text = "Read";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read/Write";
option.text = "Read/Write";
input4.add(option);
td4.appendChild(input4);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
tbody.appendChild(row);
counter++;
}
</SCRIPT>
How to select query according to User Input for a WebPage in C#.Net with SQL Server 2000.I am trying to build a web page in C#.NET with SQL Server 2000 using Visual Web Developer 2005. I want to select and execute the query according to user input.
I have a form which has 2 textboxes which gets start date and end date from the user. Based on start/end date my 1st query runs. Now if user does not enter any start/end date I want to run another query which takes default dates from database(which is in varchar:ex. now()/now()-180) according to logged on user's permisstions.
How to select query ?
I've got a form that updates a record in a database. A select box is generated based on the values in a separate table. What I'm trying to do is have the current value of the field appear as selected and have the rest of the list populate with the values in the table in case the user wants to change the category. In other words:
<select name="library_subject_1">
<%
While (NOT catalog.EOF)
%>
<option value="<%=(catalog.Fields.Item("library_category").Value)%>"> <%=(catalog.Fields.Item("library_topic_grouping").Value)%> - <%=(catalog.Fields.Item("library_category").Value)%>
<%
catalog.MoveNext()
Wend
If (catalog.CursorType > 0) Then
catalog.MoveFirst
Else
catalog.Requery
End If
%>
</select>
Can someone tell me what I'm doing wrong?
I have a Dynamic drop-down box that is populated based on a ADO query. This works fine. I want to capture the users selection and assign it to a variable for use in another query.
I am using the onChange event to try and capture the users selection but it always passes the last entry in the drop-down list not what the user selects. I am very new to ASPJscriptVbscript. A snippent of the code is below.
<select name="cur_mgr"
<option value=""></option>
<%=Manager%>
</select>
How can I create a query based on the form input. I want to have a pulldown menu (list of states). The user can select the state, lets say VA and click on "go" button. I want the page to return results that has state=VA. So how do I create that statement and send to aspx ?
View Replies View RelatedI want to have a form like a table of record. If I let user input number of record to be insert in advance, how can I make a form that having number of rows of input? For example:
Number of records : 5
Then I need a input form like a table with the column and 5 row like Excel format.
The form:
Title Row : No. | Dept ID | Emp ID | Base Salary |
Input Row1 : 1 | | | |
Input Row2 : 1 | | | |
Input Row3 : 1 | | | |
Input Row4 : 1 | | | |
Input Row5 : 1 | | | |
I'm thinking all my input will be array. Then when user submit I'll split it and insert to DB. Code:
I have been ask to try a create a form on my works website to allow
teachers to fill it out the click button that emails to the boss
I thought asp is what need so i am very new to asp and with a lot of reading
from the net and books i got it to work :) but i tried to get too clever and
sent the user info to a page so the user can check for errors before
emailing but i cant figure it out and by fiddling too much i have stuff it
completely
can it even be done input info into form post that info to a new page
and then if the info ok email
i've recently done a basic website offline and haven't uploaded or found a host server yet. however i was wondering if there is a way to process the form input offline. I was told i need ASP functionality. but i'm not too familiar with it.
View Replies View RelatedI've got a form inserting some data into the DB.
When I try to insert data with "'" in between, say Dummy's.
I get an sql syntax error.
Heres my code:
strTitle = CStr(Request.Form(txtTitle))
sql_insert = "INSERT INTO db VALUES ('&txtTitle&')"
I can insert any data as long as it doesn't have "'".
Is there anyway I can go around it?
I am designing a website for a friend that has a backend database that holds information on all the stock they have and this gets displayed onto the page no problems.
The only problem I have is when they add new items to the database, a part of the form is a textarea and in this teaxtarea they copy generated code from paypal (a form that is generated by Paypal as a add to basket button).
The problem I have got is that if you try to add this textarea to the database field what you get is a image of the paypal button and no code.
I have tried the replace function, concatenated it in comments etc but all i get is a blank field or a image of the button.
I have a HTML page with a form on it. I have an ASP page that processes what a user has entered into the form (updates a database etc).
I now need a page that fits between these two pages to pre-process�the users input. I need to do it this way because I am not allowed to change either of the two existing pages.
I know how to read what the user has input into the form and I know how to pass control onto the next page.
What I have not been able to work out is how to change the user input and have those changes passed onto the next page as if nothing has happened (that is, the original ASP page just performs its request.form(�item�) calls as it always has but instead of seeing what the user actually typed in, it should see the changed text as created by the new pre process� page)
I have tried using a regular expression replace but can only successfully make this change a variable and not the original form input. Equally I cannot find a way of swapping the original form input string with the output variable from the replace.
Does anyone have any ideas on this one?
i have fixed my code and there was no error at all, it executed well and the msg "The quote has been sent" appeared. But although it was working, but it seemed that it didn't really sent the Firstname and Address to the email. Why? here's my code :
View Replies View RelatedI'm working on a form where the user is not required to fill out every text input. How mught I check for that in an ASP script. Here's what I have:
If Request.Form("mp3title1") == ""
amnt = 0;
Else If Request.Form("mp3title2") == ""
amnt = 1;
Else If Request.Form("mp3title3") == ""
amnt = 2;
Else If Request.Form("mp3title4") == ""
amnt = 3;
Else If Request.Form("mp3title5") == ""
amnt = 4;
End If
Pretty straight forward, its checking in order if the first element is left blank, is the correct technique:
== "", or is there more to it?
how do i allow the user to add in a value that has a ' in it (e.g int'l) apperantly if i do that there will be an error... how do i go about this?
View Replies View RelatedI want to send the data from a user's form input in an ASP email. For instance, shen the user submits their name and email address on a form, I would receive an email with those fields mixed in with a plain text message. How can I do this?
I have programmed extensively in other languages, but not ASP (our company is switching from ColdFusion), so I will need my answer in fairly introductory ASP terms.
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
I have a form, where the user types their initals and it then returns some results. However, the Oracle database requires the initials to be in capitals, how can I convert the user input to upppercase?
View Replies View RelatedI'm developing an account lookup, mostly in ASP, that displays a list of radio buttons to select one account from those found in a recordset. Here is a snip of the account display, after the recordset is populated: Code:
View Replies View RelatedI'm reading data from an XML form and prepopulating a FORM. For the text inputs I have no problem prepopulating the Values from the file...
document.forms[0].elements['FormName'].value=xmlObj.childNodes(0).childNodes(0).firstChild.text;
But one of my fields is based on input from a radio input (three inputs with a value of 1,2,3). Since they all have the same name using the code above will not set they value for any of them. Anybody else run into this, or have a suggested way I should do this.
I'm trying to create an input screen that allows users to create a hierarchical structure as the one below, but have no clue where to start or how to construct it. Code:
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other:
contact table id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
I am going to have a form on one page that will have a bunch of options(checkboxes, radio buttons, text areas, text fields, etc.) and these options are going to deal with a certain category. Each category will have different options. Now after this form is filled out they will then proceed to another page to fill out contact information. Name, Addy, State, City, etc.
Now, after they fill this contact form out they will submit it and then it will go through a database and depending on what state and county they are in it will email the information from both forms to the email addresses in the database that match that state and county(as well as category). Now dont worry I aint wondering how to actually search the db and all that yet.
All I want to know right now is how do you remember the first forms information while you go to the second page to fill out the contact information? Using cookies? What? I dont want the form input to be displayed on the second page, just remembered.
So I will select all my options from the first form and fill out all the text areas and fields and all that then click on the Next button or whatever, then fill out contact info.
How do I get it to retain BOTH forms information, and for now just display both of them on a third page(like I said I will worry about the db query and email crap later). I hope this makes sense.
I would like to exclude 2 or three input textboxes (hidden ones) from being
included when I click the "submit" button on a form.
write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
View Replies View RelatedI need a function for blocking or converting letters inserted into a Form to digits, since the Data will be used in mathematical functions.
Is there a specific seach-function for letters, or:
If Input1(not a digit) then...
Else... Input1 * 5...
?
I am currently making a form in asp and when i make the text boxes they are all formatted to the same size, even if I use the width=*** to change the size? Is there another way to make the input text boxes smaller or bigger?
View Replies View Relatedi have a form list box, which displays dynamicly. what i what to do is set the selected value where the O_R_ID = session("r_id") Code:
View Replies View Relatedit's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:
View Replies View Related