ORDER BY, not ORDERBY :)
I'm supprised you aren't getting an error.
Todd
----- Original Message -----
From: "paul ." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 9:24 AM
Subject: problem with "orderby" in a varchar field
| HI Guys
| Kindly help
| using "orderby" is not working ; when I use to make the sort using a field
which is a varchar??
| my query
| "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDERBY
issues ASC"
| the "issue" is a field which is varchar(100)
| kindly suggest
| -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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists