Re: Saving SQL query generated by the framework

2009-08-13 Thread siva linga reddy gangula
I want to know that can we do the cms with cake php On Thu, Aug 13, 2009 at 3:06 PM, siva linga reddy gangula < sivaling...@gmail.com> wrote: > > In php we can give the database connections like this > $con=mysql_connect("localhost","root",""); > $sel=mysql_select_db(dbanme); > > After we can

Re: Saving SQL query generated by the framework

2009-08-13 Thread siva linga reddy gangula
In php we can give the database connections like this $con=mysql_connect("localhost","root",""); $sel=mysql_select_db(dbanme); After we can write the sql query as for our view . $db =ConnectionManager::getDataSource('default'); debug($db->showLog()); On Aug 13, 7:43 am, Abhishek wrote: > H

Re: Saving SQL query generated by the framework

2009-08-13 Thread Abhishek
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

Re: Saving SQL query generated by the framework

2009-08-13 Thread majna
$db =ConnectionManager::getDataSource('default'); debug($db->showLog()); On Aug 13, 7:43 am, Abhishek 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

Saving SQL query generated by the framework

2009-08-12 Thread Abhishek
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 a