Details
-
Type:
Improvement
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 2.2.1
-
Fix Version/s: None
-
Component/s: Package: ILP
-
Labels:None
-
Environment:Windows Server 2008
-
Database:Microsoft SQL
-
Workaround:
-
Affected Branches:MOODLE_22_STABLE
Description
It would be useful if the ILP 2.0 had support for the MS SQL Database. The following script has 6 lines with "SHOW TABLES LIKE.."
https://github.com/ULCC/moodle-block_ilp/blob/master/db/ilp_db.php
example:
$tableexists = $this->dbc->get_records_sql("SHOW TABLES LIKE '
{block_ilp_plugin}'");
Which is giving me at least the error:
[11:19:24] sqlsrv_query: message = [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'LIKE'.