[no subject]

[Heather Missel <hmissel@ROCHESTER.RR.COM>]

Thanks for the input, but this is in a View that is used as a prompt table.
The View (as far as I can tell) does not support the order by clause.


----- Original Message -----
From: Ted Houghton <THoughto@UNITEDROAD.COM>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, May 31, 2000 4:55 AM


> Heather,
> Have you tried adding an
> order by b.end_dt
> line?
>
>
> -----Original Message-----
> From: Heather Missel [mailto:hmissel@ROCHESTER.RR.COM]
> Sent: Tuesday, May 30, 2000 9:28 PM
> To: SQR-USERS@list.iex.net
> Subject:
>
>
> I am having a problem building a list box that contains calendar end dates
> in the correct order.
>
> I build the SQL view as:
>
> Select to_char(b.end_dt, 'MM/DD/YYYY')      !Need this format
> from ps_deptid_tbl
>
> The returned values are in alpha order, and I need them in date order.
>
> I have also tried to_date(to_char(b.end_dt, 'MM/DD/YYYY))
> from ps_deptid_tbl
>
> This returns a SQL error "not a valid month"
>
> Any help would be greatly appreciated
>
> Dennis
>
>
>
>
>
>
> *************************** N O T I C E
**************************************
>
> This message and any attachments is intended only for the individual or
company to which it is addressed and may contain information which is
privileged, confidential or prohibited from disclosure or unauthorized use.
If the recipient of this transmission is not the intended recipient, or the
employee or agent responsible for delivering such materials to the intended
recipient, you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by it's
intended recipient is strictly prohibited by the sender. If you have
received it in error, please notify us immediately and destroy the message
and all copies in your possession.
>
> This message has been scanned for viruses by Norton Antivirus.
>