Error when where clause as array.

earino · #1 (**permalink**) 02-07-2008, 05:05 PM

Greetings!

I am using 1.5PR. I have the following error being generated "Unknown column 'Array' in 'where clause'. The error is caused by:

$select = $sku_attribute_xref_factory->select()->where(array('sku_id = ?' => $sku_entry->id, 'attribute_id = ?'=> $attribute->id));

Which in Select.php, in protected method _where, generates a $condition of "(Array)." Am I doing it wrong or is this a bug in ZF?

Salz` · #2 (**permalink**) 02-07-2008, 06:20 PM

i'm not sure, but i think you have to do it in 2 steps instead of an array.

Code:

$select = $sku_attribute_xref_factory->select()->where('sku_id = ?',$sku_entry->id)->where('attribute_id = ?',$attribute->id));

greboguru · #3 (**permalink**) 02-19-2008, 12:15 PM

Hi,

I've just come across the same problem. According to the online documentation you can pass an array into the where() Zend Framework: Documentation look at example Example 10.93.

I'm guessing this is a bug or are we doing something wrong?

xentek · #4 (**permalink**) 02-27-2008, 06:44 PM

I'm also seeing this, and it seems like a bug to me. I haven't seen anything filed in the issue tracker, so I'm heading there now to do so.

xentek · #5 (**permalink**) 02-27-2008, 07:32 PM

Quote:

Originally Posted by Salz`

i'm not sure, but i think you have to do it in 2 steps instead of an array.

Code:

$select = $sku_attribute_xref_factory->select()->where('sku_id = ?',$sku_entry->id)->where('attribute_id = ?',$attribute->id));

Tried this, and it didn't work either. It doesn't error, but returns the metadata, and not the result set of the query.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode