Re: Is there a way to know if It's a number?

[Graham Ashton]

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