Emty query result

2011-02-09 Thread Gopinath T.M
Warning (512): SQL Error: 1065: Query was empty [CORE/cake/libs/model/ datasources/dbo_source.php, line 549] how do i overcome from this error... -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site

Re: Emty query result

2011-02-09 Thread Jeremy Burns | Class Outfit
What code are you writing that triggers this error? Are you using the Model-query method? If so, what variable are you sending in? Is it empty? (This is just wild guess work.) Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 9 Feb 2011, at 07:36, Gopinath

Re: Emty query result

2011-02-09 Thread Gopinath T.M
ya its empty... in some case it may have value On Wed, Feb 9, 2011 at 2:08 PM, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: What code are you writing that triggers this error? Are you using the Model-query method? If so, what variable are you sending in? Is it empty? (This

Re: Emty query result

2011-02-09 Thread Jeremy Burns | Class Outfit
Then why not check for empty before you call the function? Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 9 Feb 2011, at 08:40, Gopinath T.M wrote: ya its empty... in some case it may have value On Wed, Feb 9, 2011 at 2:08 PM, Jeremy Burns | Class

Re: Emty query result

2011-02-09 Thread Gopinath T.M
i dont no can you please say how do i check variable empty or not... On Wed, Feb 9, 2011 at 2:12 PM, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: Then why not check for empty before you call the function? Jeremy Burns *Class Outfit* * *

Re: Emty query result

2011-02-09 Thread Jeremy Burns | Class Outfit
$variable = SOME SQL STATEMENT;; if ($variable): $this-Model-query($variable); else: // oops - the query is empty - do something else instead endif; Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 9 Feb 2011, at 08:44, Gopinath T.M wrote: i

Re: Emty query result

2011-02-09 Thread Gopinath T.M
i should check the executed query contain value or not. On Wed, Feb 9, 2011 at 2:19 PM, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: $variable = SOME SQL STATEMENT;; if ($variable): $this-Model-query($variable); else: // oops - the query is empty - do something else