sqlYoga Query Objects using multiple or
bobs at twft.com
Tue Aug 9 19:42:02 EDT 2011
If anyone is using sqlYoga and has experience creating query objects that have multiple or statements, gimme a holler offlist if you please. I am trying to build a query object which can find records that have partial matches for a given value in several columns. For instance, if the user types "Murr" into a search field, I want to find all records where sitename contains "murr" or sitecity contains "murr". Get it?
I can actually write the SQL for it, but I am trying to master query objects. I'd like to do as much as I can with sqlYoga without having to revert to the Livecode Database API.
More information about the Use-livecode