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 <[email protected]> wrote:
> On Wed, Dec 2, 2009 at 4:44 AM, mahesh babu <[email protected]>
> 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 [email protected]
> To unsubscribe from this group, send email to
> [email protected]<cake-php%[email protected]>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 [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
