Re: Custom SQL call problem

2008-04-18 Thread Defranco
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

Re: Custom SQL call problem (Solved! = My mistake)

2008-04-18 Thread Defranco
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.

Re: Custom SQL call problem

2008-04-17 Thread Defranco
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

Re: Custom SQL call problem

2008-04-17 Thread Erico Franco
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

Custom SQL call problem

2008-04-09 Thread Defranco
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 ---