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: 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




Archive powered by MHonArc 2.6.19+.

Top of Page