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 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?
View Replies View RelatedI 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?
View Replies View RelatedI 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:
View Replies View RelatedWe 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...
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?
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 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?
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).
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?
Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:
the variable for the second email address is EmailFrom2
'validation
Dim validationOK
validationOK=true
If (Trim(EmailFrom)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom)
If (Trim(Name)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("nameerror.htm?")
If (Trim(CityState)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("citystateerror.htm?")
If (Trim(SchoolName)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")
If my user turns cookies off, both permanent and temporary cookies can't be used or only permanent cookies can't be saved on the user's machine?
View Replies View RelatedWe have an "API" that is written in ASP. Basically it is an ASP page that receive an XML Query string post and sends back a response as a "response.write". The ASP page does validation and SQL calls then eventually written to the SQL 2000 DB and send the response. This works perfect. It is similar how Authorize.Net users post transactions.
I am concerned about the availability and scalability of this. Our webserver is dedicated and the SQL DB is on a separate server (dedicated too). What happens when we have 100 concurrent users transmitting this query string to the ASP file? Will it freeze, hang, lose transactions? Is there a better way that does not re-writing in .NET or another language?
i have a task at work that i cant acomplish on my own. I have to create availability calendar of this type
http://www.villarenters.com/advert_price.asp?ref=5731&rag=10821A&rcam=myvillarenters&sag=&sc=
and to make it work with our database. I try looking for the code of this type of calendars but i couldnt find anything .
Please help me or tell me where i can find a script for this type of calendars (it must be a data base driven)
how can i create a button/link to check availability of a user ID against a an ID field. Code:
View Replies View RelatedI have this textfield named idNum and users are supposed to key in their id numbers into the field eg (S1234567D, F1234567Z). The id numbers either start with a S or F followed by 7 numbers and then end with an alphabet (A-Z). How can i check if the id number the user keyed in is valid? I'm using VBScript to code and the format is something like that:
If Request.Form("idNum") = "" Then
validateForm=False
errorMsg = errorMsg & "Please key in your ID number.<br>"
End If
Does anyone know where I can download an ASP based availability calendar, or have one that I can buy? I've trawled the web and can find plenty in CGI/Perl running on MYSQL but none in ASP running on MSSQL or Access.
I'm running a small villa rental website and need functionality like total cost of rental based on numer of days, different colours for days booked, two year forward looking, that kind of stuff.
In ASP (vbscript) is there a way to check to see if a SQL server is
online before trying to open a connection?
I have a situation where we have a SQL server that may be offline for
a couple minutes and right the ASP page returns:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I'd like to be able to first check to make sure the server is
available and if NOT, then skip the database connection on that page
altogether. Or, at least load the page without showing the error. I
have on error resume next but it still displays this error.
I'm having trouble verifying the cookie that I leave on a client's computer.
Here is the code: ....
How do i verify if the value of a variable is a number or a string? because i want to insert it on a field that only supports numbers.
View Replies View Relatedhow can i verify that an image is true?it has to be something like:
<% if %>
images/<%=rs("productid")%>.jpg
<% = true
then response.write("<img src="images/<%=rs("productid")%>.jpg"")
else response.write("<img src="images/nopicture.jpg"")
end if
%>
A field such as name was created to perform a search to find a person. However, if that person is not found, the user can click on the add button and it automatically populates that last name field in the add student form.
Is that possible to do the same with the student id number - by putting in the student id number and if not found click on the add button and the student id is populated on the next form? If so, how? Any tutorials would be very helpful?
how to go about creating my own custom ASP page that can show several different peoples availability from their Outlook/Exchange 2000 calendars?I don't want to have to ask users to setup permissions for their respective calendars, i just want to be able to see if they're busy or not.
View Replies View RelatedI am currently coding an accommodation rentals website and one of the searches required is an availability check.
At the time of booking you search for an accommodation that matches the accommodation type, no. of people and a start and end date from which to book.
I need to return a list of accommodations available using that criteria, I wanted to know if anybody has any ideas how to achieve this and do it efficiently.
at the moment i have a table that lists the accommodations and a bookings table that stores existing bookings.
Can anyone offer a good reference for a domain avialaibility checker? I'd like to create a web page to see if domains are available or not.
View Replies View Related