| Re: Problem with _cm_filterwhere, how can do this? [message #1695 is a reply to message #1694] |
Mon, 22 September 2008 18:46   |
AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
You cannot. The $where string is assumed to have been constructed from the primary keys of one or more table rows and may not accept some complex modifications as they may fall foul of the filtering process. This has to unpack the string into an array, examine each part for possible action (such as prefixing a field name with a table name, or removing the field altogether), then convert the array back into a string. During this process it is possible for extraneous parentheses to be removed.
Additional selection criteria may be added by using either $this->sql_where or $this->search.
In the example you give where you are including an additional conditon with an 'AND' I cannot see that the parentheses would make any difference.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
