Subject: The mailing list for listmasters using Sympa
List archive
Re: [sympa-users] Include user's name in SQL query inclusion?
- From: David Verdin <address@concealed>
- To: Omen Wild <address@concealed>
- Cc: Malcolm Waltz <address@concealed>, address@concealed
- Subject: Re: [sympa-users] Include user's name in SQL query inclusion?
- Date: Fri, 24 Sep 2010 12:10:54 +0200
Your queries are right, but the problem is that the data_source system
only gathers email addresses. We don't add the gecos. this is partly
due to the fact that the gecos was rarely used when the inclusion
system was first implemented, and partly because the gecos is defined
at the user level (ie in the user table) and not at the subscription
level. Only for owners can you set a different gecos for each list (and it is sotred in the database under the field "comment": it is only used for display in the web interface). Regards, David Le 24/09/2010 05:08, Omen Wild a écrit : Quoting Malcolm Waltz <address@concealed> on Thu, Sep 23 14:57: Something like: SELECT user_admin,comment_admin,list_admin,date_admin FROM admin_table My third example was pretty close to that, but to be extra sure I tried it exactly as you listed it, but I got the same results. The Email column gets filled, but the Name column does not. We use MySQL but I wouldn't expect this to make a difference. --
David Verdin Comité réseau des universités Due to the limitations of human brain, I fail to remember all the mails. So if you want your bug reports or feature requests for Sympa to be processed, please post them to the Sympa tracker |
-
[sympa-users] Include user's name in SQL query inclusion?,
Omen Wild, 09/23/2010
-
RE: [sympa-users] Include user's name in SQL query inclusion?,
Malcolm Waltz, 09/23/2010
- RE: [sympa-users] Include user's name in SQL query inclusion?, Malcolm Waltz, 09/23/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
Omen Wild, 09/24/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
David Verdin, 09/24/2010
- Re: [sympa-users] Include user's name in SQL query inclusion?, Omen Wild, 09/24/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
David Verdin, 09/24/2010
-
RE: [sympa-users] Include user's name in SQL query inclusion?,
Malcolm Waltz, 09/23/2010
Archive powered by MHonArc 2.6.19+.