Hi there,

I’m having a little problem with ActiveRecord. I want to run a query like this:

I know you can write your own query and just run

method, but then you have a problem with the table’s prefix.

My questions are:

1. Is there an implementation of something like wherein() method in the ActiveRecord class?
2. If not, how can I access the database config to get the prefix? I tried using

but it returned an error like “Your database.php file does not appear to contain a valid configuration array.”, even though it works just fine through the entire application.

Thanks in advance.

Is there an implementation of something like wherein() method in the ActiveRecord class?

Not as far as I know.

I don’t really see what would prevent you using:

Or perhaps:

Might work with delete() if you would rather not user query().

I’m not sure if this will help - I hope it does.

gms - 05 June 2007 11:17 AM

Is there an implementation of something like wherein() method in the ActiveRecord class?

Not as far as I know.

I don’t really see what would prevent you using:

$this->db->query("DELETE FROM ci_news WHERE id IN(1,2,3)");

Or perhaps:

$this->db->where('id IN', '(1,2,3)');

Might work with delete() if you would rather not user query().

I’m not sure if this will help - I hope it does.

Actually, I have already tried that second one, but it results in a query like this:

which is not a valid query because of the quotes.

Of course, it quotes it becuase it thinks its a string, I don’t really know why I thought that might work. - that’s just the problem with active record I guess.

I’ve tried a few different things but to no avail - I’d go with the query() option to be honest if you know SQL there are not many reasons to use active record. Disabling it may also improve performance.

gms - 05 June 2007 03:09 PM

Of course, it quotes it becuase it thinks its a string, I don’t really know why I thought that might work. - that’s just the problem with active record I guess.

I’ve tried a few different things but to no avail - I’d go with the query() option to be honest if you know SQL there are not many reasons to use active record. Disabling it may also improve performance.

Besides to use the table prefix as he stated above .

I’m guessing it is possible to pull the prefix from the configuration… Does anyone know how?

To get the prefix you can use

Run print_r($this->db) in your controller, you will see all db config parameters.

I think that is what you were asking?

The second one, yes. Thanks!