[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-10-02 Thread Gareth McCumskey
This article is what I read when I needed to setup and manage multiple databases in symfony: http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony-with-propel/ The best bet to see how custom queries run is to look at the Propel documentation itself on the doSelectRS statement if

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-10-01 Thread Gareth McCumskey
Stored procedures, while seemingly convenient, are actually not a good idea if you want to ensure your application remains properly database abstracted/agnostic. Stored procedures are in most cases not transferable between database type. For example, MySQL handles stored procedures very

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-10-01 Thread Farrukh Abbas
yeah thanks for the heads up ... i don't have a choice, my application has to interact with a third party service and the only way they provide is through stored procedures ... so really don't have a choice ... any pointers to where i can get some good read about propel custom queries? and also

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-09-30 Thread dagger
any suggests? On Sep 28, 11:22 am, Farrukh Abbas strategy.vs.lo...@gmail.com wrote: I'm using propel as orm -- Kind regards Farrukh Abbas On 28 Sep 2009, at 09:20, Gareth McCumskey gmccums...@gmail.com wrote: Are you using Propel or Doctrine as your ORM? On Mon, Sep 28, 2009 at

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-09-30 Thread Richtermeister
Hey dagger, it'll have to be a custom query to the effect of Call xyx(), but depending on what data is returned you may still rely on regular propel hydration. Or some manual handling of the result set.. Just for the record, I had major issues last time I tried accessing stored procedures via

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-09-28 Thread Gareth McCumskey
Are you using Propel or Doctrine as your ORM? On Mon, Sep 28, 2009 at 2:42 AM, dagger strategy.vs.lo...@gmail.com wrote: Hi, in my current project I have to connect to a remote system and execute some stored procedures then get the returned data and save it on to the local database... Is

[symfony-users] Re: How to execute a stored procedure on a remote db server throught symfony?

2009-09-28 Thread Farrukh Abbas
I'm using propel as orm -- Kind regards Farrukh Abbas On 28 Sep 2009, at 09:20, Gareth McCumskey gmccums...@gmail.com wrote: Are you using Propel or Doctrine as your ORM? On Mon, Sep 28, 2009 at 2:42 AM, dagger strategy.vs.lo...@gmail.com wrote: Hi, in my current project I have to