show us the stored procedure you have ... that way we could say .... On Wed, Jul 7, 2010 at 7:38 PM, Ricardo Jose Guzman Milanes < [email protected]> wrote:
> Hello > > I was searching in Google about how to call stored procedures, I found > this post in this group: > > http://groups.google.com/group/symfony-users/browse_thread/thread/099b770555a061cf/9fc9c7a67d69cda1?hide_quotes=no > > There Praveen recommended to use the following sintax: > > $wt=Doctrine_Manager::getInstance()->getCurrentConnection()- > >fetchAssoc > ('SELECT your_function()'); > > > I was testing around and pasted it in the executeNew action in > actions.php.Don't know if it is the correct place. > > public function executeNew(sfWebRequest $request) > { > $this->form = new personasForm(); > $wt=Doctrine_Manager::getInstance()->getCurrentConnection()- > >fetchAssoc > ('stored_proc_name_goes_here()'); > } > > > What I want to do is the following: > > When a new user is inserted into the sfGuardUser table and that user > belongs to a group on sfGuardUserGroup (doctors ), > the id of that user is inserted into a table that have the following > fields : > userID and Value, an example: > 1(userID), 0 (default value, Value) > > Can that be done via Doctrine without calling the stored procedure? > > Thanks for your help. > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Have a nice day! Alecs Certified ScrumMaster P.S. If you are on a list, please don't contact me privatelly, unless i have allowed to. Further messages will be ignored. There are no cannibals alive! I have ate the last one yesterday ... I am on web: http://www.alecslupu.ro/ I am on twitter: http://twitter.com/alecslupu I am on linkedIn: http://www.linkedin.com/in/alecslupu Tel: (+4)0722 621 280 -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
