remove the quotes around key_issues like:
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
key_issues DESC
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
----- Original Message -----
From: "paul ." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 10:34 AM
Subject: check this please
> Hi Guys !
> this is the SQl
> ----------------
> select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC
>
> ----------
> "key_issues" field has characters and i want the table to be sorted by
the key_issues alpahebeticaly .
> kindly sugest
> -paul
>
> --
>
> On Tue, 17 Apr 2001 09:16:27
> Hayes, David wrote:
> >If you're trying to sort by the 4th item in the columns list, omit the
> >single quotes around 4.
> >
> >Given that you are using the * to select all the columns, I suggest
> >specifying the column name in your order by clause. The next programmer
> >(maybe you) who looks at the code will be glad you did; also, if the
column
> >order in the table is changed, you'll get unexpected results.
> >
> >-----Original Message-----
> >From: paul . [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, April 17, 2001 8:53 AM
> >To: CF-Talk
> >Subject: order by not working
> >
> >
> >Hi guys am using orderby to sort the fields to get the sort order
> >alphabetically am finding taht is not working please suggest
> >-----------------------
> >select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
> >'4' ASC
> >----------------
> >the above is the SQL whats wrong>>
> >-paul
> >
> >
> >Get 250 color business cards for FREE!
> >http://businesscards.lycos.com/vp/fastpath/
>
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
