ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: kyle on October 19, 2007, 05:19:15 pm

Title: User Selection Custom Query Limitations?
Post by: kyle on October 19, 2007, 05:19:15 pm

Hi Dean / All,
I just upgraded to 1.87d from 1.85 hoping it would fix this issue.  Apparently the custom query has a length limitation?  For example, when I enter the following query and test it works just fine:

WHERE (list = '1' and cnf = '1' AND user7 != 'Virginia') AND (list = '1' and cnf = '1' AND user7 != 'Missouri') AND (list = '1' and cnf = '1' AND user7 != 'Kansas') AND (list = '1' and cnf = '1' AND user7 != 'Vermont') AND (list = '1' and cnf = '1' AND user7 != 'Maryland') AND (list = '1' and cnf = '1' AND user7 != 'Wisconsin') AND (list = '1' and cnf = '1' AND user7 != 'Idaho') AND (list = '1' and cnf = '1' AND user7 != 'Montana') AND (list = '1' and cnf = '1' AND user7 != 'California')

But then when I click Save / Add, it loses part of the custom query (apparently a length limitation of 256 characters):
WHERE (list = '1' and cnf = '1' AND user7 != 'Virginia') AND (list = '1' and cnf = '1' AND user7 != 'Missouri') AND (list = '1' and cnf = '1' AND user7 != 'Kansas') AND (list = '1' and cnf = '1' AND user7 != 'Vermont') AND (list = '1' and cnf = '1' AND us

Is there a fix for this?  I don't think I really need it as I've found a way to do what I need with the GUI selector (in 1.85 it wouldn't even keep long queries properly in the automatic GUI selector, so my problem was mostly fixed).  Thanks,
--Kyle

Title: User Selection Custom Query Limitations?
Post by: DW on October 21, 2007, 04:03:27 am

Hi Kyle,

Are you familiar with PhpMyAdmin?  Try this query, which will be applied in future updates:

Code: [Select]

ALTER TABLE lm_selectd CHANGE q q TEXT NOT NULL
Regards

Title: User Selection Custom Query Limitations?
Post by: kyle on October 21, 2007, 09:15:52 am

Great, thanks Dean!
--Kyle