QUERY: SELECT txtAlt.fShortTextEN AS alt,txtTitle.fShortTextEN AS title,txtDesc.fTexteEN AS descP,fLienPhoto, fphotosID, fOrdre, fPhotosNom
FROM tblphotos
LEFT JOIN tblTexte AS txtAlt ON txtAlt.fLinkedID=tblPhotos.fPhotosID AND txtAlt.fTexteTypeID=11
LEFT JOIN tblTexte AS txtTitle ON txtTitle.fLinkedID=tblPhotos.fPhotosID AND txtTitle.fTexteTypeID=12
LEFT JOIN tblTexte AS txtDesc ON txtDesc.fLinkedID=tblPhotos.fPhotosID AND txtDesc.fTexteTypeID=14
WHERE (tblphotos.fCompagnieID = ) and tblPhotos.fPageID=677 ORDER BY fOrdre
Fatal error: Uncaught exception 'Exception' with message '[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ')'.' in D:\inetpub\sdpinc.ca\xone\ns\core\db\drivermssql\v1\drivermssql.php:185
Stack trace:
#0 D:\inetpub\sdpinc.ca\xone\ns\core\db\drivermssql\v1\drivermssql.php(39): ns\core\db\drivermssql->checkError('SELECT txtAlt.f...')
#1 D:\inetpub\sdpinc.ca\xone\ns\core\db\v1\db.php(29): ns\core\db\drivermssql->execute('SELECT txtAlt.f...', Array)
#2 D:\inetpub\sdpinc.ca\web\pages\677-realisations.php(41): ns\core\db->execute('SELECT txtAlt.f...')
#3 D:\inetpub\sdpinc.ca\xone\ns\core\base\v1\base.php(323): require_once('D:\\inetpub\\sdpi...')
#4 D:\inetpub\sdpinc.ca\xone\ns\web\layout\page\v1\page.php(15): ns\core\base->includeWorkingFile('677-realisation...')
#5 D:\inetpub\sdpinc.ca\xone\ns\web\layout\v1\layout.php(17): ns\web\layout\page->myrun()
#6 D:\inetpub\sdpinc.ca\xone\ns\core\v1\core.php(85): ns\web\layout->__run()
#7 D:\inetpub\sdpinc.ca\xone\ns\core\v1\core.php(83): ns\core->loopObjAndC in D:\inetpub\sdpinc.ca\xone\ns\core\db\drivermssql\v1\drivermssql.php on line 185