Using timestamp a it Prepared statement.
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   John_Mirick
Posted On:   Tuesday, June 4, 2002 12:56 PM

I have a PreparedStatement that is returning me NO results.

If I execute the sql (and manually substitute
to_date('12/12/2000', 'MM/DD/YYYY') for the '?') it works

The only thing I can think of is that the ? in my preparedStatement isnt being turned into the correct sql.

Im using the setTimestamp method on the PreparedStatement.

No exception are occuring... just no results.

Is this a known problem? or a common goof up?
Any ideas on what to do or where to look would be helpful.

Thanks

Re: Using timestamp a it Prepared statement.

Posted By:   Steve_Long  
Posted On:   Tuesday, June 4, 2002 04:07 PM

i have found the ? parameter to be unreliable.
About | Sitemap | Contact