Submitting Data From ASP Form Using Date()
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?
View Replies
ADVERTISEMENT
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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)
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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...
View Replies
View Related
I'm trying to submit a form to the same page. Eg. (page name = test.asp)
<form action="test.asp" method="post" name="testform">
<input type="text" name="testval1">
<input type="submit" value="Go">
</form>
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
Can someone tell me how to submit a form from within a scripted page without anyone
having to manually click submit ?
Is this something that XML is needed for ? If so, I still need to know how to do it (G).
View Replies
View Related
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?
View Replies
View Related
"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
Any suggestions please ?????
View Replies
View Related
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?
View Replies
View Related
How do i select all records from a table that has a datetime field in it by date.
so i want all the records that was created today.
if i put only the date it doesn't work. this is what i have:
Code:
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = "& activerecord & " and timestamp <> '12/10/2007'"
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Can somebody give me link for me to find code or tutorial about finding all data between 'from date' to 'last date' & display it?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
