filipeServer

sql server 2000

não ajudou o link http://forum.imaster...há-em-um-select não pega , tem outra dica

alguém pode me explicar por que esta dando esse erro Warning: mssql_query() [function.mssql-query]: message: 'ROW_NUMBER' is not a recognized function name. (severity 15) in C:\wamp\www\admin\mall_items.php on line 27 Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\admin\mall_items.php on line 27 $query = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Items.item_order ASC) AS Row, * FROM Items) AS A WHERE A.Row >= $select_from AND A.Row <= $select_to"; $item_list= mssql_query($query);