From 7039d93c319fa2e4a996030de8799e218a6c6f63 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Fri, 26 Jan 2007 21:28:48 +0000 Subject: [PATCH] Adding two helper functions and modify upgrade to work properly under MSSQL and Oracle. MDL-8303 Merged from MOODLE_17_STABLE --- question/type/numerical/db/upgrade.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/question/type/numerical/db/upgrade.php b/question/type/numerical/db/upgrade.php index 05dab091e1..d01a86e1a4 100644 --- a/question/type/numerical/db/upgrade.php +++ b/question/type/numerical/db/upgrade.php @@ -27,7 +27,7 @@ function xmldb_qtype_numerical_upgrade($oldversion=0) { // from the empty string to *, to be like short answer questions. if ($result && $oldversion < 2006121500) { $result = set_field_select('question_answers', 'answer', '*', - "answer = '' AND question IN (SELECT id FROM {$CFG->prefix}question WHERE qtype = '" . NUMERICAL . "')"); + sql_compare_text('answer') . " = '" . sql_empty() . "' AND question IN (SELECT id FROM {$CFG->prefix}question WHERE qtype = '" . NUMERICAL . "')"); } return $result; -- 2.39.5