Subject: The mailing list for listmasters using Sympa
List archive
[sympa-users] Include user's name in SQL query inclusion?
- From: Omen Wild <address@concealed>
- To: address@concealed
- Subject: [sympa-users] Include user's name in SQL query inclusion?
- Date: Thu, 23 Sep 2010 11:59:05 -0700
I am looking for a way to include the user's name in a remote SQL
query. To test I've been trying to pull data from the admin_table.
I tried the following combinations in SQL query:
SELECT CONCAT(user_admin, ' ', list_admin, ' ', date_admin) FROM admin_table
GROUP BY user_admin
SELECT CONCAT('"', user_admin, ' ', list_admin, ' ', date_admin, '"') FROM
admin_table GROUP BY user_admin
SELECT user_admin, list_admin, date_admin FROM admin_table GROUP BY user_admin
With the first two the entire result get stuffed into the Email
column, so obviously incorrect.
With the last only the first column gets used, the Name column stays
empty.
Am I missing something simple?
Thanks,
Omen
--
Omen Wild
Security Administrator
(530) 752-1700
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
-
[sympa-users] Include user's name in SQL query inclusion?,
Omen Wild, 09/23/2010
-
RE: [sympa-users] Include user's name in SQL query inclusion?,
Malcolm Waltz, 09/23/2010
- RE: [sympa-users] Include user's name in SQL query inclusion?, Malcolm Waltz, 09/23/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
Omen Wild, 09/24/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
David Verdin, 09/24/2010
- Re: [sympa-users] Include user's name in SQL query inclusion?, Omen Wild, 09/24/2010
-
Re: [sympa-users] Include user's name in SQL query inclusion?,
David Verdin, 09/24/2010
-
RE: [sympa-users] Include user's name in SQL query inclusion?,
Malcolm Waltz, 09/23/2010
Archive powered by MHonArc 2.6.19+.