Re: commands out of sync error

Thaq for ur response.
    i have called stored procedure from business layer(fnction name execute()) like this
    $sql = "CALL sp_viewAllDivisions('".$_SESSION[organisationSID]."');";   
  The stored procedure like this:

    CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_viewAllDivisions`(org_id int(11))
begin
    SELECT D.id_div, D.name_div, D.desc_div, D.active_div, D.modified_by, D.modified_date, E.fname_employee, E.lname_employee

FROM light_division AS D, light_employee AS E, light_org AS O WHERE D.modified_by = E.id_employee AND D.id_org = org_id ORDER

BY D.id_div DESC;
  end

The screenshot i have attatched is sevice browser from amfphp.
If i run the method from service browser i got that error.
if i am writing sql query instead of stored procedure in business layer it is working fine.I did
not get any error.
  plz help me



Regards
D.Mahesh Babu

On Thu, Dec 3, 2009 at 7:27 AM, Marcelo Andrade <mfandrade@gmail.com> wrote:

On Wed, Dec 2, 2009 at 4:44 AM, mahesh babu <maheshbabu.wb@gmail.com> wrote:
> hi,
> I have attatched  screenshot regarding my error.Here i am used flex with
> php.
> plz help me

Give us some information context to help you.

I program PHP in Linux, barely used Flex, don't know
nothing about your SQL query neither it was clear for
me what CakePHP has to do in that case.

Best regards.

--
MARCELO DE F. ANDRADE
Belem, PA, Amazonia, Brazil
Linux User #221105

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en