|
Tuesday 19 May 2009 6:23:16 am
Hi I have the following code in a template doing a simple query via ezcDb api
$query ='SELECT LOCATION_NAME as name,
LOCATION_ID as id FROM LOCATION WHERE LOCATION_TYPE_ID = 2
AND PARENT_LOCATION_ID = '.$country_id;
$confObject = databaseconfig::getInstance();
$dbconfig = $confObject->getConfig();
$db = ezcDbFactory::create($dbconfig);
ezcDbInstance::set( $db );
$db = ezcDbInstance::get();
$rows = $db->query($query) ;
return $rows->fetchAll();; However I would like to convert this from the quesry above to calling a stored proceedure but can't find anything in the documentation for how to call a stroed procedure. Can any one help Thanks
|
