Strange PDO MySQL Problem

[MabelB]

I am trying to perform a query in a PHP script. The query works fine in my MySQL client however it does not seem to working within my code. I am using PDO. I am thinking it might have limitations, because it seems to work fine with a less complicated query. Here is the query:\[code\]SELECT D.status, D.createdBy, D.createDate, D.modifiedBy, D.modifiedDate,D.IPAddress, D.adminStatus, D.campus, D.buildingID, D.deviceShortName, D.distributionID, D.networkKey, D.deviceName, D.test, D.pkDevices, D.DNSRule, D.Domain, D.DNSOverride, D.noDNS, D.pkModel, DM.Model, DM.pkManufacturer, M.manufacturer FROM Devices AS D INNER JOIN DeviceModel AS DM ON D.pkModel = DM.pkModel INNER JOIN Manufacturer AS M ON DM.pkManufacturer = M.pkManufacturer WHERE D.status = '1' AND D.adminStatus = 'Active' ORDER BY D.deviceName\[/code\]Here is where I am trying to call it in my script:\[code\]$dbhDevices = newPDO('mysql:host='.$_SESSION['OpsDBServer'].'.ops.tns.its.psu.edu;dbname='.$_SESSION['OpsDB'], $_SESSION['yoM'], $_SESSION['aMa']);$sqlDevices = "SELECT D.status, D.createdBy, D.createDate, D.modifiedBy,D.modifiedDate, D.IPAddress, D.adminStatus, D.campus, D.buildingID,D.deviceShortName, D.distributionID, D.networkKey, D.deviceName, D.test,D.pkDevices, D.DNSRule, D.Domain, D.DNSOverride, D.noDNS, D.pkModel, DM.Model,DM.pkManufacturer, M.manufacturerFROM Devices AS DINNER JOIN DeviceModel AS DM ON D.pkModel = DM.pkModelINNER JOIN Manufacturer AS M ON DM.pkManufacturer = M.pkManufacturerWHERE D.status = '1' AND D.adminStatus = 'Active' ORDER BY D.deviceName";foreach ($dbhDevices->query($sqlDevices) as $rowDevices){\[/code\]Again, the query does work with the MySQL client.