Skip to Content.
Sympa Menu

en - Re: [sympa-users] include_sql_query question

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • 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
>



Archive powered by MHonArc 2.6.19+.

Top of Page