First lets create the query we want to use to retrieve our tree data with: // test.php // ... $q = Doctrine_Query::create() ->select('c.name, p.name, m.name') ->from('Category c') ->leftJoin('c.HottestProduct p') ->leftJoin('p.Manufacturer m'); Now we need to set the above query as the base query for the tree: $treeObject = Doctrine_Core::getTable('Category')->getTree(); $treeObject->setBaseQuery($q); $tree = $treeObject->fetchTree(); There it is, the tree with all the related data you need, all in one query.

$this->linea = Doctrine_Query::create()    ->select('MAX(linea) AS linea')    ->from('Tabla')    ->execute();

$ws = new sfWidgetFormSchema(array('name' => new sfWidgetFormInput()));   $ws->setDefault('name', 'Fabien');   // which is equivalent to   $ws['name']->setDefault('Fabien');   // or   $ws->setDefaults(array('name' => 'Fabien'));

<?php echo $form->renderFormTag('foo/contact') ?> <table> <?php echo $form['name']->renderRow() ?> <?php echo $form['email']->renderRow() ?> <?php echo $form['subject']->renderRow() ?> <?php echo $form['message']->renderRow() ?> <tr> <td colspan="2"> <input type="submit" /> </td> </tr> </table> </form>

public function configure() { unset( $this['jobeet_affiliates_list'], $this['created_at'], $this['updated_at'] );   $this->embedI18n(array('en', 'fr')); $this->widgetSchema->setLabel('en', 'English'); $this->widgetSchema->setLabel('fr', 'French'); }

//generator.yml form: display: Espanol: [es] Italiano: [it] fijos: [forma_pago, moneda_code]