$select = $db->select();
$select->from('Act');
echo $select->__toString();
Result:
SELECT "Act".* FROM "Act"
ZF v0.9.1
:)
Bill Karwin wrote:
>
> Hi Sir or Madam,
>
> Would you state which version of Zend Framework you are using?
>
> Would you please post the output of echo $select->__toString();
>
> Regards,
> Bill Karwin
>
>> -----Original Message-----
>> From: Roman1975 [mailto:[EMAIL PROTECTED]
>> Sent: Monday, April 02, 2007 11:45 PM
>> To: [email protected]
>> Subject: [fw-general] Zend_Db pdo_mssql error
>>
>>
>> php 5.2.1
>>
>> Mistake at use Zend_Db pdo_mssql
>> // conect ok
>> $db = $model->getDb();
>> $select = $db->select();
>> $select->from('Firms');
>> $db->fetchAll($select);
>>
>> Error:
>>
>> Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with
> message
>> 'SQLSTATE[HY000]: General error: 10007 Line 2: Incorrect syntax near
> '.'.
>> [10007] (severity 5) [(null)]' in
>>
> C:\home\t\texrdcom\project1\library\Zend\Db\Adapter\Pdo\Abstract.php:156
>> Stack trace: #0
>> C:\home\t\texrdcom\project1\library\Zend\Db\Adapter\Abstract.php(329):
>> Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array) #1
>>
> C:\home\t\texrdcom\project1\application\mssqladmin\controllers\IndexCont
> ro
>> ller.php(12):
>> Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select)) #2
>> C:\home\t\texrdcom\project1\library\Zend\Controller\Action.php(488):
>> Mssqladmin_IndexController->indexAction() #3
>>
> C:\home\t\texrdcom\project1\library\Zend\Controller\Dispatcher\Standard.
> ph
>> p(214):
>> Zend_Controller_Action->dispatch('indexAction') #4
>> C:\home\t\texrdcom\project1\library\Zend\Controller\Front.php(753):
>> Zend_Controller_Dispatcher_Standard-
>> >dispatch(Object(Zend_Controller_Request_Http),
>> Object(Zend_Controller_Response_Http)) #5
>> C:\home\t\texrdcom\project1\public_ in
>> C:\home\t\texrdcom\project1\library\Zend\Db\Adapter\Pdo\Abstract.php
> on
>> line
>> 156
>>
>> --
>> View this message in context: http://www.nabble.com/Zend_Db-pdo_mssql-
>> error-tf3510102s16154.html#a9804519
>> Sent from the Zend Framework mailing list archive at Nabble.com.
>
>
>
--
View this message in context:
http://www.nabble.com/Zend_Db-pdo_mssql-error-tf3510102s16154.html#a9844336
Sent from the Zend Framework mailing list archive at Nabble.com.
