Author Topic: User Selection not coming up with selected users  (Read 1486 times)

lynda.kane

  • Posts: 49
    • View Profile
    • http://www.realhealth-online.com
User Selection not coming up with selected users
« on: April 15, 2005, 01:03:25 am »
Hi I wrote a user selction rule to search on my first custom field "country" for those members from the UK (of which there are a fair number) When I hit "show query" it cam up with this:

select * from lm_users where (1 and user1 like '%UK%') group by email;
0 users matched

What am I doing wrong?  :cry:

Thanks,

Lynda
Comments from the Energy Awareness Training

"A truly transformational weekend."
"the most EMPOWERING of anything I've done before."
"I didn't realise it was going to change my life!"

www.EAT.energyawareness.org
www.EnergyEgg.com
Tel :  +44 (0)207 617 7521

lynda.kane

  • Posts: 49
    • View Profile
    • http://www.realhealth-online.com
Multiple variables for a selection
« Reply #1 on: April 15, 2005, 01:08:53 am »
It sorted itself out and cam up with 40 members. Great!

Now, is there a way I can sort for UK or England or Great Britain in the same rule?  People enter their country in different ways!

Thanks,

Lynda
Comments from the Energy Awareness Training

"A truly transformational weekend."
"the most EMPOWERING of anything I've done before."
"I didn't realise it was going to change my life!"

www.EAT.energyawareness.org
www.EnergyEgg.com
Tel :  +44 (0)207 617 7521

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
User Selection not coming up with selected users
« Reply #2 on: April 15, 2005, 09:59:09 am »
I'm glad it sorted itself out.

To search for England or Great Britain in the same rule, simply use an [OR] statement in a new rule on the same level with the same search paramaters (changing the search text, of course).

To be sure you have the latest Selective Sending fixes, grab the latest files from the member area.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting