[sqlite] ORDER BY not providing the expected result

[jose isaias cabrera]

Greetings!
I have this schema,

CREATE TABLE LSOpenJobs
       (
        id integer primary key, ProjID, parent, children, login, cust, 
proj, PClass, PSubClass, bdate, ddate, edate, pm, pmuk, lang, vendor, 
vEmail, invoice, ProjFund, A_No, wDir, notes, status
       );

When I do a,

SELECT * FROM LSOpenJobs WHERE status='o' ORDER BY ProjID, PSubClass, 
parent, bdate, ddate, edate;

the ORDERing, or sorting, is done alphabetically and not numerically.  Is 
there a possibility to get this ORDER BY done numberically?  ProjID is an 
integer, and so I end up with this,

ProjID, cust, proj,..., status
100, ...
100, ...
100, ...
114, ...
114, ...
114, ...
114, ...
114, ...
116, ...
116, ...
98, ...
98, ...
98, ...
63, ...
63, ...
63, ...

etc.  What I would like is to have

63
63
98
98
100
100
114
114
116
116

Is this possible without me having to sort it out?  I know I could probably 
add 0's to the entry, and so 00063... 00116, but I want sqlite to provide 
this to me. :-)

thanks,

josé


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------