Validate a Decimal Number

how about a reg ex

/^\d+(\.25|\.5|\.50|\.75)?$/

If you want to do it in Coldfusion, the code is:

<cfif FORM.currency*100 MOD 25 NEQ 0>
  Invalid Currency
<cfelse>
  Good Currency
</cfif>

I recommend though that you also do it in javascript like below:

Put this in your header....

<script type="text/javascript">
<!--
  function validate(form){
    if ( (form.currency.value*100)%25 != 0){
      alert('Currency must be 25 cent increments.');
      return false;
    } else {
      return false;
    }
  }
-->
</script>

And do your form something like this :

<form name="yourForm" action="index.cfm" method="post" onSubmit="return validate(this)">
  <input type="text" name="currency">
  <input type="submit">
</form>

Sorry, in the javascript that second "return false;" is supposed to read "return true;"
I forgot to change it back after testing.

New Code:

<script type="text/javascript">
<!--
  function validate(form){
    if ( (form.currency.value*100)%25 != 0){
      alert('Currency must be 25 cent increments.');
      return false;
    } else {
      return true;
    }
  }
-->
</script>

Thanks Jester_48 for the reg ex but is doesnt seem to work, i have tried entering 20.23 for example but doesn't detect this as an invalid number

Any ideas ??

Cheers

JT

Thanks js_vaughen

Done a bit of testing with the MOD validation but the number 1.255 can get past it which has three decimal places

Is there any way to validate that only two decimal places are allowed ??

Cheers

JT

this should work for ya...

<script type="text/javascript">
<!--
  function validate(obj){
    if (!obj.Currency.value.match(/^[\d]+\.(50|5|25|0|00|75)$/)){
      alert('Currency must be 25 cent increments.');
      return false;
    } else {
      return true;
    }
  }
-->
</script>

<form name="test" action="" method="post" onSubmit="return validate(this);">
 <input type="text" name="Currency">
 <input type="submit" name="submit" value="Submit">
</form>

well you could put a maxlength on your <input> field to block that.  And for people who have javascript disabled this new coldfusion like will make sure there are no more than 2 digits.

<cfif currency*100 MOD 25 NEQ 0 OR currency*100 NEQ Int(currency*100)>

ignore my maxlength comment, that doesn't apply :-P
but the tag will work

except change the alert, I just wanted to see what was getting by with alert(curr[1]);

change it to alert('Currency must be 25 cent increments.');

Thanks trailblazzyr55

When you get the time can you have a look at the following question
http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21711268.html

Remember i was trying to work out the UK tax weeks, i have stumbled across a javascript function that does it but i am trying to make sense of it and convert it into a cfscript !! and add into my DateInfo.cfc which you kindly helped me out with !!

jturkington, did my javascript work for you? also have a look at the other post you mentioned...

http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21711268.html

let me know if you need any help =)

regards,
~trail