Error with Order by command in ASP environment.

[YL Chai]

Dear Sir,
 
I am using a MySQL 3.23.54-NT with MyODBC 3.51. I am facing the
following problem
 
When I use select command such as 
 
select LvTrans.intLvTranID, trim(LvTrans.varLeaveType),
LvTrans.charHalfDay, LvTrans.charAmPm, LvTrans.dtFromDate,
LvTrans.dtToDate, LvTrans.decTotalLv, LvAppr.charAppApprStat,
LvAppr.charCanApprStat, LvAppr.charConvStat from LeaveTransactionTbl
LvTrans, LeaveApprovalTbl LvAppr where varUserID = 'ylchai' and
LvTrans.intLvTranID = LvAppr.intLvTranID
            
            I have no problem to retrieve from the console as well as
from my ASP program
 
However, when I added in order by command at the back, it is work
perfectly in the console, but when I run it under ASP file, it always
can compare the result. For example, when I print the result (retrieve
from MySQL database) it show "A", but it does not work in case or if
statement (e.g. if MyData("varLeaveType") = "A" then. the above command
work perfectly when the SQL command does not have a order by condition.
 
Please Advice!
 
            
 
Best Regards,
Chai Yoon Leong
[Project Manager]
 
Qinetics Solutions Sdn. Bhd.
Lot 3, Jalan SS13/4,
Subang Jaya Industrial Estate,
47500 Petaling Jaya, Selangor.
 
Tel: +(603) 5636. 4288 (Ext. 7920)
Fax: +(603) 5636. 7320
Web: www.qinetics.net
 
| Proactive | Rational | Interactive | Multidimensional | Agile |
Control |