RE: FN-FORUM: SQL / programming Q

date posted 3rd October 2006 20:37

Paul Cooper wrote:
> Thanks Dai. I'm getting this error:
>
> ----------------8
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [MySQL][ODBC
> 3.51 Driver][mysqld-5.0.24a-community-nt]You have an error in your
> SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near 'count(r.ClientID) AS
> NumTotal,count(r.SubmittedDate) AS NumComplete FROM tblGrou' at line
> 1 /members/surveys/notifyclients.asp, line 213

Paul,

You could try COUNT instead of count, it has never mattered in cases I have
tried but the mysql documentation does show functions capitalised so it may
be that your platform requires that? Did you try running the same query
directly on the database (e.g. using mysql client or phpmyadmin)? I always
find it pays to distinguish early between genuine SQL errors and code/driver
issues.

HTH,

Dai