This forum has been moved here:
Helicon Tech Community Forum

  Active TopicsActive Topics  Display List of Forum MembersMemberlist  HelpHelp   RegisterRegister  LoginLogin
Helicon Ape
 Helicon Tech : Helicon Ape
Subject Topic: Stored procedures for mod_dbd Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
siteone
Groupie
Groupie


Joined: 07 March 2007
Location: United Kingdom
Online Status: Offline
Posts: 51
Posted: 11 July 2011 at 5:29am | IP Logged Quote siteone
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 View siteone's Profile Search for other posts by siteone Visit siteone's Homepage
 
Vyacheslav
Admin Group
Admin Group


Joined: 02 July 2008
Location: Ukraine
Online Status: Offline
Posts: 1542
Posted: 11 July 2011 at 6:07am | IP Logged Quote Vyacheslav
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 View Vyacheslav's Profile Search for other posts by Vyacheslav Visit Vyacheslav's Homepage
 
siteone
Groupie
Groupie


Joined: 07 March 2007
Location: United Kingdom
Online Status: Offline
Posts: 51
Posted: 11 July 2011 at 8:26am | IP Logged Quote siteone
Thank you once again for a quick response!

Regs,
SiteOne
Back to Top View siteone's Profile Search for other posts by siteone Visit siteone's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You can vote in polls in this forum