[eluser]Joker[/eluser]
[quote author="web-johnny" date="1303470852"][quote author="Joker" date="1303461339"]Great work for u grad.. for mysql doing great on my application, but when i transfer to mssql default driver from ci i got blank white page when access the function ..
For mssql i got make change for SET NAMES = UTF8 (i don't know how to replace on mssql ) and
SHOW Column , when looks select data type from tabel .... i make view on mssql with but i exec With EXEC SHOW COLUMN
Still Blank white in page ?...... any sugested what's wrong in my styntac[/quote]
The blank wepbage is because you have the error_reporting(0); Go to your index.php and change the error_reporting to E_ALL ( if you have 1.7.3 - 2.0.1) or define('ENVIRONMENT', 'development'); if you use 2.0.2 . Please do this first, because the error can be everywhere. If you are more specific I can help you. As you have seen ALL the code for the database is on the model. You are in the right place...[/quote]
Thanks for quick answer ,... i will try your suggestion, yup the error was on the model , when SET NAMES = UTF8 firts error (i was disable it) after that on SHOW COLUMN for looking Structure of table (i create view on mssql with name Show_column)i change with EXE Show_column 'table_name'
After that was blank ....
OK i will inform next ...
Hem the result was
"Fatal error: Cannot access empty property in I:\susilo\xampp\htdocs\crudme\application\third_party\grocery_crud\libraries\grocery_crud.php on line 852
"
maybe can u try it
CREATE procedure [dbo].[Show_Columns]
(
@table_name nvarchar(384)
) as
begin
Select
column_name as Field,
data_type+cast('(' as varchar)+cast(character_maximum_length as varchar)+cast(')' as varchar) as 'Type',
is_nullable as 'Null',
'' as 'Key',
column_default as 'Default',
'' as Extra
from information_schema.columns WHERE table_name = @table_name
end
