ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: chufford on January 10, 2007, 09:56:22 am
-
I created a complex custom query in the user selection area.
left join lm_users as B on lm_users.email = B.email and lm_users.uid != B.uid WHERE lm_users.cnf=1 AND (lm_users.list = 4 or lm_users.list = 6 or lm_users.list = 8 or lm_users.list = 9) AND (B.email is NULL or B.list =4 or B.list =6 or B.list =8 or B.list =9) group by lm_users.email
This query selects everyone on list 4,6,8 & 9 who are not on other lists and groups by email to remove duplicates. (The people on the other lists will get a different email but I don't want anyone to get 2 emails). The above query was too long and the end was truncated when I saved it. I notcied that the 'q' field in Table lm_selectd was 'TinyText'. I changed that to 'Text' and the query was stored correctly.
Testing the query in the User Selection worked perfectly. However, when I went to actually send the message, there was a query error. It said that 'email' was an ambiguous field. Line 440 of selfunc.php does a condition between selecting '*' or selecting 'email,id'. In my query, there are duplicate fields so that 'email' is ambiguous. I temporarily changed that line 440 to 'lm_users.email, lm_users.id' and then the whole thing worked.
I am not sure if you want to change this, but I wanted to let you know. Also, the above query might be helpful to others who are trying to accomplish a similar thing. This query may address this post:
http://listmailpro.com/forum/index.php?topic=1440.0
Thanks.
-
Hi Chris,
The line has been changed for the next update and all future updates.
if($rxmode=='send') $selstr = "$utable.email,$utable.id"; else $selstr = '*';
The size of the custom query field will also be updated:
// increase size of field holding 'custom sql' user selection queries
"ALTER TABLE $sedtable CHANGE q q TEXT NOT NULL",
Best