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.
