Form's DATE FIELD VALIDATION
how to validate a DATE field i have written my own javscript method but it's not considering all apects so is there any readymade method to check date.
View Replies
ADVERTISEMENT
Validation Forms
I am trying to validate the Postal Code and Telephone number and email within a form based on ASP/Javascript.
View Replies View RelatedLEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Field Validation
I've got a page whereby i need to make sure only one email address is entered. As multiple addresses causes havoc. Any ideas on how to approach this.
View Replies View RelatedValidation For Text Field
I need help regarding the string. In HTML page i have a text field to enter Name. How do i check whether its valid name or not, on the server side.
View Replies View RelatedForm Field Validation?
We have a shared hosting plan (Windows-based) with GoDaddy.com. GD.com has a
"generic" form mailer script (gdform.asp) that allows us to set up a
"Contact Us" page, which, when the user clicks "Submit" sends an email to
us.
I am a complete newbie re asp, but looking at the code, it looks to me as if
a error is generated if any of the fields are left blank--which is good. I
don't want to be getting emails that don't contain messages, or that don't
contain a return email address.
However, submitting a completely blank form results in me getting an email
with blank response fields.
Can you take a look at this code and tell me if it should be allowing blank
fields to be submitted? Are there any changes that can be made? Code:
Form Field Validation
I would like to make two field in a for required fields. Do you all know a simple way to accomplish this? I can post form and any asp if needed( page is getting really huge).
View Replies View RelatedForm Field Validation
I have a form field on an ASP page and was wondering if I can require the number that is entered to begin with a 0 or a 2.If the number starts with anything else,the user is notified to update the number correctly(Your [FormField] must begin with a 0 or a 2, Please update your entry).
View Replies View RelatedEmail Validation Field
I need to do an email validation field. I found this on the net . Code:
if (/^w+([.-]?w+)*@w+([.-]?w+)*(.w{2,3})+$/.test(myForm.txtEmail.value)){
alert("Email valid")
return (true)
Can some explain what the words in underline means ?
Text Field Compare Validation
I'm looking for a script or direction to help to find a script (maybe java?) that will validate an email based on comparing it to another email text field. So when one enters an email and then "confirm email. The two entries must match. This form is .asp. This should be client side validation and not through my server.
View Replies View RelatedForm Field Length Validation
Alright what I need to be able to do is to make the field it's maxlength if the user does not enter enough characters.
<input type="hidden" name="B" size="10" maxlength="6" value="">
so basicly if the user enters a 5, 4, 3, or 2 digit number the input will be forced to it's maxlength. I need this because I am writing to an SQL db and am combining multiple form inputs into one field in the db table ie(variable = A&B&C&D)
On a different webpage I need to display the variables. I am doing this by string manipulation functions like the one below.
Nbr = mid(aTable1Values(DATA, aRowLoop), 6, 6)
(DATA = A&B&C&D)
Min Number Validation In Text Field
i know in html you can set a "max" character limit for a form field.I was wondering if it is possible to set a min number of characters?
View Replies View RelatedSelect Statement Comparing Date() & Date Field Of Database
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View RelatedForm Field Validation Via Regular Expressions
I have a problem. Of course, or I wouldn't be posting here. Ok, now that Mr. Obvious is out of the way ...
I'm looking for some ideas. Take a look at the code below. I'm looking for the most efficient way to validate form field input on the server-side. I'll provide what I have. What I'm looking for are improvements.
<%
Function Validate_Input(Expression,Pattern)
Dim objRegExp
if Expression <> "" and Pattern <> "" then
Set objRegExp = New RegExp
select case (Pattern)
case "US_PHONE"
' sample matches: 1-(123)-123-1234 / 123 123 1234 / 1-800-ALPHNUM
' sample non-matches: 1.123.123.1234 / (123)-1234-123 / 123-1234
objRegExp.Pattern= "^([0-9]( |-)?)?((?[0-9]{3})?|[0-9]{3})( |-)?([0-9]{3}( |-)?[0-9]{4}|[a-zA-Z0-9]{7})$"
case "US_DATE"
' sample matches: 02/29/2084 / 01/31/2000 / 11/30/2000
' sample non-matches: 02/29/2083 / 11/31/2000 / 01/32/2000
objRegExp.Pattern= "(((0[13578]|10|12)([-./])(0[1-9]|[12][0-9]|3[01])([-./])(d{4}))|((0[469]|11)([-./])([0][1-9]|[12][0-9]|30)([-./])(d{4}))|((2)([-./])(0[1-9]|1[0-9]|2[0-8])([-./])(d{4}))|((2)(.|-|/)(29)([-./])([02468][048]00))|((2)([-./])(29)([-./])([13579][26]00))|((2)([-./])(29)([-./])([0-9][0-9][0][48]))|((2)([-./])(29)([-./])([0-9][0-9][2468][048]))|((2)([-./])(29)([-./])([0-9][0-9][13579][26])))"
case "EMAIL_ADDRESS"
' sample matches: asmith@mactec.com / foo12@foo.edu / bob.smith@foo.tv
' sample non-matches: joe / @foo.com / a@a
objRegExp.Pattern= "^([a-zA-Z0-9_-.47]+)@(([[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.)|(([a-zA-Z0-9-]+.)+))([a-zA-Z]{2,7}|[0-9]{1,3})(]?)$"
'The next line is supposed to be an RFC 2822 address compliant validation expression
'objRegExp.Pattern= "^(?:[w!#$\%&'*+-/=?^`{|}~]+.)*[w!#$\%&'*+-/=?^`{|}~]+@(?:(?:(?:[a-zA-Z0-9](?:[a-zA-Z0-9-](?!.)){0,61}[a-zA-Z0-9]?.)+[a-zA-Z0-9](?:[a-zA-Z0-9-](?!$)){0,61}[a-zA-Z0-9]?)|(?:[(?:(?:[01]?d{1,2}|2[0-4]d|25[0-5]).){3}(?:[01]?d{1,2}|2[0-4]d|25[0-5])]))$
case "ZIP"
' sample matches: 78754 / 78754-1234 / G3H 6A3
' sample non-matches: 78754-12aA / 7875A / g3h6a3
objRegExp.Pattern= "^(d{5}-d{4}|d{5})$|^([a-zA-Z]d[a-zA-Z] d[a-zA-Z]d)$"
case "CREDIT_CARD"
' sample matches: 6011-1111-1111-1111 / 5423-1111-1111-1111 / 341111111111111
' sample non-matches: 4111-111-111-111 / 3411-1111-1111-111 / Visa
objRegExp.Pattern= "^((4d{3})|(5[1-5]d{2})|(6011))-?d{4}-?d{4}-?d{4}|3[4,7]d{13}$"
case "NAME"
' sample matches: T.F. Johnson / John O'Neil / Mary-Kate Johnson
' sample non-matches: sam_johnson / Joe--Bob Jones / dfjsd0rd
objRegExp.Pattern= "^[a-zA-Z]+(([',.- ][a-zA-Z ])?[a-zA-Z]*)*$"
case "ADDRESS"
' sample matches: 2222 Mock St. / 1 A St. / 555-1212
' sample non-matches: [A Street] / (3 A St.) / {34 C Ave.}
objRegExp.Pattern= "^[a-zA-Z0-9s.-]+$"
case "CURRENCY"
' sample matches: $3,023,123.34 / 9,876,453 / 123456.78
' sample non-matches: 4,33,234.34 / $1.234 / abc
objRegExp.Pattern= "^$?([0-9]{1,3},([0-9]{3},)*[0-9]{3}|[0-9]+)(.[0-9][0-9])?$"
case else
Response.Write("Invalid syntax used to call form validation function.")
Response.End
end select
Validate_Input = objRegExp.Test(Expression)
else
Response.Write("Invalid syntax used to call form validation function.")
Response.End
end if
End Function
' Get data from the form collection and assign to variables
dim str_Customer_Email
dim str_Customer_Phone
dim str_Customer_Name
dim str_Customer_Zip
str_Customer_Email= Request.Form("email")
str_Customer_Phone= Request.Form("phone")
str_Customer_Name= Request.Form("name")
str_Customer_Zip= Request.Form("zip")
if not (Validate_Input(str_Customer_Email,"EMAIL_ADDRESS")) then response.write ("error")
if not (Validate_Input(str_Customer_Phone,"US_PHONE")) then response.write ("error")
if not (Validate_Input(str_Customer_Name,"NAME")) then response.write ("error")
if not (Validate_Input(str_Customer_Zip,"ZIP")) then response.write ("error")
response.end
%>
Now, I'll obviously want to do more than write "error" to the screen with the validated input. What I *really* want ideas on is a more efficient way to validate the fields. In this small example doing them as one-offs isn't bad. On a form that has 20-30 fields it becomes cumbersome.
Date Validation With JS
I have individual dropdown boxes for selecting day/month/year for start date and then the same for selecting end date. I have two javascript functions for validation.
I have one submit button on the form.
The asp code is below. I know each javascript function works in its own right. That is posted below the asp. My problem is to get the functions to validate both start and end dates on one click of the submit button. How it is at the moment, it will validate the first - start date- but throws an error (type mismatch CDate)on the End date.....
Date Validation
I have been pounding my head for two days now and I can't get this to work. I have tryed 3 different ways to write this but not working, so I turn to the GODS again.
<%
Session("delvdate") = Request.Form("firstinput")
%>
/-- ^ Checked this part above, works fine
<%
itis = date()
if Session("delvdate") = itis Then
Session("wrongdate") = true
Response.Redirect "order1.asp"
Else
Response.Redirect "quick_pad.asp"
End If
%>
What I'm trying to do is if the selected Date ("delevdate") = todays date, send them back to "order1.asp" to select another date. But this code is allowing them to quick_pad.asp even know todays date is selected.
Date Validation?
This is really for my CMS(Content Management System)
For such areas like news, I am using a three selection drop down boxes, one for the day, the month and finally the year.
So I have created three variables like so:
dDay = day(date)
dMonth = month(date)
dYear = year(date)
So the element for my date looks like the following: ....
MS SQL Database Field Date Comparison To Date()
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
Comparing A Date Field To A Date In A Form.
"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 ?????
Date Validation Problem
Here is a simple problem to slove........
I have a text box and I want to check if the value isn't null or the value is equal to a date. if it doesn't then it displays a message box to the user.
Validation Of Date Fields
if you knew anyting about validating dates and when entering data into a database that already exists, how to bring up message boxes. I am currently using dreamweaver mx and its validation rules in behaviours is limited.
I need a message box to tell a user that what they are entering is not a date when a date is required, instead of dreamweavers microsoft access error, criteria mismatch or whatever. Also a message box to tell a user that when they enter a record in a database that it already exists, instead of dreamweavers automatic error.
Javascript Date Validation
I have a form that has two date fields, would like to validate both of them before proceeding. Have code that works really well for one field. Have also discovered that when doing validation that it is best to use only one javascript function, not two or more (because if one passes and one fails it will proceed!!!).
I need to call a javascript function. That function has several parts to it. On pass let the valid = true, on fail alert button. So far so good.
In the form it would look like onSubmit validform(). I dont send any at this stage. But in the function itself I need to test on field and then another. Code:
Date Validation Function
Does anyone have a date validation function that checks if the day month and year are all valid. For instance, if it's a non leap year and the date 29th Feb is entered?
View Replies View RelatedDate Validation And Calculation Of Months
I have this form where in i calculate the number of months
between 2 dates.It calculates only if both the textboxes have values.
And then i display this in another text box.
The user has to enter the date in DD/MM/YYYY format. user can select
date from calender popup. Apart from selecting the user can also type in
the date.
I am using a function which splits the date entered by the user
into DD MM YYYY and then compares each of these values to see
if its in the valid range like day is between 1-31, month between 1-12
etc.
But i m having a problem. If the user enters characters instead of digits,
my system accepts it in the first box without giving error and then when
the user selects a proper date in 2 textbox its gives an error: 1 is null
or not an object. this error comes at the place where mt function splits
the entire date string into DD MM YYYY.
Could someone please give ne a solution, a way to format the date so that
i let the user enter first 2 digits and then a "/" and then 2 digits and then a
"/" and then 4 digits only.
Locale-dependent Date&Time Input Via HTML Forms -
In our legacy asp/web-application, we have
date/time-input form in USA style
(i.e. mm/dd/yyyy and 12hour-scale time with AM/PM).
There is also some validation code on client side,
and then submitted data are used in MSSQL queries.
Now I would like to know about how to generate locale-dependent
HTML form layout, and what ready-made ASP code could I borrow
for this task.
Retrieving Date Field
I am trying to retrieve a date field this is the code
strQ ="SELECT * FROM WaterCompanies ORDER BY WaterCompany"
set objRS=objConn.Execute(strQ)
This is where I am using the date
Response.Write "<TD>"
Reponse.Write objRS("JoinDate")
Response.Write "</TD></TR>"
all the other fields populate so I know I have a good connection.
this is the error
Microsoft VBScript runtime error '800a01a8'
Object required: '' /waterbilling.asp, line 76 <--- this is the response.write objRS("JoinDate") line
Format Date Field
i need help formating todays date minus one.
i can get this 1212006 but i need 12012006
How To Prepopulate Date Field In Asp With Sql
how to pre populate the date field in an asp form which is using SQL database?
View Replies View RelatedTime/Date Field
I have a few date fields on my form. The backend is SQL and the fields are set to smalldatetime. Adding records into these fields is not a problem. This is my code:
if Request.form("ScheduledTrainingDates") = "" then
else
objRS("ScheduledTrainingDates")=Request.form("ScheduledTrainingDates")
end if
The problem is updating the records when I got to edit them. Let's say I have a value in for ScheduledTrainingDates textbox, and I want to clear the value and leave it blank and save it to the database. How do I do this?
Validating A Date Field
I have a form field which asks for a date to be entered in the format of dd/mm/yyyy. Now, I've successfully programmed it so that you can only enter a date in the present or future but not in the past. However, as it stands, it also means the user could enter an unrealistic date such as 12/12/2070...I don't want this.
What I'm after is some ASP code which only allows the user to enter a date that occurs between the present day and say, the next month. So if the user was to enter 05/03/06 then the valid dates that would be acceptable would be any date before 05/04/06 i.e. One month.
Two Field Date Search
I'm trying to create a search page with a beginning and ending date, but I can't seem to get it to work. I am using SQL Server. Here is my statement:
SELECT *
FROM dbo.REQUEST2
WHERE REQUEST_DATE BETWEEN ' " & Request.Form("txtBeginDate") & " ' AND ' " & Request.Form("txtEndDate") & " '
This statement is not returning any records when I know there are existing records that fit the criteria that I'm entering.
Search A Date Field
I have a form where I offer the user to enter a 'fromDate' and a 'toDate' whereby I had hopes that it would help return records where the date was between those two values. My SQL query ends with: Code:
AND Date < " & request("fromDate") & " AND Date > " & request("toDate") & "
and a typical date entry in the table looks like: 2/8/2005 .
Compare Date Field
Need some help with comparing a date field retrieved from an access date base to the current date. Basically I'm looking to create and if statement like:
If strArticleDate < = Current Date then
else