This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes PreparedStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement" Watch "PreparedStatement" New topic


Manuel Paco
Ranch Hand

Joined: Sep 23, 2001
Posts: 58
Would you please tell what is wrong with my "String query" ? . DATEVALUE('?') does not seem to work.
DATEVALUE('2001-10-10') is a MS-Access function.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

try losing the single quotes(not necessary with preparedStatements):

it worked for me.

[This message has been edited by Jamie Robertson (edited October 17, 2001).]
Manuel Paco
Ranch Hand

Joined: Sep 23, 2001
Posts: 58
Thanks Jamie.
I agree. Here's the link:
subject: PreparedStatement
Similar Threads
How to read/write Blob images using Hibernate
Problem with preapred Statement
How to display data from database to JSP Page in Struts2
Datasource Connection
howto modify database structure ?