Hi,
I'm attempting to read a stored procedure contents (its code) by
issuing the following sql command:
SHOW CREATE PROCEDURE my_stored_procedure
That would return a table like:
procedure | sql_mode | Create Procedure
-------------------------------------------------------------------
my_stored_procedure | | CREATE [EMAIL PROTECTED] PROCEDURE
`my_stored_procedure`() BEGIN /*My procedure*/ End
On 'Create Procedure' Column, I get the stored procedure content.
So I'm trying to get stored procedure contents inside cakephp 1.2.6311
using the $model->query(), but I'm getting a null value for 'Create
Procedure' column:
$result = $model->query('SHOW CREATE PROCEDURE my_stored_procedure');
print_r($result);
will result:
Array ( [0] =>
Array ( [0] => Array (
[Procedure] => my_stored_procedure
[sql_mode] =>
[Create Procedure] =>
) ) )
Why it is returning a null value for [Create Procedure]?
it should return the stored procedure code
Any ideas?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
