Алексей Инкин wrote:
> This is not the point. The field names are OK, and everything worked fine 
> once 
> I disabled strict ANSI SQL mode for my MySQL server. The point is that the 
> queries generated by the authentication module use double quotes to enclose 
> strings like:
>
> WHERE id = "[EMAIL PROTECTED]"
>
> Which is not complied to SQL standard and does not work for MySQL 
> configurations that respect the standard. Everything should be rewritten with 
> single quotes like:
>
> WHERE id = '[EMAIL PROTECTED]'
>
> P.S. I use Courier 4.1.1 that comes with Debian Etch.
>
>   

sorry, I was thinking the problem was caused by empty fields.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Courier-imap mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap

Reply via email to