Hi,
Not sure if this is what you need, this is the query that I use in order to obtain the values of an attribute:
$attributeId = Mage::getResourceModel('eav/entity_attribute')->getIdByCode('catalog_product', '%attributecode%');
$options = Mage::getResourceModel('eav/entity_attribute_option_collection')
->setAttributeFilter($attributeId)
->setPositionOrder('asc', true)
->setStoreFilter(0)
->load();