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:
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.
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 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:
