|
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
Navigation:
[Reply to this message]
|