You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I use flourishlib in my project, MSSQL database, when I execute the command:
$sql = "WITH pagination AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY Mataisan) AS RowNumber,
Mataisan, Nhomtaisan, Ghichu, Maloaitaisan, DVCQ,
Donvitinh,ChuthichTS,DuAn_Truong,LoaiHinh
FROM TaiSan
)
SELECT *
FROM pagination where RowNumber BETWEEN 5 AND 8";
return $this->db->translatedQuery($sql);
I use flourishlib in my project, MSSQL database, when I execute the command:
$sql = "WITH pagination AS
(
SELECT
ROW_NUMBER() OVER (ORDER BY Mataisan) AS RowNumber,
Mataisan, Nhomtaisan, Ghichu, Maloaitaisan, DVCQ,
Donvitinh,ChuthichTS,DuAn_Truong,LoaiHinh
FROM TaiSan
)
SELECT *
FROM pagination where RowNumber BETWEEN 5 AND 8";
return $this->db->translatedQuery($sql);
an error message appears as follows:
#0 /home/nttoan/www/win_share/mvc/libs/fDatabase.php(2564): fDatabase->checkForError(Object(fResult), NULL) #1 /home/nttoan/www/win_share/mvc/libs/fDatabase.php(3027): fDatabase->performQuery('WITH pagination...', Object(fResult), Array) #2 /home/nttoan/www/win_share/mvc/libs/fDatabase.php(3325): fDatabase->run('WITH pagination...', 'fResult') #3 /home/nttoan/www/win_share/mvc/models/taisan_model.php(21): fDatabase->translatedQuery('WITH pagination...') #4 /home/nttoan/www/win_share/mvc/controllers/taisan.php(11): TaiSan_Model->taiSanList() #5 /home/nttoan/www/win_share/mvc/libs/Bootstrap.php(155): TaiSan->index() #6 /home/nttoan/www/win_share/mvc/libs/Bootstrap.php(31): Bootstrap->_callControllerMethod() #7 /home/nttoan/www/win_share/mvc/index.php(21): Bootstrap->init() #8 {main}
However, if you use $ this-> db-> query ($ sql) then everything is ok.UTF8 is required in my project, looking forward to your help.
The text was updated successfully, but these errors were encountered: