function loadByCode($langId) { try { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(LanguagePeer::LAN_NAME); $oCriteria->add(LanguagePeer::LAN_ID, $langId); $oDataset = LanguagePeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aRow = $oDataset->getRow(); $aRow['LANGUAGE_NAME'] = $aRow['LAN_NAME']; if (is_array($aRow)) { return $aRow; } else { throw new Exception("The language '{$langId}' doesn\\'t exist!"); } } catch (exception $oError) { throw $oError; } }
public function findLocationByLanId($languageId) { try { if (!isset(self::$arrayRecord[$languageId])) { $criteria = new Criteria("workflow"); $criteria->addSelectColumn(LanguagePeer::LAN_LOCATION); $criteria->add(LanguagePeer::LAN_ID, $languageId, Criteria::LIKE); $rsCriteria = LanguagePeer::doSelectRS($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rsCriteria->next(); self::$arrayRecord[$languageId] = $rsCriteria->getRow(); } $record = self::$arrayRecord[$languageId]; //Return return $record; } catch (Exception $e) { throw $e; } }
public function findByLanName($LAN_NAME) { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(LanguagePeer::LAN_ID); $oCriteria->addSelectColumn(LanguagePeer::LAN_NAME); $oCriteria->add(LanguagePeer::LAN_NAME, $LAN_NAME, Criteria::LIKE); $oDataset = LanguagePeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); return $oDataset->getRow(); }
/** * Method to do selects. * * @param Criteria $criteria The Criteria object used to build the SELECT statement. * @param Connection $con * @return array Array of selected Objects * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelect(Criteria $criteria, $con = null) { return LanguagePeer::populateObjects(LanguagePeer::doSelectRS($criteria, $con)); }