Hi all,
I am having some problems running a very simple SQL statement - SELECT * FROM TABLE_1
WHERE TABLE_1.DATEFIELD = '07/01/1998'. This SQL statement returns an
java.sql.SQLException
(String to Date conversion error) when run under ND5. Using the DATE
qualifier in
the SQL statement like (WHERE TABLE_1.DATEFIELD = DATE('07/01/1998')) also
failed
to execute. PLEASE NOTE: the same SQL statement works using SQL Editor AND
works
using vanilla JDBC API through a servlet. Has anyone encounter this
problem/bug?
before???
Any hints will be greatly appreciated.
Paul
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
