Re: commands out of sync error

2009-12-02 Thread Marcelo Andrade
On Wed, Dec 2, 2009 at 4:44 AM, mahesh babu maheshbabu...@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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: commands out of sync error

2009-12-02 Thread mahesh babu
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=`ro...@`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 mfandr...@gmail.com wrote:

 On Wed, Dec 2, 2009 at 4:44 AM, mahesh babu maheshbabu...@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+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en