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
RE: problem with orderby in a varchar field
try ORDER BY, you dont have the space! -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 8:25 AM To: CF-Talk 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
Re: problem with orderby in a varchar field
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