Subject: The mailing list for listmasters using Sympa
List archive
- From: Steve Shipway <address@concealed>
- To: Dick Visser <address@concealed>
- Cc: "address@concealed" <address@concealed>
- Subject: RE: [sympa-users] include_sql_query question
- Date: Wed, 9 Dec 2015 20:59:35 +0000
> I've succesfully set-up include_sql_query for one of my lists.
> The SQL query returns a bunch of e-mail addresses, and this is nicely
> updating the subscribers table in Sympa.
>
> Is there a way to also populate the "Name" in the subscriber table?
We patched our 6.1.23 so that the second returned column from the query
populates the Name.
The new 6.2.x has this feature built in, though the documentation does not
mention it.
EG:
sql_query select email, fullname from userstable where foo='bar'
Steve
Steve Shipway
T: +64 9 3737 599 ext 86487
E: address@concealed
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
-
[sympa-users] include_sql_query question,
Dick Visser, 12/09/2015
-
RE: [sympa-users] include_sql_query question,
Steve Shipway, 12/09/2015
-
Re: [sympa-users] include_sql_query question,
Dick Visser, 12/28/2015
- [sympa-users] db_list_cache and lists by topics, Urmas Buhvestov, 12/28/2015
-
Re: [sympa-users] include_sql_query question,
Dick Visser, 12/28/2015
-
RE: [sympa-users] include_sql_query question,
Steve Shipway, 12/09/2015
Archive powered by MHonArc 2.6.19+.