Avijit Kumar

Abhijit,

QuirksMode has got an excellent article describing how to do exactly what you want:
http://www.quirksmode.org/dom/domform.html

Mark 'Tarquin' Wilton-Jones - author of http://www.howtocreate.co.uk/

Is there any particular reason why you keep sending me 5 copies of each
email? Are you having problems with your hotmail account?

> I would like to have a row that is default and it will add another new row 
> when the user clicked on the button 'add'. At the same time, when add new 
> row was clicked, the data previously entered in the 1st row will be first 
> inserted into the database and so on and it is saved in the form itself.

To do this make the 'add' button be a button of type 'submit', and give it
a name and value. You will need to use a server side script to check if
this variable exists (it will only exist if it is the button that they
clicked). If it exists, make the server side script add the information
that it was sent into the database. Then read all of the information out of
the database (this will include rows that were saved earlier), and use
those to write the rows again. Add an extra row on the end also. To help
you do this, make the names of the inputs in the row use the name of an
array. server side languages like PHP allow you to index these
individually:
..row 1...
<input name="code[0]" ... >
..row 2...
<input name="code[1]" ... >
This way, you will be able to identify which is which on the server.

> How can I do that a user double clicks or only a click over a row to select 
> this row?

There are two ways that you can do this:

1. using labels - when clicked, they automatically tick the associated
checkbox
<tr>
<td><input type="checkbox" name="selected0" id="selected0" value="1"></td>
<td><label for="selected0">Something else</label></td>
</tr>
you can then use a server side script to cycle theough all the possible
checkbox names and check if they are ticked

2. using JavaScript - this has accessibility problems
<tr onclick="
this.className=this.className?'':'selected';
document.forms['nameofform'].row0selected.value='1';
"><td><input type="hidden" name="row0selected" value="">

To send data to a database, you must submit your form to a web page that
uses a server side programming language, and you need access to a database.
Server side programming languages include:
PHP, Perl, JSP, ASP, ESP
Databases include:
MySQL, PostgreSQL, Oracle, MSSQL, MS Access
You must use what your host provides.

The most commonly used combination is PHP and MySQL. You will need to look
on those sites for a tutorial, or look on http://www.w3schools.org/
http://www.php.net/manual/en/
http://dev.mysql.com/doc/mysql/en/Tutorial.html

Sorry, I do not know JSP at all. Oracle querying syntax is like MySQL
syntax, but with a few extra features. If you use the MySQL tutorial, it
should help you learn Oracle also.

Maybe you can find something on Google that does what you need:
http://www.google.com/search?q=oracle+jsp+tutorial

<input name="whatever" type="text" size="6" maxlength="5" onblur="
var theNum = parseFloat(this.value);
if( isNaN( theNum ) || theNum < 0 ) {
 this.value = 0;
} else if( theNum > 99.99 ) {
 this.value = 99.99;
} else {
	this.value = theNum;
}
" value="0">

<input name="whatever" type="text" size="6" maxlength="5" onblur="
var theNum = parseFloat(this.value);
if( isNaN( theNum ) || theNum < 0 ) {
 alert('The number you entered was too low');
 this.value = 0;
} else if( theNum > 99.99 ) {
 alert('The number you entered was too high');
 this.value = 99.99;
} else {
	this.value = theNum;
}
" value="0">

If you want to change what it puts in the box when they make a mistake, you
can change the lines that tell it what to change it to. If you want to do
nothing, delete the lines

<input name="whatever" type="text" size="6" maxlength="5" onblur="
var theNum = parseFloat(this.value);
if( isNaN( theNum ) || theNum < 0 ) {
 alert('The number you entered was too low');

/****** I think this is what you want ******/
 this.value = '';


} else if( theNum > 99.99 ) {
 alert('The number you entered was too high');


/****** I think this is what you want ******/
 this.value = '';


} else {
 this.value = theNum;
}
" value="0">

You can put anything you want in there - just write whatever you want in
between the ' quotes.

1)

<input maxlength="9" onblur="
if(!this.value.match(/^BP[\d]{7}$/)) {
 alert('Format not valid');
 this.value = '';
}
">

2)

<input type="text" name="debit" size="12">
<input type="text" name="credit" size="12">
<input type="text" name="Total" size="12" onclick="
var oDebit = parseFloat(this.form.debit.value);
var oCredit = parseFloat(this.form.credit.value);
this.value = oDebit + oCredit;
" disabled>

replace 'disabled'  with 'readonly'

You have used the maxlength attribute, but you have said numbers that use
more than 10 characters. I will assume that you did not mean to put the
attribute in the tag

<input type="text" name="chqdate" size="10" onblur="
var x = parseFloat(this.value);
if(!this.value.match(/[\d]+\.?[\d+]/)) {
 alert('format not valid');
 this.value = '';
} else if( !(x%1) ) {
 this.value = x + '.00';
}
">

abhijit,

Instead of asking me to write all these trivial scripts for you, why don't
you learn how scripting within forms works. I have already documented a
great deal of scripting like this. Try using my tutorial to teach yourself
JavaScript.
http://www.howtocreate.co.uk/tutorials/javascript/important

AAAAARRRGH!

Enough! Enough already!

Look, I don't mind helping, but I object to being exploited. I take my time to help you, but you cannot even be bothered to try to work out how to do any of this yourself. I am not a slave. I try to help you learn. I do not want to do your job. If you can't even do these basic things, and you are not even trying to learn, you shouldn't be doing this at all. You certainly should not be getting paid for it, because you are not doing anything yourself. You are exploiting other people. Oh, and saying 'Sir' (Note; I have a real name. It is Mark. I also have a nickname. It is Tarquin.) and 'plz' (Note; please is spelt 'please' not 'plz'. This is not AOL chat, and I am not 12.) repeatedly does not stop it being exploitation.

And most importantly, you definitely should not be writing pages that deal with peoples' sensitive information when you clearly lack even the most basic validation knowledge. This is serious. Incompetance is a serious problem when you are dealing with other people's information. This is how you get security problems, where you accidentally give away sensitive information to the wrong people. Learn how to do this properly before you do it. Try using a few tutorials, and learn to do it properly. Learn to do it for youself.