This forum has been moved here:
Helicon Tech Community Forum

Helicon Ape (Forum Locked Forum Locked)
 Helicon Tech : Helicon Ape
Subject Topic: Stored procedures for mod_dbd
Author
Message |
siteone
Groupie


Joined: 07 March 2007
Location: United Kingdom
Posts: 51
Posted: 11 July 2011 at 5:29am

Hi Guys,

I'm just starting to get my head around mod_dbd and was wondering if you can call stored procedures?

If so and example on how to call it would be very helpful.

Regs,
SiteOne
Back to Top Visit siteone's Homepage
 
Vyacheslav
Admin Group


Joined: 02 July 2008
Location: Ukraine
Posts: 1542
Posted: 11 July 2011 at 6:07am

Hello.
mod_dbd is a bridge to link Helicon Ape modules with databases. Currently there are two modules which use mod_dbd: mod_authn_dbd, mod_rewrite and mod_seo.

All of them have special directives where one specifies SQL code to be executed. There is no specific support of calling stored procedures, however you can still run them using SQL syntax: “CALL MyStoredProc”.
Another example:

DBDPrepareSQL "CALL GetSeoTopic( @KEY );" getSeoTopic

Thank you.


__________________
Slavik Shynkarenko,
Helicon Tech.
Back to Top Visit Vyacheslav's Homepage
 
siteone
Groupie


Joined: 07 March 2007
Location: United Kingdom
Posts: 51
Posted: 11 July 2011 at 8:26am

Thank you once again for a quick response!

Regs,
SiteOne
Back to Top Visit siteone's Homepage
 

Sorry, you can NOT post a reply.
This forum has been locked by a forum administrator.

Printable version Printable version