|
|
|
|
| Author |
Messages |
|
Bryan Jarvis
Gold Membership
Ventrian Active Member
Posts:35
 |
| 2/25/2007 3:06 PM |
|
I need an SQL query that will give me all the subscribers in a
given State.
For instance, I need to email all our Texas subscribers to ask them for nominations for some of the executive board positions that are up for election in April.
I've browsed through some of the tables in my installation, but I haven't put all the
pieces together yet.
Can anyone help?
Thanks!
Bryan |
|
|
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 2/25/2007 8:17 PM |
|
Is your state stored in the DNN profile tables? These can be difficult to query though.
The subscriber part is simple enough, select from the "receipt" table. I think there are some views on the profile data that should help with state, if you join the two, you should get what you need. |
|
Scott McCulloch
Site Administrator |
|
|
Mariette Knap
Gold Membership
Ventrian Master
Posts:665
|
| 2/25/2007 10:24 PM |
|
| I would like to know it by country and found it very difficult to accomplish. Scott, can you look into this for next release? |
|
Mariëtte Knap
Microsoft MVP |
|
|
Scott McCulloch
Administrators
Ventrian Master
Posts:17204
|
| 2/26/2007 7:03 AM |
|
| Sure no problems, I already have it on my list from before |
|
Scott McCulloch
Site Administrator |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|