where clause
4 posts by 2 authors in: Forums > CMS Builder
Last Post: June 4, 2010 (RSS)
By MRI - June 4, 2010
Im trying to get something like this.. but i assume that "or" is correct..
'where' => " page_display LIKE '%\ALL\t%' or '%\Getting Here\t%' ",
'where' => " page_display LIKE '%\ALL\t%' or '%\Getting Here\t%' ",
Re: [MRI] where clause
By Jason - June 4, 2010
Hi,
I think you're looking for something more like this:
Hope this helps.
I think you're looking for something more like this:
'where' => "page_display LIKE '%\ALL\t%' OR page_display LIKE '%\Getting Here\t%'",Hope this helps.
---------------------------------------------------
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/
Re: [Jason] where clause
By MRI - June 4, 2010
perfect.. now is there a way to get it so It displays records that are tagged
Getting Here before records tagged All?
instead of displaying in random order?
Getting Here before records tagged All?
instead of displaying in random order?
Re: [MRI] where clause
By Jason - June 4, 2010
Hi,
If you'd like to sort them, try this:
Give that a try.
If you'd like to sort them, try this:
'where' => "page_display LIKE '%\ALL\t%' OR page_display LIKE '%\Getting Here\t%'",
'orderBy' => "page_display DESC",Give that a try.
---------------------------------------------------
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/