Checking Field To Make Sure User Entered A Number 1

[FontanaS]

Hi!

I have a quantity field where the user types in how many they purchased of an item.

Well someone yesterday actually wrote - "Five" and not "5".
So now I need to check to make sure it is a number.

Is there a function that allows this?
THANKS!

The field is -
IF ISNULL(Request.Form("SubOrderUnitPrice1")) OR ISEMPTY(Request.Form("SubOrderUnitPrice1")) OR Request.Form("SubOrderUnitPrice1")="" THEN
lvUnitPrice1 = 0
ELSE
***NEED TO CHECK HERE TO MAKE SURE IT IS A NUMBER***
lvUnitPrice1 = Request.Form("SubOrderUnitPrice1")
END IF

 

[QatQat]

the function you are looking for is ISNUMERIC()

if ISNUMERIC(request("SubOrderUnitPrice1") = false then

response.write("You must enter a number in the qty field")

end if

CHeers

QatQat

Life is what happens when you are making other plans.