Assemble IN clause for paginate

2011-04-28 Thread ZAky
1. I have a stored procedure that return an array of ids and can return a comma delimited string of ids if its better 2. A have a paginator that return all the data from a table. 3. When the user perform a search I take the search parameters and call the stored procedure. Now I have an array or

Re: Assemble IN clause for paginate

2011-04-28 Thread AD7six
On Apr 28, 8:29 am, ZAky procsh...@gmail.com wrote: 1. I have a stored procedure that return an array of ids and can return a comma delimited string of ids if its better 2. A have a paginator that return all the data from a table. 3. When the user perform a search I take the search parameters

Re: Assemble IN clause for paginate

2011-04-28 Thread euromark
your search term is an array of ids, right? than its as easy as using array('Asset.id' = $arrayOfIds) because cake will automatically make an IN here On 28 Apr., 09:25, AD7six andydawso...@gmail.com wrote: On Apr 28, 8:29 am, ZAky procsh...@gmail.com wrote: 1. I have a stored procedure