Anyway wouldn't the db adaptor handle such things?
Steve
tfk wrote:
>
> Hey Steve,
>
> On Sun, Apr 12, 2009 at 1:24 PM, srayner02 <srayner02@googlemail.com>
> wrote:
>>
>> I am completely new to Zend Framework, so please forgive my ignorance :-)
>>
>> Following the Quickstart tutorial, i am trying to adapt it to use a
>> firebird
>> database as opposed to SQLite.
>>
>> I have PHP_Interbase module loaded, and have added the ZendX firebird
>> database adaptor.
>>
>> However i am getting a Firebird prepare error -104 unexpected end of
>> command.
>> This is my stack trace;
>>
>> #0 C:\www\Quickstart\library\Zend\Db\Statement.php(109):
>> ZendX_Db_Statement_Firebird->_prepare('SELECT "guestbo...')
>> #1 C:\www\Quickstart\library\ZendX\Db\Adapter\Firebird.php(341):
>> Zend_Db_Statement->__construct(Object(ZendX_Db_Adapter_Firebird), 'SELECT
>> "guestbo...')
>> #2 C:\www\Quickstart\library\Zend\Db\Adapter\Abstract.php(432):
>> ZendX_Db_Adapter_Firebird->prepare('SELECT "guestbo...')
>> #3 C:\www\Quickstart\library\Zend\Db\Table\Abstract.php(1330):
>> Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select))
>> #4 C:\www\Quickstart\library\Zend\Db\Table\Abstract.php(1158):
>> Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
>> #5 C:\www\Quickstart\application\models\GuestBook.php(71):
>> Zend_Db_Table_Abstract->fetchAll('1')
>> #6 C:\www\Quickstart\application\controllers\GuestbookController.php(33):
>> Model_GuestBook->fetchEntries()
>> #7 C:\www\Quickstart\library\Zend\Controller\Action.php(503):
>> GuestbookController->indexAction()
>> #8
>> C:\www\Quickstart\library\Zend\Controller\Dispatcher\Standard.php(285):
>> Zend_Controller_Action->dispatch('indexAction')
>> #9 C:\www\Quickstart\library\Zend\Controller\Front.php(934):
>> Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http),
>> Object(Zend_Controller_Response_Http))
>> #10 C:\www\Quickstart\public\index.php(48):
>> Zend_Controller_Front->dispatch()
>> #11 {main}
>>
>> Looking at the stack trace does it appear that i have everything in the
>> right place?
>> I'm just not sure how to proceed in diagnosing the problem.
>>
>> Any help much appreciated. (Let me know if i should post more info).
>>
>> Steve
>
> Just guessing, but unexpected end of command generally means that the
> terminator wasn't "understood", so e.g. if you defined a stored
> procedure and the server doesn't recognize the terminator, it'll error
> out with this. I'm not too familiar with Firebird, but I'm guessing
> your SQL code uses a terminator (e.g. ";") that the server currently
> doesn't recognize as one.
>
> HTH,
> Till
>
>
--
View this message in context: http://www.nabble.com/Firebird-Prepare-Error-tp23010277p23011184.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论