Skip to Content.
Sympa Menu

en - [sympa-users] Re: Re: include_sql_query

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Redmond Militante <address@concealed>
  • To: Olivier Sala�n - CRU <address@concealed>
  • Cc: Redmond Militante <address@concealed>, address@concealed
  • Subject: [sympa-users] Re: Re: include_sql_query
  • Date: Wed, 17 Jan 2007 13:02:59 -0600


Would it be possible to populate 'Name' for subscribers using an LDAP query
as a data source?

+++ Olivier Sala�n - CRU <address@concealed> [07/01/17 10:21]:
> 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.
> >

--
Redmond Militante / NSIT / The University of Chicago
PGP Public Key: <http://home.uchicago.edu/~rjm/pubkey.asc>



Archive powered by MHonArc 2.6.19+.

Top of Page