Hi, For this i 'll have to set the debug level to atleast '2' .. secondly this would give in return all the queries executed for that page .. though i need to save only specific queries ..
let me give some background .. maybe that would help .. In the application there is an option where user can generate reports .. I intend to provide an option where he can save the report generated for future reference .. i guess the simplest way is to save the SQL query generated for that report .. Regards Abhishek Jain On Aug 13, 2:28 pm, majna <[email protected]> wrote: > $db =ConnectionManager::getDataSource('default'); > debug($db->showLog()); > > On Aug 13, 7:43 am, Abhishek <[email protected]> wrote: > > > Hi, > > How can i get the SQL query generated by the framework. It does get > > saved in the log, but in that case along with that lot of other > > information is saved. > > > I need to store just the SQL query generated as it is in a database so > > that i can retrieve them later > > and run them. > > > Any idea how do i go about it > > > Regards > > Abhishek Jainhttp://www.fidelus.in > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
