Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    49

    Unanswered: validation problem in asp

    hi, i am trying to enter data into an acess db via an sql website form. the databse feilds have validation. when a coorect value is entered in access it accept it, but when the same value is entered through the website it returns an error.

    the validation is for email address

    Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

    any ideas why access accept the value tony.smith@hotmail.com and asp does not?

    thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well then; first off what are the question marks?

    Secondly, you have the @ symbol before your full stop, so tony DOT smith AT is incorrect.

    With regards to email validation; you're far better of using regular expressions. Yes, they are more complicated to understand, but Google and RegExLib will give you everything you need fairly easily
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •