i am trying to connect a jsp page to the postgres db
i have written a html form and i am trying to post the data to the database
i am reciving an error
the jsp page is
the error says
org.apache.jasper.JasperException: javax.servlet.ServletException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "["
Position: 18
ng
thnx in advance
also i am still new so please point out the errors i am making
I agree that it would be better to move this code out of the JSP. As for your error, it looks like you are connecting to the database and getting an error running the insert. There aren't braces around the column names in an insert. You can try running the SQL statement at the postgres command line to make sure it works.