Not exactly sure what you're trying to do but you're telling the SQL Server
to sort by the character '4'. You should specify a field name there without
the quotes.
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 9:52 AM
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
