Re: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server

• Previous message: Gary Jarrel: "Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• In reply to: Gary Jarrel: "Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• Next in thread: Martin Weber: "Web site link to example and a proposal for a new example link"
• Reply: Martin Weber: "Web site link to example and a proposal for a new example link"
• Reply: Gary Jarrel: "Re: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Just curious, did you use SortOrder.DESCENDING_INSENSITIVE?

mrg

On Fri, Aug 6, 2010 at 12:10 AM, Gary Jarrel <garyjarre..mail.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
>

• Next message: Martin Weber: "Web site link to example and a proposal for a new example link"
• Previous message: Gary Jarrel: "Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• In reply to: Gary Jarrel: "Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• Next in thread: Martin Weber: "Web site link to example and a proposal for a new example link"
• Reply: Martin Weber: "Web site link to example and a proposal for a new example link"
• Reply: Gary Jarrel: "Re: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Aug 06 2010 - 12:36:02 UTC