List:General Discussion« Previous MessageNext Message »
From:Graham Ashton Date:April 21 1999 10:49pm
Subject:Re: Is there a way to know if It's a number?
View as plain text  
On Wednesday 21 April, Christopher R. Jones wrote:

> >This is really a data validation problem and is best handled 
> >BEFORE the data goes into the database. Presumably, you have 
> >some sort of CGI script that accepts the data from the form, 
>
> I agree, a database is supposed to be designed with integrity in mind,
> thus, numbers should go into number fields.  I use Javascript to check for
> valid numbers, the feed back to the user is instant and reliable.  

It's not that reliable. If the user has turned javascript off on their
browser then all your validation goes up the spout. How do you handle
that one?

Surely, the best place to do the validation is the CGI.

-- 
Graham
Thread
help! restoringpete collins19 Apr
  • Re: help! restoringChristian Mack20 Apr
    • Is there a way to know if It's a number?Jochen Haeberle20 Apr
      • Is there a way to know if It's a number?Michael Widenius21 Apr
        • Re: Is there a way to know if It's a number?Paul DuBois21 Apr
  • Re: Is there a way to know if It's a number?Benjamin Scherrey21 Apr
    • Re: Is there a way to know if It's a number?Thimble Smith21 Apr
  • Re: Is there a way to know if It's a number?Fred Read21 Apr
Re: Is there a way to know if It's a number?Christopher R. Jones21 Apr
  • Re: Is there a way to know if It's a number?Graham Ashton22 Apr