+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Problem Select View With MSSQL (/showthread.php?tid=17383)
Problem Select View With MSSQL - El Forum - 04-03-2009
[eluser]Mellkior[/eluser]
I`m trying the follow code:
"SELECT TOP 10 * FROM V042_TaxaTransferenciaImpressao"
Where V042_TaxaTransferenciaImpressao is a view from database MSSQL 2005.
This SELECT Return a empty value on CodeIgniter. On Database the same SELECT work fine.
SELECT of any Table works, but not FROM VIEWS
Anyone knows some problem with view on CodeIgniter and Using driver MSSQL?
Thank You.
Problem Select View With MSSQL - El Forum - 04-03-2009
[eluser]kgill[/eluser]
Offhand it sounds like it could be a permissions problem, when you're running it from the database are you logging in using the username & password that your PHP will be using or just logging in using your windows credentials?
Problem Select View With MSSQL - El Forum - 05-26-2009
[eluser]Mellkior[/eluser]
For select data i use before sql:
$set = "SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
SET ANSI_PADDING ON
SET ARITHABORT ON";
$query = $this->ib->query($set);
Thanks