Stroed Procedures and MS Sql Server 2000

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

Author

Message

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

eZ debug

Timing:	Jan 30 2025 19:34:27
Script start
Timing:	Jan 30 2025 19:34:27
Module start 'layout'
Timing:	Jan 30 2025 19:34:27
Module start 'content'
Timing:	Jan 30 2025 19:34:27
Module end 'content'
Timing:	Jan 30 2025 19:34:27
Script end

Main resources:

Total runtime	0.0216 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.2656	151.2266
Module start 'layout'	0.0045	0.0036	739.4922	220.7188
Module start 'content'	0.0082	0.0119	960.2109	997.8359
Module end 'content'	0.0201	0.0015	1,958.0469	33.9922
Script end	0.0216		1,992.0391

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	11.7378	14	0.0002
Check MTime	0.0011	4.8776	14	0.0001
Mysql Total
Database connection	0.0007	3.2580	1	0.0007
Mysqli_queries	0.0024	11.1277	3	0.0008
Looping result	0.0000	0.0651	1	0.0000
Template Total	0.0011	5.0	1	0.0011
Template load	0.0009	4.1461	1	0.0009
Template processing	0.0002	0.8374	1	0.0002
Override
Cache load	0.0006	2.9943	1	0.0006
General
dbfile	0.0011	4.9151	8	0.0001
String conversion	0.0000	0.0309	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs