Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Thanks Joakim and to all who have helped me on this topic; all is working properly under 4.0.16. Elton On Dec 1, 2003, at 6:48 PM, Joakim Ryden wrote: On 12/1/03 4:42 PM Elton wrote: Joakim, The "mysql-standard-4.0.16.dmg" installer release notes says, "Beginning with MySQL 4.0.11, you can ins

Re: datetime ORDER BY is erred

2003-12-01 Thread Joakim Ryden
On 12/1/03 4:42 PM Elton wrote: Joakim, The "mysql-standard-4.0.16.dmg" installer release notes says, "Beginning with MySQL 4.0.11, you can install MySQL on Mac OS X 10.2 ("Jaguar") using a Mac OS X `PKG' binary package instead of the binary tarball distribution. Please note that older versions

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Joakim, The "mysql-standard-4.0.16.dmg" installer release notes says, "Beginning with MySQL 4.0.11, you can install MySQL on Mac OS X 10.2 ("Jaguar") using a Mac OS X `PKG' binary package instead of the binary tarball distribution. Please note that older versions of Mac OS X (for example, 10.1.x)

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
That's strange. To test my "datetime ORDER BY is erred", as mentioned, I only ran the installer for the "mysql-standard-4.0.16.dmg"; installing it on my OSX_10.3.1 cpu, that had no prior installation -- and its working. The install notes for "mysql-standard-4.0.

Re: datetime ORDER BY is erred

2003-12-01 Thread Joakim Ryden
On 12/1/03 3:50 PM Elton wrote: If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Both. The tar file is a tar archive and the pkg file is a Mac OS X pacjage. :) --Jo -- MySQL General Mailing Lis

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Elton On Dec 1, 2003, at 5:37 PM, Elton wrote: I downloaded a the 4.0.16 from mysql.com (a .dmg file), ran the installer on my local 10.3.1 cpu

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
I downloaded a the 4.0.16 from mysql.com (a .dmg file), ran the installer on my local 10.3.1 cpu (not the server) -- did not want to mess-up my server. However, I did not compile anything, just ran the install.pkg. Will installer work as a upgrade to my Panther_server's 4.0.14? By the way, I

Re: datetime ORDER BY is erred

2003-12-01 Thread Chris Waskowich
On Dec 01, 2003, at 14:35, Elton wrote: So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MySQL and am using what was pre-installed with Apple's Panther_server -- have never installed it myself. Elton, I've had some weird issues with the d

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MySQL and am using what was pre-installed with Apple's Panther_server -- have never installed it myself. Elton On Dec 1, 2003, at 1:18 PM, Victoria Reznichenko wrote: Elton <[EMAIL PROTECT

Re: datetime ORDER BY is erred

2003-12-01 Thread Victoria Reznichenko
Elton <[EMAIL PROTECTED]> wrote: > > Oops, my pasted graphic did not pass; here is what I get: > > mysql> select date_close,aircraft,route from Avail_Legs Order By > date_close; > +-+--+---+ > | date_close | aircraft | route | > +-

RE: datetime ORDER BY is erred in panther_server

2003-12-01 Thread Daevid Vincent
I'm sure this won't matter, but did you try putting a "order by date_close DESC" or "ASC"? Daevid Vincent http://daevid.com > -Original Message- > From: Elton [mailto:[EMAIL PROTECTED] > Sent: Monday, December 01, 2003 9:04 AM > To: [EMAIL P

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Oops, my pasted graphic did not pass; here is what I get: mysql> select date_close,aircraft,route from Avail_Legs Order By date_close; +-+--+---+ | date_close | aircraft | route | +-+--+---+ | 2003-11-01 14:00:00

datetime ORDER BY is erred

2003-12-01 Thread Elton
I'm using MySQL v4.0.14 that ships with Panther_Server. I have been trying to get it to sort datetime fields properly without success; this is what I get: Is this a known bug? Is there a workaround? Any help would be appreciated. Elton -- MySQL General Mailing List For list archives: http