Tuesday 19 May 2009 3:23:16 pm - 4 replies
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) ;
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
Friday 20 April 2012 12:00:27 pm
Has there been any developments in this area?
I am building a solution that implements some custom tables (extending eZPersistentObject) and the usage of MySQL stored procedures would definitely simplify most of the data retrieval system.
You must be logged in to post messages in this topic!