2008年11月10日星期一

Re: [fw-db] Zend Db Manual Query Problems

On Mon, Nov 10, 2008 at 3:49 AM, jbennett55 <jbennett55@gmail.com> wrote:
>
> Hi,
>
> I am getting this error from Zend Framework in my action controller:
> SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty
>
> There seem to be a number of resources online that point to setting the
> setIntegrityCheck to false on the select object:
> http://www.zfforums.com/zend-framework-components-13/databases-20/problems-join-672.html
>
> However, I am using a manual query and not a select object. Any suggestions?
> $sql = "<complex sql statement>";
> $result = $db->fetchAll($sql);

Are you sure you are looking at the correct part? Paste your code somewhere.

It sounds like indeed your $sql variable is empty.

Till

没有评论: