[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]warrennz[/eluser]
Issue ? Helps

Categories N:1 Products

This works fine as one might expect

Code:

$c = new Category();
$c->get_by_id('9000');

$p = $c->product->where('enabled',1)->get();

How ever this returns an ambiguous error as the category table also has an 'enabled' field

Code:

$p = $c->product->where('enabled',1)->join_related('category',array('name'))->get();

Is there another way to do this? I would rather avoid writing the table name in every where() clause where this occurs

Cheers

EDIT

This outputed query is; (the table prefix is 'cl')

SELECT `cl_products`.*, `cl_categories`.`name` AS category_name FROM (`cl_products`) LEFT JOIN `cl_categories_products` as cl_categories_products ON `cl_products`.`id` = `cl_categories_products`.`product_id` LEFT JOIN `cl_categories` as cl_categories ON `cl_categories`.`id` = `cl_categories_products`.`category_id` WHERE `enabled` = '1' AND `cl_categories`.`id` = '1'