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
interactivetools.com