Trochę się naszukałem, popróbowałem jednak żaden ze sposobów przeze mnie znalezionych nie działa w SF 1.4.
http://gajdaw.pl/bd/propel-porady/print.html#R3

Domyślnie propel wyciąga wszystkie kolumny z tabeli, ale jest to mało optymalne.

[EDIT]
  1. $oCriteria = new Criteria();
  2. $oCriteria->clearSelectColumns();
  3. $oCriteria->addSelectColumn(LmUsersGroupsPeer::NAME);
  4.  
  5. $rs = LmUsersGroupsPeer::doSelect($oCriteria);
  6. $this->groups = array();
  7.  
  8. while($rs->next()) {
  9. $tmp = array('imie' => $rs->get(1));
  10. }
  11.  
  12. $this->groups[] = $tmp;


Kod
Notice: Undefined offset: 1 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 630

Notice: Undefined offset: 2 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 631

Notice: Undefined offset: 3 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 632

Notice: Undefined offset: 4 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 633

Notice: Undefined offset: 5 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 634

Notice: Undefined offset: 6 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 635

Notice: Undefined offset: 7 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 636

Notice: Undefined offset: 8 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 637

Notice: Undefined offset: 9 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 638

Notice: Undefined offset: 10 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 639

Notice: Undefined offset: 11 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 640

Notice: Undefined offset: 12 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 641

Notice: Undefined offset: 1 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 630

Notice: Undefined offset: 2 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 631

Notice: Undefined offset: 3 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 632

Notice: Undefined offset: 4 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 633

Notice: Undefined offset: 5 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 634

Notice: Undefined offset: 6 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 635

Notice: Undefined offset: 7 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 636

Notice: Undefined offset: 8 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 637

Notice: Undefined offset: 9 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 638

Notice: Undefined offset: 10 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 639

Notice: Undefined offset: 11 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 640

Notice: Undefined offset: 12 in C:\xampp\htdocs\phplivemessenger\lib\model\om\BaseLmUsersGroups.php on line 641

Fatal error: Call to a member function next() on a non-object in C:\xampp\htdocs\phplivemessenger\apps\backend\modules\Users\actions\actions.class.php on line 32


Zmieniłem kod na:
  1. /* create new user */
  2. public function executeCreateUser() {
  3. $oGroups = new Criteria();
  4. $oGroups->clearSelectColumns();
  5. $oGroups->addSelectColumn(LmUsersGroupsPeer::NAME);
  6. $oGroups->addDescendingOrderByColumn(LmUsersGroupsPeer::NAME);
  7. $this->groups = LmUsersGroupsPeer::doSelectStmt($oGroups);
  8.  
  9. }


template:
  1. $groups = $sf_data->getRaw('groups');
  2. $i = 0;
  3. foreach($groups->fetchAll() as $val) {
  4. echo $val[$i];
  5. $i++;
  6. }


Problem polega na tym, że kod wyświetla tylko jeden rekord w bazie danych nie wiem za bardzo jak wczytać więcej rekordów.

[b][ROZWIĄZANIE][b]
Akcja:
  1. public function executeCreateUser() {
  2. $oGroups = new Criteria();
  3. $oGroups->clearSelectColumns();
  4. $oGroups->addSelectColumn(LmUsersGroupsPeer::NAME);
  5. $oGroups->addDescendingOrderByColumn(LmUsersGroupsPeer::NAME);
  6.  
  7. $this->groups = array();
  8. $this->groups[] = LmUsersGroupsPeer::doSelectStmt($oGroups);
  9.  
  10. }


Widok:
  1. $groups = $sf_data->getRaw('groups');
  2. $tmp = $groups[0]->fetchAll();
  3.  
  4.  
  5. for($i = 0; $i < count($tmp); $i++) {
  6. echo $tmp[$i]['NAME'];
  7. }