AM trying to adapt a project am working on in mysql to mssql, but I get the following error while attempting to run this query:
PHP Code:
$this->usid = $user_tin;
$this->db->select('taxpayer_id')
->from('crirs_tin')
->where('tin', $this->usid)
->limit(1);
The error:
Code:
Error Number: HY000/208
General SQL Server error: Check messages from the SQL Server [208] (severity 16) [SELECT TOP 1 "taxpayer_id" FROM "crirs_tin" WHERE "tin" = '1903798293-0001' ]
SELECT TOP 1 "taxpayer_id" FROM "crirs_tin" WHERE "tin" = '1903798293-0001'
Filename: models/Account_m.php
Line Number: 45
It seems the error comes from the double quotes being wrapped around table names and columns. I haven't been able to sort this out, I'll be very grateful if anyone can show a way on how to remove the double qoutes!