From 7614f4f3274042f5bebcbc930e7d48479ce0c321 Mon Sep 17 00:00:00 2001 From: jerome mouneyrac Date: Wed, 13 Jan 2010 11:09:31 +0000 Subject: [PATCH] webservice MDL-20805 readd the ORDER BY varchar (cross-db) --- admin/webservice/forms.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/admin/webservice/forms.php b/admin/webservice/forms.php index 12795a1c68..e763b3e07d 100644 --- a/admin/webservice/forms.php +++ b/admin/webservice/forms.php @@ -146,7 +146,8 @@ class web_service_token_form extends moodleform { FROM {user} user WHERE user.id NOT IN ( SELECT adminuser.id FROM {user} adminuser, {role_assignments} rassign - WHERE rassign.roleid = 1 AND rassign.userid = adminuser.id)"; + WHERE rassign.roleid = 1 AND rassign.userid = adminuser.id) + ORDER BY user.lastname"; $users = $DB->get_records_sql($sql,array()); $options = array(); foreach ($users as $userid => $user) { -- 2.39.5