Kohana 3.1 ORM: How to make 'where ... in' clause

kohana-3 kohana-orm
DondeEstaMiCulo picture DondeEstaMiCulo · Apr 13, 2011 · Viewed 9.6k times · Source

Thanks to Kohana's excellent documentation, I'm having to resort to prostrate myself on SO. ;)

Hopefully this is really simple: I'm trying to gather all stories which belong to a certain group of IDs. My code is as follows:

$story_ids = '(12,56,99,213,319)';
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

However, this is obviously not working. I'm getting a MySQL error because single-quotes are being put around the $story_ids string in the query.

EDIT: I've also tried passing $story_ids as an array, but then I just get a "500 Internal Server Error"

Is it possible to do what I'm asking?

Thanks in advance.

Answer

Kusmayadi picture Kusmayadi · May 1, 2011

Passing $story_ids as an array should work. 

$story_ids = array(12,56,99,213,319);
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

What Kohana version do you use?

Related questions

Kohana 3 ORM as_array return array of ORM

I'm executing a simple query and want to get an array back. Based on the ORM tutorial that comes with the Kohana 3 guide, I thought I could do the following: ORM::factory('user')->find_all()->as_…

Read More
client denied by server configuration

I try to setup kohana 3 project as virtual host. Config: <VirtualHost *:80> DocumentRoot "D:/Devel/matysart/matysart_dev1" ServerName matysart-one.local ServerAlias www.matysart-one.local DirectoryIndex index.php </VirtualHost> Error (403): [client 127.0.0.1] client denied by server configuration: D:/…

Read More
PHP: What does __('Some text') do?

Reading about Kohana templates and saw something I've never seen before: $this->template->title = __('Welcome To Acme Widgets'); What does __('Text') mean? What is it? What does it do?

Read More