Re: Custom SQL call problem
On 17 abr, 17:26, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: is it returning something that cake should be able to understand? try debugging out the data in your *sql_dbo file before it gets put into an array Its a nice idea, but what is sql_dbo file? I tried to Google it but it just pointed to this post. thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Custom SQL call problem (Solved! = My mistake)
Solved! It was my mistake, not a bug: I had a user permission problem so it returned null for [Create Procedure] Thanks for your help Clark /defranco --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Custom SQL call problem
no ideas? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Custom SQL call problem
2008/4/17, [EMAIL PROTECTED] [EMAIL PROTECTED]: i know zilch about stored procedures, but this doesn't really seem to be a cake problem I think that it is a cake problem. what happens if you run that query outside of cake - on a regular php page or in an sql manager It works on both regular php page and works sql manager. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Custom SQL call problem
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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
