I think I prefer the javascript approach to reduce traffic and provide immediate validation to the user, although the amount of data sent would be very small.
Here is what I'm thinking; the page where the user enters the data submits to a second page that contains the database connection language and SP commands...
exec my_SP val1, val2, val3, ...
exec my_SP val11, val12, val13, ...
exec my_SP val21, val22, val23, ...
exec my_SP val31, val32, val33, ......
I've never placed the SP syntax in Javascripts before, so can you do something like "if val1 <>'' then exec my_SP val1, val2, val3, ... then go to next SP else endif"
I plan to use validation scripts in the form to require a key value be entered before a user can move to the next row in the form so in the above scenario as soon as a null is encountered in the key value field no further iterations of the SP would be executed.
I hope this is lucid, and I appreciate your help. Any syntax suggestions (Jscript or SQL)are certainly welcome.