I am developing an application ASP and desire to validate the fields of dates before jumping to consultation SQL, the dates is entered text boxes and the idea is that been worth when losing the Focus. How I can do that?
is there anyway that I can validate my date format in asp?? I have tried like date=now(), that gives me like 5/14/2004, the format should be mmddyy, no space,no dash,and has to include 0 if month is from 1-9, for example 01, 02, like that?
I am trying to compare a variable with a db plain text field as follows: access db has field named HFRNUM as text .... ex: 12182003-A
I create a variable in vb as follows: Dim hfr_today HFR_Today = (Month(DATE)) & (DAY(DATE)) & (YEAR(DATE)) & "-A"
Unfortuantely, I think the HFR_Today var is not text and when I look for a record that is LIKE or = the var, it returns blank.
I display my variable and see 12182003-A, yet it does not find the record that matches (except data type perhaps?) Is my variable of a different data type, and if so, how can I make it plain text?
i have a date format d/m/yyyy h:m:s which users pick from a date picker into a text field in a form. But i want to format the contents into this form - d/m/yyyy.
Pls is there a function i can use to achieve this . I tried format(date_field) but it didn't work.
i need to put a date of the following format: 14 June 2003 into a text box. i have seen some samples but i can't get what i want. i tried the following: <%=FormatDateTime(todaysDate,0) %> and it only rendered 00:00:00 .
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I have a date entry on a form that must be at least 30 days from the current date. It is a delivery request date and the soonest it can be processed is 30 days from the request. I need code to validate and message should they enter a date less than 30 days from the current date.
I've been given a task to write an function to validate URL's used on a website. The URL's are going to be kept in a table with other fields to indicate if the URL is valid and when it was last validated.
Any URL's that aren't valid won't be displayed on the site. Is there a way in ASP to check if any given URL returns a 404 error?
I have created one of those change your password forms whereby the the old password and new password are provided.
What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:
Code:
'Check Password
if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then
response.write "Invalid password"
end if
Else
if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then
'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "
I have a form which consists of a few fields. The problem that i encountered was it seemed like just checking the first field only rather than all the fields. Code:
I am looking for a way to do a validation in the form that who ever is filling the form is a true person & not a automatic system. there is a way to do it with letters in an image & the user must enter the same letters in a text field.
I am wondering if there is a way to validate a user's login from 2 different tables. Currently I have a sql string that pull info from a table based on the users login and password.Code:
sqlStr = "Select * From authorised_user_table where username = '" & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"
My problem is I the passwords in this table are old, and I have a new table with all new passwords (same structure, just different passwords). I'm thinking most of the users don't remember their new passwords just the old. So is there a way I can query both tables? Something like Select * from table1..... else Select * from table2
I once saw somewhere, and I cannot recall the site / article... But I believe there is a way that you can "Check" an E-Mail Address to make sure that it is a Valid Email Address. NOT Syntax checking... But to actually determine if the email address typed in is a "Real" and "Active" E-Mail Address.
I realize this is not solely an ASP question, but I thought you guys might know the answer and I couldn't find anywhere else to post this. If you have suggestions for this I am more than happy to post somewhere else.
How can I, using ASP code, validate whether or not an email address is a real one? For example, if I have the email address called Join Bytes! how can I determine if it is real?
A form is passing "firstName" and "lastName" to your ASP page.show code how to validate them server side validation as follows:Only Alphanumeric characters,commas,hypens, spaces or periods are allowed in the last name.
Only A-Z, the hyphen are allowed in the first name.Both fields must be provided.Return a string value from your validation indicating to the user what is wrong with their entry. "
I am using this code to validat a checkbox in a very big file, the problem is,its not validating:
here is my code function checkAgree(theform){ if(theform.Agreement.checked == false){ alert("Please tick the checkbox to continue."); theform.Agreement.focus(); return false; } }
I have 2 fields on a form called 'name' and 'title'.
I want to make the 'name' field compulsory to fill in on a form. So if someone submits a form and the name field is not filled in, it will tell them and won't let them submit.
But I only want the name field to become compulsory when the 'title' field is filled in. So if the title filed is blank then the validation will not be effective but if the title field is filled in then the name field will become compulsory. Code:
I just realized that it's so important to validate each string, I mean 'each' before you insert data from asp page into database.
I guess some customers just copy data from some electronic document and paste intoform field which it will probably mess up the program.
for example, we have a customer who wants to enter AH12345 into one of our fields, it appears Ð?Ð?12345 in hidden field of our asp page, but it displayed AH12345 to the customer, but our program failed because of the data does fit into char field in sql database.
I don't know in reality, how other companies deal with those kind of thing. Do I have write our own regExp to validate each string, since we do need to allow apostrophe or "-" in first name or last name.
I have functions with which i can validate a URL from serverside. But, i need to valide the URL at the Client side (ASP- Javascript) itself. Is there any way to validate a given URL from the Client side.
I have a form that users fill in, thefirst field is a username, which must be unique.Currently only when I attempt the Insert into the DB does the restaint inform the user that it already exists.Is there any way i can check , let say onblur, if that username exists, so that they dont have to complete the whole form before being informed?
Function chkEmail(sEmail) Set objRegExp = New RegExp searchStr = "^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$" objRegExp.Pattern = searchStr objRegExp.IgnoreCase = true chkEmail = objRegExp.Test(sEmail) End Function