I agree with mouss, you can create a custom SQL query using the "MYSQL_SELECT_CLAUSE" in authmysqlrc. At least this is the case with PGSQL_SELECT_CLAUSE as I do it myself.
Courier Authlib will use the exact query you provide, so if you don't want double quotes, don't put them in the query! Andy. mouss wrote: > Алексей Инкин 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 > > !DSPAM:37,462b177e89291803020511! > > > ------------------------------------------------------------------------- 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
