I have an ASP form that has a field that automatically places the current date into it. It uses the function Date().
The problem I am having is when the form is submitted into my Access database the date is coming out wrong in the Access field. The datatype for the field is Date/Time but it still is not coming out right.
Example: the date in the ASP form shows as 12/19/2006 and the entry in the Access form shows 12:00:27 AM. If I change the format of the Date/Time field to Short Date, the result is: 12/30/1899.
Does anyone know how I can get the data that is posted to the Access database to come out the same as the ASP form?
I have an ASP form that users enter a number into. The form then posts the number with a hidden login and password to a web address which opens in a new window. However, I want make sure that the number they enter is not one of the numbers I have in an Access database table that contains a list of numbers they are not allowed to enter. How can I do this?
I have an ASP form that has a field that automatically places the current date into it. It uses the function Date().
The problem I am having is when the form is submitted into my Access database the date is coming out wrong in the Access field. The datatype for the field is Date/Time but it still is not coming out right.
Example: the date in the ASP form shows as 12/19/2006 and the entry in the Access form shows 12:00:27 AM. If I change the format of the Date/Time field to Short Date, the result is: 12/30/1899.
Does anyone know how I can get the data that is posted to the Access database to come out the same as the ASP form?
Is there a way to get data submitted to the server without using a form? At the moment I have a very complex form that takes a very long time to load (about 30 seconds), and at intervals I want to send save commands back to the server so that the dynamic information on the page can be saved. The problem is that if I do it the normal way it's frustrating for the user because they have to wait another 30 seconds for the page to reload.
I've also tried using a hidden IFrame and submitting that, but it slows the page's initial load down even more and is causing a bit of an administration nightmare. Also, the program stalls while it waits for a response (success/failure) to come back to the client.
I am developing a page that when it loads up, it will display certain information from an SQL statement using preset values. However when the user is using the page they can then use drop down menus, to choose different year, suppliers etc, the page then needs to reload showing this new information.
I think it is possible to do this using the response.redirect, and direct it back to itself, with all the new variables. However some information will stay the same and I just wondered if it was possible to only reload the information that was required to save on server time running sql statements taht need not run.
A coworker is creating a form. The user fills in some numerical data. We would like to present them with a Calculate button that they can use to submit their numbers and be presented with the same information but also with the totals at the bottom. BTW, we cannot use JavaScript so it must all be done using server-side ASP.
That part is fine but we also want to provide them with a Submit button in addition to the calculate button. Now, I realize that if both buttons are contained within the same <form> tag, there can be only one action URL.
We toyed with the idea that if name=calculate, display the original form with the fields filled in and the calculations done and if name=submit, redirect to the thank you page but given that the method is post, then the redirect would not transfer the post data. If the method was get, then the redirect could include the query string data in the URL but that is not the case.
I don't know if this is possible or if it even makes sense, but this is what I want to do. I have a page with a form to fill in a timesheet for a user. Depending on how many users did a "job", a form will appear on the page for each user. So basically, you could have 3 forms, all with the same names etc.
and the only thing distinguishing them is a hidden input with userID and different data for each user. Now what I want the person to be able to do is fill out all the forms on the page and submit them at one time, rather than one at a time.
Then in the asp, I'd like to iterate through each form that was submitted (obv I don't know how many were so I assume I'd go through a collection if one exists) and process them one after the next. Is this possible and if so, how do I submit them all together and how do I then go through them on the asp side.
Currently I'm able to run the insert with a form that is fully filled. My problem is I want to allow the user to leave some fields and be able to submit the form.Any ideas how I should do that?
I have a form where students can enter their evaluations which are sent to a database. The asp code has been working flawlessly for more then two years, but suddenly when they hit the Submit button, nothing is written to the database.
Instead, the code of the submitting script is shown. No error message is shown. As far as I can tell the code is unchanged, but obviously something has happened. I would be grateful for hints on where to start looking.
how I can submit a fomr into an iFrame on the same page? example: I have a page called search.asp and in it is a form with one text box and a submit button. Once the submit is pressed, I want the iFrame to be updated with the results from the database. (I tried adding target=[iFrame name] to the form tag, but this loads the whole page into the frame)
I have a form that currently input data into an access db. The first thing that I would like to happen when the Submit button is clicked, is to check one column in the database to see if there are any duplicates before uploading any data. So my question is, how?
I want to be able to post data from a form on one server to another server at regular intervals. I know the XML parser is built around this kind of technology and can post information to a server.
Is there a way of either posting form data to a seperate server without user interaction either using the XML parser or by generating a form and using some JavaScript to autosubmit a form once the page has loaded.
I have stripped it down to the basics for example purposes.
At the moment, if user completes all required textboxes, it submits to itself. I need to set it so that if the form is completed properly, it sends all the values to a validate page where I will set up my connection etc and submit to a db.
Where am I going wrong and how can I get the form (after doing the validation checks) to submit to another page? Code:
I am trying to send information that I collect using an ASP form to a fax number that I specify somewhere. Can someone please tell me whether I can do that using ASP code and if so, how can I do it and what kind of applications I need to have if any.
i am having with a different page this page works in mozilla and firefox and doesnt work in internet explorer what i am trying to do on this page is when the user clicks on submit button show him a different page works fine in mozilla not in internet explorer.
i have tried changing the type to button instead of submit it still doesnt work in internet explorer it doesnt give an error but it just doesnt submit the page here is the code can someone tell me whats wrong in it Code:
I have a form with 2 text boxes, both of which add to a database and make up a dynamic page, i.e. page title & page text.
I want however, before the user can add the page, for the page to be previewed in a popup window. So effectively there'd be a button which when clicked would open up the new window, load the preview.asp page I have already built, and display the contents of what was typed into the text boxes.
So basically I need to pass the variables through to this preview.asp page - anybody know how I can do this?
I want a form to submit to a different page depending on what selection has been made in a dropdown option box. However something is going wrong my code looks as follows: Code:
We have a facility on our intranet where users can log problems, comments & suggestions about the site to a DB.
I'm building a page that lists the outstanding entries, and allows use to mark any number of entries as being 'done'
That is, we have a number of rows, with the last field in each row being a checkbox to indicate the entry has been dealt with. At the end, there is an Update button which submits the form.
The question is.. how to handle this...?
The best solution I have thought of so far is to use the record ID as the ID for each checkbox. Then to Split() the resulting Request.Form into an array, loop through the array picking out the record IDs.
It's not a bad solution, but I figured this must be a fairly common procedure and that somebody might have a slicker way of doing it...
At the very top of the page I try to get the value by saying:
newtest = Request.Form("testval1")
I got the example from here
The trouble is, my page instantly throws an error. I think it's because when I first load the page up, it's obviously not coming from a form submit! Can anyone shed any light on a way around this?
When I press enter on my Password field in my asp page it submits the form. If I do this in a straight HTML page it doesn't submit the form. I don't want the form to be submitted until the submit button is clicked. Has anyone got any ideas on this please?
Also, I know that the Java code to submit a form is frmForm.Submit(). Is there an asp equivalent? Is there an alternative to using Repsonse.Redirect?
I would like some help in having the form check to see if the selected course is available before submitting the info to the database and instructs them to choose another date if the course is closed. I have a qry that does a check and brings the information on availability. Any way to run that qry -check and send back the message or submit the confirmtion?
I am in the process of developing an application and would like to hide the query strings in the URLs. I want to POST data to a page then validate the data. If there is an error I have to send data back via a long query string. Is there anyway to POST data between pages programmatically?
"SELECT id, title FROM Businesses WHERE Date_Added >= " & Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does not seem to be able to recognise Request.Form("Since_Date") as a valid date. The Since_Date value is entered into a form field as "01-Jan-2005" and appears to be treated as a date; when viewing the SQL statement(with a response.write) it shows the date as 1/1/2005 even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck, although this was the treatment that worked when the SQL statement was running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
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:
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 am making a small ASP application that retrieves data from a MS access file and what I'd like the application to do is to retrive only data about items that expire in the current month. I have been trying to figure it out for a while now and have not been able to find the right tools yet.
If I try to explane a little better then the problem is that I need this to work automaticly. I have already made the application retrieve the right data but I have to change the filter conditions every time a new month starts. What I need is to have these changes made automatic.
I have a website where people can add job vacancies to our database. In the admin section I can delete these vacancies but have trouble with selecting certain dates from the database.
For example if I wanted to delete all the jobs from the database for the 18/12/2003 I would select the date then all the jobs will appear on the screen and I can delete them. But if I select a date such as 06/12/2003 or 11/12/2003 it doesnt display anything from the database when I know there are a couple of hundred in there for those dates.
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 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.