Posted by Rik on 01/04/07 18:31

Bill wrote:
> hi Hendri,
>
> 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

I'd say it's this bit:
"... = \'en\'"

Only escape single quotes if they are in a single quoted string.
You'd either use:
"... = 'en'"
Or:
'... = \'en\''

Grtz,
--
Rik Wasmus

[Back to original message]