Hello all. I can't figure out what is goin wrong with an INSERT SQL query I am using in a JSP page. Here is the code -
But when I attempt to execute this query, I get an SQLException error saying : Syntax error in INSERT INTO statement. I have also tried using a prepared statement but I get the same error. Can anyone help? Thanks!
Are there other inserts working for this table? possible that the table name itself is causing the problem, since ORDER is [part of] an ANSI SQL keyword (ORDER BY)? I remember one time I was working with a field which held a description, and we were getting errors until we renamed it to "descr" instead of "desc" :roll: Hope this is the problem, because it seems like it would be simple to fix... -- Jon