Posted by peter on 02/05/07 19:27

> If I take the where clause out it works and returns all the records.
> Tried numerious different combinations to try and put the where clause in
> but still returns an error. Works ok using a sql statement in mysql.
> Any other way to count records using where clause.
> Thanks again for you time
> bill

In the code you supplied you have escaped the single quotes in the where
clause. as you have double quotes set around the sql query you do not need
to escape them and is most likely the cause of your problem.

[Back to original message]