Hey all, I was wondering if this can be done via Propel's Peer classes... WHERE NO1='302-3001' AND NO2=2892 AND -- the PART below is where i stumble LOWER( SUBSTR(FIRSTNAME,1,1) )='b' AND LOWER( SUBSTR(LASTNAME,1,1) )='r'
tried something like this before realized even though $first_initial is lowercase, if the field value is not, then i cant search for it: $c = new Criteria(); $crit0 = $c->getNewCriterion(TablenamePeer::FIRSTNAME, $first_initial); //??? $crit1 = $c->getNewCriterion(TablenamePeer::LASTNAME, $last_initial); //??? $crit0->addAnd($crit1); $c->add($crit0); $c->add(TablenamePeer::NO1, $no1); $c->add(TablenamePeer::NO2, $no2); also tried to think if was way to do it via LIKE but still need lower case... aka LOWER(FIRST_NAME) LIKE 'b%' $crit0 = $c->getNewCriterion(TablenamePeer::FIRSTNAME, $first_initial.'%', Criteria::LIKE); //??? still needs LOWER somehow to be put in there. I guess maybe a custom query not using the Peer classes is teh only way can be done since db functions are database specific? (unless maybe Propel abstracts the common functions) Thanks in advance!, Ari --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---