Subject: The mailing list for listmasters using Sympa
List archive
- From: Dick Visser <address@concealed>
- To: Steve Shipway <address@concealed>
- Cc: "address@concealed" <address@concealed>
- Subject: Re: [sympa-users] include_sql_query question
- Date: Mon, 28 Dec 2015 23:19:59 +0100
Great, this is very helpful :-)
Thanks!
On 9 December 2015 at 21:59, Steve Shipway <address@concealed> wrote:
>> 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
>
-
[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+.