Hi, Interesting.
> Thanks for all those who helped me with this a few days ago (I've only now > had the chance to get back to programming). > > As someone correctly surmised, I am using Delphi and connecting to mySQL via > a TQuery (actually a TZQuery, via Zeos components). What I have discovered > is that > 1. mySQL doesn't like queries with date parameters (one must pass the date > as a literal) Hmmm... I do make use of parameters, but I noticed MySQL doesn't provide me with the right datatype (like Firebird or InterBase do). So I'm passing everything as a string to the parameter. :-/ > 2. the date format has to be changed to that of mySQL. Well, that makes sense of course :-) > 3. if one uses a table alias ("p" in my case), one is not allowed to use the > full table name - "projects.closeddate" causes an error, but p.closeddate is > ok. That's according to the SQL standard: if you use an alias, address the table by it's alias only. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]