/**
* Checks and returns the SQL query to the appropriate driver
*
* */
private function sql()
{
// Retrieves the name of the current driver
$driver = PDO4You::getDriver();
switch ($driver) {
case 'mysql':
case 'pgsql':
case 'cubrid':
case 'sqlite':
$sql = 'SELECT * FROM books LIMIT 2;';
break;
case 'mssql':
case 'dblib':
case 'sybase':
case 'sqlsrv':
$sql = 'SELECT TOP 2 * FROM books;';
break;
case 'oracle':
$sql = 'SELECT * FROM (SELECT ROW_NUMBER() OVER AS LIMIT FROM books) WHERE LIMIT <= 2;';
break;
default:
$sql = null;
}
return $sql;
}
