Hi Jakob,
Thanks for your prompt reply.
I was not able to get the p6spy work with websphere . Can you suggest any
other way to see if the between is actually working.
thanks,
Krupa
Jakob Braeuchi <[EMAIL PROTECTED]> wrote: hi krupa,
what you see isan output of the query not the executed.
please use p6spy to monitor the sql statement including all parameters.
hth
jakob
k jee schrieb:
> When I am trying to use
> criteria.addBetween(datefieldname,SQLdate1,SQLDate2) OJB is not creating the
> SQL with 2 values for between. here is what I see. Can some one please let
> me know what is wrong here.
>
>
> SystemOut O [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:
> executeQuery : Query from class xx.yyy where [crit1 = 100, crit2 = 29867,
> [crit3 = K, [crit3 = E, [crit3 = D], [crit3 = S], [date1 BETWEEN 2005-11-18,
> time BETWEEN 14:00:00]]]]
>
>
> Thanks,
> Krupa
>
>
> ---------------------------------
> Yahoo! FareChase - Search multiple travel sites in one click.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
