AJAX

decimal (10,2) limit

Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 13

Reputation: trient is an unknown quantity at this point

Solved Threads: 0

trient

Offline

Newbie Poster

decimal (10,2) limit

Apr 25th, 2008

How to limit the user to decimal (10,2) when he enters number in the textfield?

Can anyone show how to do it in javascript?

•

Join Date: Mar 2008

Posts: 24

Reputation: HenryGR is an unknown quantity at this point

Solved Threads: 4

HenryGR

Offline

Newbie Poster

Re: decimal (10,2) limit

Apr 26th, 2008

Please specify a bit more.
Do you already have a sort of validation function?

You keep going, have a Nice day!
Henry.

Before printing this message, make sure is necessary.

•

Join Date: Apr 2008

Posts: 13

Reputation: trient is an unknown quantity at this point

Solved Threads: 0

trient

Offline

Newbie Poster

Re: decimal (10,2) limit

May 1st, 2008

no i dont have validation function
how to restrict so that the currency can be limit to (10,2) decimal

•

Join Date: Mar 2008

Posts: 24

Reputation: HenryGR is an unknown quantity at this point

Solved Threads: 4

HenryGR

Offline

Newbie Poster

Re: decimal (10,2) limit

May 1st, 2008

From your message, I conclude that your problem is that Javascript does not understand that for you, "10,2" equals "10.2".
Here I wrote a sample html, but the important part is the javascript function that checks the value.

 Help with Code Tags 
 JavaScript / DHTML / AJAX Syntax (Toggle Plain Text) 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>No title</title>
<script type="text/javascript" language="javascript">
	function curcheck(curf,maxval) {
 
		textcur = curf.value.toString();
 
		textcur += '';
		x = textcur.split(',');
		textcur = x[0]+'.'+x[1];
		if(Number(textcur) > maxval) {
			say('result',false); 
			return 
		}
		say('result',true);
	}
 
function say(were,val) {
 
	text = ( val ) ? "Valid value entered" : "Invalid value entered" ;
	eval("document.getElementById('"+were+"').innerHTML = text");
 
}
</script>
</head>
 
<body>
<form id="myform" action="" >
	<input type="text" size="4" id="currency" onchange="curcheck(this,10.2);" />
	<p id="result">&nbsp;</p>
</form>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>No title</title>
<script type="text/javascript" language="javascript">
	function curcheck(curf,maxval) {
		
		textcur = curf.value.toString();
		
		textcur += '';
		x = textcur.split(',');
		textcur = x[0]+'.'+x[1];
		if(Number(textcur) > maxval) {
			say('result',false); 
			return 
		}
		say('result',true);
	}

function say(were,val) {

	text = ( val ) ? "Valid value entered" : "Invalid value entered" ;
	eval("document.getElementById('"+were+"').innerHTML = text");
	
}
</script>
</head>

<body>
<form id="myform" action="" >
	<input type="text" size="4" id="currency" onchange="curcheck(this,10.2);" />
	<p id="result">&nbsp;</p>
</form>
</body>
</html>

Hope this is what you need.

You keep going, have a Nice day!
Henry.

Before printing this message, make sure is necessary.

•

Join Date: Apr 2005

Posts: 1,426

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 230

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Re: decimal (10,2) limit

May 1st, 2008

You would test the form field with a regex like this.
(10, 2) in database means 10 numbers, 2 decimal places. so 12345678.90 is valid.

 Help with Code Tags 
 javascript Syntax (Toggle Plain Text) 
var testRegEx = /[0-9]{1,8}\.?[0-9]{0,2}/
var isValidNumber = form.formField.value.match(testRegEx);
var testRegEx = /[0-9]{1,8}\.?[0-9]{0,2}/
var isValidNumber = form.formField.value.match(testRegEx);

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.