Problem inserting data into database

[sheetaljagwani]

Enter the name of the new table:

Enter the number of the table:

[harpalshergill]

Hi
Did you find out the solution about how to enter the integer or datetime values from HTML form data???
If yes then please let me know what you did!!!

thanks

[techkar]

Hi

It shows that the variables number and name are undefined,So place the

String name= request.getParameter("table_name");
String number = request.getParameter("table_number");

before

String query = "insert into benthic_query values('"+name+"', '"+number+"')";

Regards,

[harpalshergill]

Any idea about inserting DateTime format from form feils which is a string to an ORALCLE Database??

[jwenting]

You do I hope realise that it's very bad practice to do such things in a JSP?

Send the form submit to a servlet and do it there, then send the result of that operation back to a JSP for display.