User Selection Custom Query Limitations?

[kyle]

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

[DW]

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

[kyle]

Great, thanks Dean!
--Kyle