I have form around a table. The form contains checkboxes for whihc elements are selected, and hidden fields listing the current value of the elements, and the line identifier for every line so I can tell precisely which subset of the table was visible to that person at that time.
I need to determine if a line that is not selected was prior to this submission. Something pseudocode-wise similar to:
If (Len(Request("DueDate-" & TheItem)) <> 0 ) AND (Request("DueDate").Contains(TheItem)) then
Where Request("DueDate-" & TheItem) contains the current value of the line (not blank since the entry has a length). The second part is what I have a problem with. Without manually looping through Request("DueDate") to do a search, I have no way to tell if Request("DueDate") (which contains a list of selected items) contains the line I am examining.
I am trying to total the value of some form fields I am referecing the form field with an inner loop, I am having a little trouble because the amount of fields returned is always different, how can I roll-up the total of the form fields (request.form("subtotal_"& i)) to get one final figure? Code:
I know I've seen a tutorial on this, but can't locate it. I have a form that I've written that submits into a SQL database. I'd like it to fire off a notification email as well when an entry is submitted. Can someone point me to a tutorial that explains how I can do this?
I have a form with textboxes,and a select option(country)..onchange of select element,i reload the form because i hit database to get cities of country selected.. whatever info user has entered is being stored in session variables.
my problem..as the form gets submitted onchange event of select user is able to write in textboxes but this info does not get stored in session varibles(but info written in textboxes before select is used does get stored and i am able display again onload of the form). how can i tackle thisproblem.
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2.
I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do...
I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
I have an user.asp page(has html display) which displays the controls; After client-side validations, I do a document.form.submit() to a process asp page(no html, only server side processing and then redirects to the user.asp). This process asp calls some dll functions which might take a couple of hours if number of records to process is huge. Now, the dll opens a pop-up window which shows the status of the results(number of records processed and failed). After exactly 1 hour, the user.asp page says page cannot be found. Is it due to some timeout or something? What could be the reason?
Does anyone have a suggestion how I could debug this problem:
1. Data is collected from database and displayed in a form. 2. User updates data and submits it. 3. Submitted data is compared with old data. 4. SQL is generated for changes and put into an array. 5. SQL in the array is executed line by line.
I've copied the code which does the update from a working page that does something similar. And tested it with a basic update to be sure. But for some reason when I submit this sql:
update table set currency = 'USD' where currency = 'GBP' and company = 'LQ' and supplier_id = 'BCX0926' and invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At this point the whole site becomes unusable until I restart the IIS Admin service.
I've pasted the sql into Toad and tested it there and it works fine. Could anyone suggest what the problem is, or how I could go about debugging it. Normally when I get errors thet are written to the screen. But in this case, I dont get anything back at all. Code:
Say I retrieve and e-mail adress from a form like this, then I know how to check that it's not empty, contain numbers etc. but I don't know how to check that the e-mail complies with some kind of regular expression or the like.
Therefore I wonder if you have any good e-mail form validation code that can be used on the server side (comparable to Java Script reg.exp on the client side).
<%
Dim mail mail = request.form("email")
IF mail = "" or mail does not complain with some kind of reg. exp THEN
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
I am looking for the best way to capture the time spent on a page and then write that to a txt file sitting on a server when the form is submitted. Right now I capture the time spent using javascript... I know i cannot write to a file using this. I am not looking to learn any in-depth ASP stuff... just looking for a simple solution if at all possible.
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
Im having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
I have a simple form to accept two form fields and display the values entered on pressing the submit button. The following is the form I have created to accept the two entries and display the form fields on pressing the submit form. It does not work can somebody please correct the code or provide a simple equivalent code where I can have the form and the validation and usage of the form values in the same ASP page.
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
I have a form that has approximately 7 text fields and 1 checkbox. Generally when this form is submitted(to itself BTW) it works fine, however, when the checkbox is only field that has been modified/clicked the form doesn't always submit. When it does work, a Stored procedure is passed form variables and updates to the db are made. When it doesn't, its as if the form wasn't submitted, it reloads and resets the page, but the stored procedure isn't triggered.
I have an html form where a serial # is entered and goes to an asp page to determine wether it is a res or comm number, then directs to another form where they can finish entering info to register the serial number. I want the second form to display the serial # entered in the first form. How do I do that??
I am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age.
The form has two subforms. One of the subform uses a physical test score which is basically four different fields while the other subform is one that has a written test score with three fields. Entry to both physical and written scores are done through this form. Both the forms can have multiple entries to make sure we are tracking historical scores.
The relationship between the ssn table and the physical test score table is 1: n while that between ssn table and the written score table is 1: n. With this scenario what is the best way to design form in asp pages?
have one form on an html page post to another form on the same page? I would like to have the information (all of the second form) hidden until the post is sent to it. Is that possible too?
