This is strange, in the test project dates are read and written and it
works allright for mysql.

If you want to change Torque's handling of dates, look at the mysql adapter
class, DBMM, from the runtime. There, a method getDateString() is called to
get a String out of a Date.

         Thomas

"Steve Vanspall" <[EMAIL PROTECTED]> schrieb am 29.05.2006 04:55:16:

> HI I have this odd problem where Torque attempts to create SQL with just
> a raw toString() value of a date object.
>
>
>
> This doesn't return any results in MySQL, oddly it doesn't throw an
> error either.
>
>
>
> If I put the same dates into my SQL statement, as a properly formatted
> string i.e. 'YYYY-MM-DD HH:MM:SS' (rather than YYYYMMDDHHMMSS, which is
> what Torque is doing) the correct results are returned.
>
>
>
> Is there a way to override how torque formats dates when creating SQL
> query strings?
>
>
>
> I am trying to avoid having to go through and find all the points where
> dates are set in my application.
>
>
>
> Any help would be great
>
>
>
> Regards
>
>
>
> Steve
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to