It appears that your MS SQL Server environment does not recognize ANSI SQL delimited identifier syntax (i.e. the double-quotes around identifier names). You may be running MS SQL Server with QUOTED_IDENTIFIER set to OFF.
See also: http://framework.zend.com/issues/browse/ZF-1093 http://msdn2.microsoft.com/en-us/library/aa224033(SQL.80).aspx I just read in the latter page that QUOTED_IDENTIFIER is not set to ON by default when using DB-library (which is used by PDO_MSSQL). We should set this option on by default when connecting. I have reopened bug ZF-1093, and I'll fix this as soon as possible. Regards, Bill Karwin > -----Original Message----- > From: Roman1975 [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 04, 2007 12:50 PM > To: [email protected] > Subject: [fw-general] RE: Zend_Db pdo_mssql error > > > $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.
