• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MSSQL ERROR

#1
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!
Reply


Messages In This Thread
MSSQL ERROR - by aknessy - 07-22-2016, 02:10 AM
RE: MSSQL ERROR - by mwhitney - 07-22-2016, 11:21 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.