I have a raw sql query that selects all the columns in a table plus a
custom column (distance). I then use TablePeer::populateObjects() to
get my array of table objects.
This works fine, but I don't know how to get the custom column.
function inradius($lat,$lon,$radius){
$connection = Propel::getConnection();
$query = 'SELECT *, (3959*acos(cos(radians('.$lat.'))*cos(radians(%s))
*cos(radians(%s)-radians('.$lon.'))+sin(radians('.$lat.'))*sin(radians
(%s)))) AS distance FROM %s HAVING distance <'.$radius.' ORDER BY
distance LIMIT 0 , 6;';
$query = sprintf($query, TablePeer::LATITUDE, TablePeer::LONGITUDE,
TablePeer::LATITUDE, TablePeer::TABLE_NAME);
$stmt = $connection->prepareStatement($query);
$rs = $stmt->executeQuery($query, ResultSet::FETCHMODE_NUM);
$tableobjects = TablePeer::populateObjects($rs);
return $tableobjects;
}
How can I also return the distance (the alias for the custom select
column) with the table objects? I suppose I could edit populateObjects
() but it would be no good once I rebuild the model. Or I could do an
extra query for each object to get the distance, but that seems
redundant when I already have all the data I need in this one query.
Any ideas would be greatly appreciated!
Thanks, Zach
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
