tp连接mssql

浏览:967 发布日期:2014/07/01 分类:求助交流 关键字: mysql,mssql,tp
tp改为连接mssql以后,解析sql语句有错误,怎么回事?比如,就$list=M("spa_category")->where("pid=0")->order("orders")->select(false);
mysql下是:SELECT * FROM `spa_category` WHERE pid=0 ORDER BY orders
而mssql下:( SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY orders) AS ROW_NUMBER FROM (SELECT * FROM spa_category WHERE pid=0) AS thinkphp) AS T1 %COMMENT% )
最后的 %COMMENT% 导致错误。如何解决?谢谢!
最佳答案
评论( 相关
后面还有条评论,点击查看>>