Forums / Developer / Stroed Procedures and MS Sql Server 2000

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Stroed Procedures and MS Sql Server 2000

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Adam Butler

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

André R.

Tuesday 19 May 2009 6:49:43 am

You'll probably get more response if you post to the ezc mailing list.
As far as I know, ezc DB does not have any specific support for stored procedures yet.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Adam Butler

Tuesday 19 May 2009 6:57:13 am

Thanks Andre will do