Help Creating 'where' statement

12 posts by 2 authors in: Forums > CMS Builder
Last Post: March 27, 2018   (RSS)

By Dave - March 26, 2018

Hi nmsinc, 

Ok, I think I see the issue.  Try adding a $ to the variable named (typo in my original post):

'where'       => " when_to_bill LIKE '%\t$monthNum\t%' ", // search for month num in tab delimited field,

If that doesn't work, try partial searches '%%' should return everything, '%12%' should return record 12 (or anything with a 12 in it).  Then try them with tab characters, '%\t12\t%'.  Basically, we want to see where it stops working.

Let me know how that goes!

Dave Edis - Senior Developer
interactivetools.com

By nmsinc - March 27, 2018

The changes worked!

Thanks - nmsinc

nmsinc