Been using this snippet to retrieve the attribute values but this only works for input type text or boolean but not for dropdown type of attributes:
$_resource = Mage::getResourceSingleton('catalog/product');
$_resource->getAttributeRawValue($_productId, 'color', Mage::app()->getStore());
For the select dropdown type, it returns bool(false) and I am expecting it would return the dropdown frontend value/label.
How can I get the attribute value of a product without loading the whole product model?
Thank you.