Yeah, but read an error he's facing: PHP Fatal error: Call to undefined method RoutesPeer::doselectrs() in /apps/frontend/modules/route/actions/actions.class.php on line 39
So I've made the conclusion that he uses Propel 1.3. Joshua, 1 000 000 dollars question to you: What Propel version do you use? ;) On Feb 28, 2:39 pm, "[email protected]" <[email protected]> wrote: > Yes i'm aware of that and i know the difference between 1.2 and 1.3. > But Joshua mentioned doSelectRS in his second post, so i assume he's > using propel 1.2 > > For propel 1.3 it is doSelectStmt, you're right. > > Michael > > On 28 Feb., 10:34, vadim <[email protected]> wrote: > > > Michael, I guess the code you wrote wouldn't work in Propel1.3. As far > > as I'm concerned doSelectRS is not a case in Propel 1.3 anymore. One > > should use doSelectStmt instead. If I were you I would try right that: > > > $c = new Criteria(); > > > $c->clearSelectColumns(); > > > $c->addSelectColumn( '((ACOS(SIN('.$zipcode->getLat().' * PI > > () / 180) * SIN(`zipcodes`.LAT * PI() / 180) + COS('.$zipcode->getLat > > ().' * PI() / 180) * COS(`zipcodes`.LAT * PI() / 180) * COS(('. > > $zipcode->getLon().' - `zipcodes`.LON) * PI() / 180)) * 180 / PI()) * > > 60 * 1.1515) as distance'); //Jesus Christ! > > > $sum = RoutesPeer::doSelectStmt($c); > > > $total = array(); > > > while ($row = $sum->fetch(PDO::FETCH_NUM)) { > > $total[] = array( > > 'distance' => $row[0], > > //some other columns... > > ); > > > On Feb 28, 11:21 am, "[email protected]" > > > <[email protected]> wrote: > > > doSelectRS is the right way to access an array. > > > Example from propel docs: > > > > $rs = AuthorPeer::doSelectRS(new Criteria()); > > > > $names = array(); > > > > while($rs->next()) { > > > $names[] = $rs->getString(2); > > > > } > > > > Michael > > > > On 28 Feb., 02:23, Joshua <[email protected]> wrote: > > > > > On Feb 27, 6:51 pm, Eno <[email protected]> wrote: > > > > > > On Fri, 27 Feb 2009, Joshua wrote: > > > > > > $c = new Criteria(); > > > > > > $c->addAsColumn('distance', '((ACOS(SIN('.$zipcode->getLat().' * > > > > > > PI > > > > > > () / 180) * SIN(`zipcodes`.LAT * PI() / 180) + > > > > > > COS('.$zipcode->getLat > > > > > > ().' * PI() / 180) * COS(`zipcodes`.LAT * PI() / 180) * COS(('. > > > > > > $zipcode->getLon().' - `zipcodes`.LON) * PI() / 180)) * 180 / PI()) > > > > > > * > > > > > > 60 * 1.1515)'); > > > > > > RoutesPeer::addSelectColumns($c); > > > > > > $c->setLimit(10); > > > > > > $c->addAscendingOrderByColumn('distance'); > > > > > > $c->addJoin(ZipcodesPeer::ZIPCODE, RoutesPeer::ZIP_CODE); > > > > > > $this->featuredRoutes = RoutesPeer::doSelect($c); > > > > > > > I need to be able to access "distance" column. The above code will > > > > > > give me an array of Routes objects but does not include the distance > > > > > > column. > > > > > > > What can I do to access all the necessary columns including custom > > > > > > ones? > > > > > > I think, if you're using raw SQL inside a peer class, you will have to > > > > > iterate through the rows and hydrate the objects yourself (I guess > > > > > this > > > > > also means you need the model classes and schema as well right?). > > > > > > -- > > > > > I thought there was a way to have propel return the exact values as a > > > > PHP array. Is that supposed to be done by doSelectRS maybe? It returns > > > > an error when I try to use it? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
