cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server
Date Fri, 06 Aug 2010 12:35:06 GMT
Just curious, did you use SortOrder.DESCENDING_INSENSITIVE?

mrg


On Fri, Aug 6, 2010 at 12:10 AM, Gary Jarrel <garyjarrel@gmail.com> wrote:
> Hi All
>
> Using SQL Server I have a table with a DATETIME column. When I run a
> Cayenne Query with an Oder By clause in Descending Mode, the resulting
> SQL looks something like:
>
> SELECT UPPER(t0.date_created)
> FROM product t0
> ORDER BY UPPER(t0.date_created) DESC
>
> In the Modeler these columns show up as TIMESTAMP
>
> Is there a reason a UPPER is being used, it seems like it's trying to
> do a case insensitive ordering on a non character based column.
>
> Thank you
>
> Gary
>

Mime
View raw message