Marcio Merlone writes:

Sam Varshavchik wrote:
Marcio Merlone writes:
My question is if there is a way to make users login using either their id (xpto123) OR address ([EMAIL PROTECTED]). I notice that the mysql query sent by courier is something like this:
SELECT id, crypt, "", uid, gid, home, maildir, quota, name FROM users WHERE id = "xpto123"
It should be something like this:
SELECT id, crypt, "", uid, gid, home, maildir, quota, name FROM users WHERE id = "xpto123" OR address='xpto123'
Insert two records into users, identical in all ways except the id field.
This is an option but excuse me, looks ugly and one more administrative nigthmare. But is still an idea.
Don't know enough about MySQL to be sure, but could you do something like this with a database view or query? Convert a single record in the underlying table into two rows in the returned results, one with the id and the other with the address? Of course, this might be a little inefficient...
--
Bill Michell
[EMAIL PROTECTED] (home)

-------------------------------------------------------
This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ad.doubleclick.net/clk;4729346;7592162;s?http://www.sun.com/javavote
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users


Reply via email to