Welcome Guest, Not a member yet? Register   Sign In
Unknown type in sqlsrv_buffered_query::sqlsrv_buffered_query in
#1

I have a view in ms sql server database:

Code:
SELECT        TOP (100) PERCENT dbo.YORUMLAR.ID, MAX(dbo.YORUMLAR.GONDERIMTARIHI) AS GONDERIMTARIHI, MAX(ALT_YORUMLAR.GONDERIMTARIHI) AS ALTYORUMGONDERIMTARIHI,
                         MAX(ALT_YORUM_YORUMLARI.GONDERIMTARIHI) AS ALTYORUMYORUMUGONDERIMTARIHI, MAX(dbo.YORUM_BEGENMELERI.BEGENMETARIHI) AS BEGENMETARIHI,
                         dbo.fnGreatest(MAX(dbo.YORUMLAR.GONDERIMTARIHI), MAX(ALT_YORUMLAR.GONDERIMTARIHI), MAX(ALT_YORUM_YORUMLARI.GONDERIMTARIHI), MAX(dbo.YORUM_BEGENMELERI.BEGENMETARIHI))
                         AS SIRALAMATARIHI
FROM            dbo.YORUMLAR AS ALT_YORUM_YORUMLARI RIGHT OUTER JOIN
                         dbo.YORUMLAR AS ALT_YORUMLAR ON ALT_YORUM_YORUMLARI.USTYORUMID = ALT_YORUMLAR.ID RIGHT OUTER JOIN
                         dbo.YORUMLAR ON ALT_YORUMLAR.USTYORUMID = dbo.YORUMLAR.ID LEFT OUTER JOIN
                         dbo.YORUM_BEGENMELERI ON dbo.YORUMLAR.ID = dbo.YORUM_BEGENMELERI.YORUMID
GROUP BY dbo.YORUMLAR.ID, dbo.YORUMLAR.USTYORUMID
HAVING        (dbo.YORUMLAR.USTYORUMID = 0)
ORDER BY dbo.fnGreatest(MAX(dbo.YORUMLAR.GONDERIMTARIHI), MAX(ALT_YORUMLAR.GONDERIMTARIHI), MAX(ALT_YORUM_YORUMLARI.GONDERIMTARIHI),
                         MAX(dbo.YORUM_BEGENMELERI.BEGENMETARIHI)) DESC, dbo.YORUMLAR.ID DESC

When i want to list results of view with:

Code:
$db=$this->load->database('sohbetarenasi',TRUE);
print_r($db->select('*')->from('vwYORUMSIRALAMASI')->get()->result());die();


This error occurs:
Fatal error: Unknown type in sqlsrv_buffered_query:Confusedqlsrv_buffered_query in C:\inetpub\wwwroot\mysystem\system\database\drivers\sqlsrv\sqlsrv_driver.php on line 192
I'm a person from Turkiye. I don't know English very well and i can't write what i want to say sometimes (as now happenes  Blush ).

If i write something by mistake; please don't distress it and try to understand what i want to write.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB