Check Data type/format of entry

[endoflux]

I have an html form input which I need to test for a valid numeric entry. Currently, all other data validation is being done at the top of my form post page before the entries are submitted the the database (ASP). In one case, I'm using the subroutine below for an alpha-numeric entry which has a specific length anf format; maybe there's a variation that would allow me to specify only numeric format/datatype, but allow any length?

Function InputMask(Recnum)
Dim sln
Set sln = new RegExp

sln.IgnoreCase = false
sln.global = false
sln.Pattern = "^[0-9][A-Z][A-Z][A-Z][0-9][0-9]$"

InputMask = sln.Test(Recnum)
End Function

If Not InputMask(Recnum) Then Response.Redirect ReDir2
End If

 

[EBGreen]

sln.Pattern = "^\d+"

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[EBGreen]

oops:

sln.Pattern = "^\d+$"

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[PHV]

Why not simply the IsNumeric function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EBGreen]

THat would work as long as decimal entries are considered valid in the context of the application. From the original post, I could see it going either way.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[endoflux]

WOuld the IsNumeric function work like:

If IsNumeric(Request.Form("Quantity")) Then...

In this case, decimals are not allowed; the former solution seems to work.

Thanks guys!