Re: Assemble IN clause for paginate

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 and
> call the stored procedure.
>
> Now I have an array or string that I want to use as a condition to the
> paginator
>
> $this->set('assets', $this->paginate(array('Asset.id IN' =>
> $searchTerm)));

'Asset.id' =>

>
> Well its not working.

what query gets executed, what query are you wanting

>
> I tried to add '('.$searchTerm.')' with no success

what is that supposed to do (added it where?) what did it do.

> And several more things

I also sang the sacred chant, but no extra infromation or error
messages came forth.

AD

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php