Database

View All Threads FirstPrev Next

Re: SQL query Date Sort Problem Michael Potter4-Dec-12 8:11 Michael Potter 4-Dec-12 8:11  I would think the error is happening after the query is returned. Test the query in SQL alone and see if you get the error you describe. Re: SQL query Date Sort Problem jschell4-Dec-12 8:23 jschell 4-Dec-12 8:23  AnirbanM 2 wrote: Please suggest where is the problem, thanks to all in advance. Some posssible reasons. - The problem originates from some other place in the code. So nothing to do with the code that you posted. And one very obvious possibility is that there is code somewhere that is sorting based on alphabetic ("10", "11" versus "1", "2) instead of using the sort that you gave. - You are not looking at the actual data. - You are not running the code that you think you are.

Last Visit: 31-Dec-99 18:00     Last Update: 23-Apr-24 2:01 Refresh ᐊ Prev12

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.