HELP! I'm getting the following error:
-------------- Error (SQL): SELECT date, subject, location, private, id, duration, dategroup_id, COUNT(DISTINCT subject) AS appointment_count, inituserid FROM mgw_calendar WHERE userid=1 AND SUBSTRING(date,1,8) = '20030312' GROUP BY date, subject, location, private, id, duration, dategroup_id, inituserid ORDER BY date
Error (MSG): You have an error in your SQL syntax near 'DISTINCT subject) AS appointment_count, inituserid FROM mgw_calendar WHERE useri' at line 1 ---------------
I'm using MySQL 3.22.32 .... does COUNT(DISTINCT ...) not work with this version?
No, not until 3.23.2.
Thanks,
Bob Sawyer ----------- Pixellated! Design:Develop:Deliver www.pixellated.org
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php