1

how I can use a method search for generate a query like this SEARCH(name) select * from person where name like '% name %' and how I set this method to filter a gridview? I only see the option for startwith and endwith

abigail armijo
  • 71
  • 5

1 Answers1

0

CFQL supports the concatenation operation, so you can use the following CFQL method:

SEARCH(Name) WHERE Name LIKE '%' + @Name + '%'

If you edit your model directly in XML, you have to escape the character %:

<cf:method name="SearchSample" body="SEARCH(Name) WHERE Name LIKE '%%' + @Name + '%%'" />

Formal grammar of CodeFluent Query Language (CFQL)

meziantou
  • 20,589
  • 7
  • 64
  • 83