SQL Azure updates.

- Can now install on MS SQL
- Will create a SQL Server DB if one does not exist
- Can run the CMS and Admin on SQL Server
Completed. Thank you.

 

Patrick

 

From: Brian Teeman [mailto:notifications@github.com] 
Sent: Tuesday, December 02, 2014 5:43 PM
To: joomla/joomla-cms
Cc: pmorrisarctg
Subject: Re: [joomla-cms] SQL Azure updates. (#5293)

 

In libraries/joomla/database/query/sqlsrv.php:

> @@ -275,7 +331,7 @@ public function processLimit($query, $limit, $offset = 0)
>              $rowNumberText = ', ROW_NUMBER() OVER (' . $orderBy . ') AS RowNumber FROM ';
>  
>              $query = preg_replace('/\sFROM\s/i', $rowNumberText, $query, 1);
> -            $query = 'SELECT * FROM (' . $query . ') _myResults WHERE RowNumber BETWEEN ' . $start . ' AND ' . $end;
> +            //$query = 'SELECT * FROM (' . $query . ') _myResults WHERE RowNumber BETWEEN ' . $start . ' AND ' . $end;

Instead of commenting the line you should remove it - please

—
Reply to this email directly or view it on GitHub <https://github.com/joomla/joomla-cms/pull/5293/files#r21202134> .  <https://github.com/notifications/beacon/ACJs9yneWYmXlb7x688INlqZLf1KUzhoks5nTkXvgaJpZM4DDU1G.gif>