Welcome Guest, Not a member yet? Register   Sign In
Problem Select View With MSSQL
#1

[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.
#2

[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?
#3

[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




Theme © iAndrew 2016 - Forum software by © MyBB