Changing list field content based on another fields input
11 posts by 4 authors in: Forums > CMS Builder
Last Post: January 20, 2011 (RSS)
By Chris - January 20, 2011
Hi Djulia,
Yes. For example, a search for %1% will turn up 1, 10, 11, 41, 172, etc. Values in CMS Builder multi value fields are surrounded by tabs (represented by \t in SQL strings,) so you can safely search for %\t1\t%, which will only turn up 1.
>> ...so that you don't get false positives.
Is that a big risk ?
Yes. For example, a search for %1% will turn up 1, 10, 11, 41, 172, etc. Values in CMS Builder multi value fields are surrounded by tabs (represented by \t in SQL strings,) so you can safely search for %\t1\t%, which will only turn up 1.
All the best,
Chris
Chris