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

[Benjamin Scherrey]

What's the field type in your database table? If its a numeric type your
insert should fail for non-numeric data which is a pretty good indicator your
webpage entry was invalid. What client interface mechanism are you using for
your connectivity to the server (Java, Perl, et al)?

    later,

        Ben Scherrey

Jochen Haeberle wrote:

> is there a way to check if a value is a number?
> Something like SELECT isNumber(string)?
>
> I am having problems at my website the people are sometimes entering
> strings into fields that will be calculated with later on in MySQL
> (currency units). I know there are other solutions to checking if a
> value is a number (including JavaScript), but I do not want to use
> another solution just for this.