At 09:11 AM 23/10/01, you wrote:
>ya, I know the Escape sequence...but it doesn't work in case of
>Ms-Access....gives error..
>"Malformed GUID. in query expression '(datefield = {d 'yyyy-mm-dd'})'. Works
>with SQL Server.
>
>So, what to do in that case ??
>
>Moreover, as Dmitri suggested...using "TO_DATE" function...which doesn't
>work in Ms-Access/SQL Server Query... is it a function of Java ?? If, then
>of which class ?
We're using PreparedStatementS, coupled with setDate() to set the date. The
database driver takes care of the casting/processing automagically. (Tested
with SQLServer, not access.)
Jim
--
* Jim Cheesman *
Trabajo:
[EMAIL PROTECTED] - (34)(91) 724 9200 x 2360
I disagree
with unanimity.
