Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [klatilf] validating range for numeric field

Quote Reply
Re: [klatilf] validating range for numeric field In reply to
Quick & Dirty Solutions:


1. Dbman solution in default.cfg use [0-24] as valid_expr:
Code:
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
HOURS => [8, 'alpha', 0, 3, 0, '', '[0-24]'],
Userid => [9, 'alpha', -2, 15, 0, '', '']
);


2. JavaScript Solution in html.pl:
Code:
<SCRIPT LANGUAGE="JavaScript">
function checkHours() {
if (form.HOURS.value > 24) {alert('Enter a Valid Hour')}
}
</SCRIPT>


<INPUT TYPE="text" NAME="HOURS" VALUE="$rec{'HOURS'}" SIZE="02" MAXLENGTH="02" onChange="checkHours();">


3. HTML Solution in html.pl:
Code:
<SELECT NAME="HOURS">
<OPTION VALUE="01">01</OPTION>
...options 2-23 go here...
<OPTION VALUE="24">24</OPTION>
</SELECT>
Subject Author Views Date
Thread validating range for numeric field klatilf 2841 Dec 26, 2003, 12:29 PM
Post Re: [klatilf] validating range for numeric field
Watts 2710 Dec 30, 2003, 1:25 PM