AW: [tpop3d-discuss]MySQL and dots before the @ sign

[TPOP3@Globalplanets.net]

----- Original Message ----- 
Von: tpop3d-discuss-admin@lists.beasts.org
[mailto:tpop3d-discuss-admin@lists.beasts.org] Im Auftrag von David Mitchell
Gesendet: Dienstag, 27. Juli 2004 02:20
An: tpop3d-discuss@lists.beasts.org
Betreff: Re: [tpop3d-discuss]MySQL and dots before the @ sign


------------------------snip*----------------------------------------


Looks OK, but what do you have set for the auth-mysql-pass-query option in
the conf file? Your problem may be quoting in the SELECT statement - MySQL
will interpret WHERE local_part=b.t and WHERE local_part="b.t" differently.
I use single quotes in mine (WHERE USERNAME='$(user)') but I think double
quotes are interpreted the same way by MySQL.

Cheers,
Dave

------------------------*snap*----------------------------------------------

I use the default settings. Auth-mysql-pass-query option isn't set.
To what could it be set?

select * from popbox where( mbox_name='$user');


Cheers, 
Robert