Dean, Please take my money

[chris6]

Hi Dean,

We're continuing to have great success with Listmailpro, and as you know, have recommended it to many customers.

However, we have a major problem.

I have calculated that the inability to mail people on one list, while excluding those on another (which is something that many on this forum seem to need) is costing us somewhere between $100,000 and $200,000 per year.

So how much would you like us to pay you to do this for us now?

Our would you like to just go ahead and do it because your customers are crying out for it.....

Either is fine but please could you make it a matter of urgency.

Many thanks

Chris

[DW]

Chris,

You should indeed be able to do this, albeit a bit complicated....  Have you been following the post below?  It contains exact instructions.

http://listmailpro.com/forum/index.php?topic=1195.0

Regards

[chris6]

Hi Dean
Just so I'm totally sure. Which series MySQL is the querie able to run on.
and once again could we give you MONEY to write us somthing to resovle this now.


Quote:
MySQL Error: You have an error in your SQL syntax near 'SELECT * FROM lm_users a WHERE (a.list = '1' AND cnf = '1') OR (b.li' at line 1
this is all i every get using your code  

I believe your server must be running MySQL 4+ for these queries un order to use the NOT EXISTS function and "FROM lm_users a" syntax. This is one of the reasons the feature is not yet built right into the program.  
Quote:
in the code is the number of the lists the user query name you create as a search term or is the current list name that I use for all the lists of email users that are stored in my listmail pro database.

The list number is just that, the List Ref # from the List Settings page, also seen under Current List. To search a field for a certain value will require an addition to the statement. Unfortunately, I'm not an expert on these complex queries yet, but I might be able to come up with something if you want to do this (search a user field AND limit by list).
Quote:
Am I to assume that first of all you have to creat the Search Query prior to then creating the custom query?

if so can you pleae rewrite the above code for me if the first query is called 2-End and the list I want to check against that they are not on is called VIP.

Currently a search query is not part of the the code provided and you cannot use standard selection rules alongside a custom query.

Regards

[DW]

Just so I'm totally sure. Which series MySQL is the querie able to run on.

MySQL 4+

and once again could we give you MONEY to write us somthing to resolve this now.

Are you on a dedicated server or a shared host?  On a shared host your host will have to upgrade MySQL and there is nothing I can do.

Regards