• Post Reply Bookmark Topic Watch Topic
  • New Topic

Passing a date  RSS feed

 
Bob Kimmel
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying to pass a date from a jsp (using a HTML form) to a Oracle 9i DB (I'm using Tomcat also). I gotten some advice from my peers but I'm getting "ORA-00936: missing expression" Can anyone help to figure out how to do this properly or a example.
Thank,
Bob

 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bob,
Remove the newline characters ("\n") from your SQL strings. Try this instead:

But I recommend using a "java.sql.PreparedStatement" instead.
And instead of your (SQL) query, try this:

Good Luck,
Avi.
[ November 21, 2003: Message edited by: Avi Abrami ]
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66307
152
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not really anything to do with JSP, so I'm moving this along to Java in General (Intermediate).
bear
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!