i am trying to build an online test that records user input one question at a time. So each question is a form by itself. I want to make a single ASP file that will validate all the form results and write it to a database. How can I know which form is
calling the ASP file?
Also, there may be multiple users accessing the quiz at the same time. Do I have to do anything special for such a case?
When simultaneous requests to open an Access Database occur, the Jet Database engine returns an error stating: Cannot Open file, already in use.
I know this occurs because I'm using a file-based Access database, and it's locked while data access is taking place. However, at this time, its the only platform available on the site.
My question is, can I somehow use an On Error GoTo Blah statement to catch the error, clear it, and then attempt the ADODB.Connection.Open statement again?
I am dynamically generating multiple forms E.g.,
form1
form2
form3....depending upon the records
Onclick of a button i am passing the form name to another page through a querystring. I am opening the popup through window.open function. I want the value that calculates from that page to the opener page. For that I want the dynamic form name.
How will i write the form name in the code below:
window.opener.<form_Name>.<field_name>.value="aaa"
In that page i have 2 forms with exactly the same names on it's fields, but one is called form1 and the other one form2.
What i want to do is specifiy from which form i want to read it's fields using Request.Form
Is it something like Request.Form("form1.name_of_field") ??
Is it possible to have more than one form in an ASP page and determine via "request.form....." which form you want to draw results from?
example:
Can you do something like, "request.form.projecttype("id")" for the form named, "projecttype", and later in the page have another form called, "projectmanager" and do the same thing, "request.form.projectmanager("id")"
Can I have one page "prod.asp" with 2 forms (form1 with ONE Submit Button and form2 with 2 submit buttons) submiting to same page "prod.asp" again?
View Replies View RelatedI have multiple pages based on a template (using Dreamweaver MX). This template is split in two parts (div); a menu area and an info (main) area. Each area contains a form. In the menu area form I have different form elements which determine the content of the info area (e.g. a combobox controlling which page is loaded).
Two of these elements are text fields holding dates. I need to fill the info area with a table of N rows, where N is the numbers of days between the two dates. As far as I know, the page has to be submitted to the server with these date and generated serverside. What is the best approach when I want to display result on the same page which submits the dates?
It is common with form collection to ASP that only one form is submitted to the server at any one time. The webmaster can save the information submitted right away.However when many forms are submitted at once, the prior data are deleted to let the new data be carried in the ASP.How can this problem be solved with ASP? Is this a limitation with ASP?Is CGI a better way of form data collection?
View Replies View RelatedI am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File Number
I am using sql server to store all the information.
I Need to collect about 400 pieces of text information (of various types and sizes) in about seven forms in seven different pages and post all the data finally to a database. I would like to know what is the best mechanism to pass data from form1 through form 7.
Users should be able to go to previous pages and edit entered data. Should I pass them as hidden variables or retain them as session variables or are there other more efficient ways to do this?
Also, I want to be able to later retrieve the data and porpulate the forms with the data so that users can edit the data and post it again. I am using ASP to do this (not .net). Any help from a generous programmer?
I'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies View RelatedI have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I have been trying to find a script on the net that would allow me to handle directory listings through ASP. I'm basically looking to change the default generated pages when browsing directories. Eventually I would love to be able to change which directories/files show based on permissions and be able to allow uploads to current directory listings.
View Replies View RelatedI am attempting to use url's on a database driven webpage - the url's are really ugly (created by mapquest) - I have tried to put " quotes " around the urls in the database as well as without - but all i get is a blank about page, can anyone help.
Here is my code:
<td><a href="<%Response.Write(rs("Directions"))%>" target="_blank">Directions</a></td>
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
how can i handle such cases and where do i place the code???
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
I’m trying to write a script that will select some records from an Access database within a certain date range one of the fields is a date. Code:
View Replies View Relatedsql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate
Where did I go wrong?????????????
Ugly response:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I want to error handling in ASP. But i think that ASP is not enough for
error handling. I have got two chance.
1. I can prapare an error page and control throught IIS.
2. I can use on error resume next.
For 1. This is a general handling. I want to handle local error. Maybe i do
special thing when error occured.
For 2. I have to write alot of lines code. I have to control every line.
if I have two strings as follows :
"1,3,45,65,777,89,00
and
"8,9,67,54,89,23
The numbers represent a predefined access permission to a certain file.
I need a function to sift through the first string, and compare it to the second string. What numbers are located in the second string, which are are located in the first string need to be removed (from the second string) leaving only unmatched numbers beind.
how use the array handling in asp
View Replies View RelatedIs there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
im following all single quotes as follows:
email = request.form.item("email")
email = Replace(email, " ' ", " ' ' ")
so as not to crash my database. Only problem is, when i take a value out of the database it now has two quotes instead of one (example Linda D'Agostini --> Linda D''Agostini)
i want to create a long string and save it inside rs("history")
what is the best way to save texts every action. with comma(,) in the end?
and how when i want to view the list i will be able to add <br> after every comma in order to view this all list normaly?
Can you please help me with event handling (for eg: capture key press, mouse overs, mouse_over drop-down menu, on_click drop down box) in asp.
View Replies View RelatedI am using global.asax to handle my web application exceptions and have
configured it to create event log entries for errors that occur and to
display an error page advising the user to contact the helpdesk.
I have an intermittent uninitialised object error that I am not able to
reproduce in test and for which I really need the source line number.
I believe this information is contained in the PDB but am not sure if one is
created if I set the debug="true" flag in the compilation part of the
system.web section of the web.config when the application is recompiled.
I want to handle events of the AO Connection object in my ASP page. How can I do it?
View Replies View RelatedI have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
Here is my code: ....
i have a scenario where i have to serve users of my site questions on daily basis,but before they can answer a question they must answer a previous question correctly served previously before the current day .
This means to me that i have to keep a log of each questions served each day and users response whether they attempt the questions or not .i am scared to keep a scenario of a million users each day,their actions on a particular questions.what is the smartest way to achieve this.
We are interfacing an ASP page with a COM object. In the COM object, if there is a condition that makes it not possible to perform the requested action, an exception is raised that can be caught by the calling application.
When an exception is raised by the COM object during the processing in the ASP page, the processing seems to lock up on the ASP side on the line of the function call that raises the exception.Has anyone else ran into similar issues? If so, how can we work around them?
How i can handle the errors in ASP. Please suggest something.
View Replies View Related