Skip to Content.
Sympa Menu

en - [sympa-users] Re: include_sql_query

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Olivier Salaün - CRU <address@concealed>
  • To: Redmond Militante <address@concealed>
  • Cc: address@concealed
  • Subject: [sympa-users] Re: include_sql_query
  • Date: Wed, 17 Jan 2007 09:15:57 +0100

Currently you can only get the user email from include_sql_query. Extending this would require extending the feature, ie adding parameters to tell Sympa which field include email and name.

This is already a requested feature : http://sourcesup.cru.fr/tracker/?group_id=23&atid=170&func=detail&aid=1119

Redmond Militante wrote:
Is it possible to use include_sql_query as a data source - so that 'Name' is
populated for a subscriber as well as 'Email'.

something like

include_sql_query
db_type oracle
host sqlserv.admin.univ-x.fr
user banalise
passwd mysecret
db_name scolarship
sql_query SELECT DISTINCT email, name FROM student
?

I'd like for list owners to be able to see 'Name' for subscribers under
'Manage Subscribers' for lists populated in this manner.




Archive powered by MHonArc 2.6.19+.

Top of Page