Where Statement comparing two table fields

17 Posts

chrizz Reply #1, 14 years ago

Sorry guys, didn't find anything in the docs... sad

I have a multiple where condition:

$c->leftJoin("ugallerymeta_data", "Metadata", "Metadata.resource_id = ugallerymeta.id");
$c->where(array("class_key" => "ugalleryMeta", "Metadata.dimensions_outer_height:>" => "Metadata.dimensions_outer_width" ));

When I take a look at the mysql query the where condition is translated to this:

 AND `Metadata`.`dimensions_outer_height` > '`Metadata`.`dimensions_outer_width`'

The "value" is obviously treated as a string and so my question is: Is there a way to compare to table fields in a where statement?

thanks a lot,
Chris

*there are no strangers - just friends who never met*

MODX Staff
10,725 Posts

opengeek Reply #2, 14 years ago

$c->where(array(
    "class_key" => "ugalleryMeta", 
    "Metadata.dimensions_outer_height > Metadata.dimensions_outer_width"
));

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

17 Posts

chrizz Reply #3, 14 years ago

yay... thank you very much

*there are no strangers - just friends who never met*