Welcome Guest, Not a member yet? Register   Sign In
CI3 error with query SQLSERVER
#3

(This post was last modified: 01-27-2021, 01:50 AM by Y6700B.)

Hi I think CI has a problem when I use pivot function in sqlserver, I made another test usign the next query

PHP Code:
SELECT FROM 
SELECT DAY(CC.FECHA) AS DIA,CC.DOMINIO,CC.INCALLS
FROM 
[dbo].[CCOD_INFORME_COLA_DIARIO_AUX] AS CC 
LEFT JOIN 
[dbo].[COLAS] AS C ON C.COLA CC.COLA
WHERE CC
.AÑO 2021 AND MONTH(CC.FECHA) = AND C.IDAREA 
X PIVOT SUM(INCALLS) FOR DIA IN ([4],[5])) 

It´s simple but when I print the result in the controller only show me.

PHP Code:
(
    [0] => stdClass Object
        
(
            [DOMINIO] => IT HELP DESK
        
)

    [1] => stdClass Object
        
(
            [DOMINIO] => PAYROLL
        
)



When If I run it in SQlServerStudio gave a table that I want

Code:
DOMINIO             4    5
IT HELP DESK    14    19
PAYROLL            484    437

Anyone could fix this or have an example?
Reply


Messages In This Thread
CI3 error with query SQLSERVER - by Y6700B - 01-26-2021, 03:22 AM
RE: CI3 error with query SQLSERVER - by php_rocs - 01-26-2021, 09:07 AM
RE: CI3 error with query SQLSERVER - by Y6700B - 01-27-2021, 01:49 AM
RE: CI3 error with query SQLSERVER - by php_rocs - 01-27-2021, 07:49 PM
RE: CI3 error with query SQLSERVER - by Y6700B - 01-28-2021, 12:43 AM
RE: CI3 error with query SQLSERVER - by ojmichael - 01-27-2021, 11:57 PM
RE: CI3 error with query SQLSERVER - by php_rocs - 01-28-2021, 09:32 AM



Theme © iAndrew 2016 - Forum software by © MyBB