OR operator in searches
2 posts by 2 authors in: Forums > CMS Builder
Last Post: August 23, 2012 (RSS)
By apolgree - August 23, 2012
If I have a search such as domain.com/testviewer.php?product_keyword=Hammers
this produces all the records with the word "Hammers" in the product field.
If I use domain.com/testviewer.php?product_query=Hammers+Nails
this produces all the records that have the word "Hammers" AND the word "Nails" in the product field.
If I want to return all the records that have "Hammers" OR "Nails" in the product field is there a way to do that?
Thanks.
this produces all the records with the word "Hammers" in the product field.
If I use domain.com/testviewer.php?product_query=Hammers+Nails
this produces all the records that have the word "Hammers" AND the word "Nails" in the product field.
If I want to return all the records that have "Hammers" OR "Nails" in the product field is there a way to do that?
Thanks.
Re: [apolgree] OR operator in searches
By Jason - August 23, 2012
Hi,
Currently, getRecords() doesn't support that type of query being generated automatically. In order to do this, you would need to parse and build your WHERE clause manually. If this is something you need, please email consulting@interactivetools.com and we can go over some options.
Thanks
Currently, getRecords() doesn't support that type of query being generated automatically. In order to do this, you would need to parse and build your WHERE clause manually. If this is something you need, please email consulting@interactivetools.com and we can go over some options.
Thanks
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/