Problem with Currency Input.

[Syerston]

On one of my pages the user is required to add a currency value. This value then has the "CCur" function applied and
is added to a SQL string.

The problem is if the user decides to add a £ before the number it returns an eror.

Is there a way around this. John

 

[Tarwn]

Simply run a replace function on the amount to replace the £ with nothing:

mymoney = Request.Form("whatever")
mymoney = Replace(mymoney,"£","")

tada! You may want to use the character code for £ to be safer, but it should work anyway as it is a recognized character.
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation

 

[Syerston]

Thanks Tarwn

It worked a treat John