aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--ChangeLog5
-rw-r--r--src/odbc/odbc_queries.erl5
2 files changed, 10 insertions, 0 deletions
diff --git a/ChangeLog b/ChangeLog
index 6258962ab..39f7c5673 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,8 @@
+2007-06-18 Mickael Remond <mickael.remond@process-one.net>
+
+ * src/odbc/odbc_queries.erl: Added missing users_number/1 for MSSQL
+ (EJAB-239).
+
2007-06-12 Alexey Shchepin <alexey@sevcom.net>
* src/mod_roster_odbc.erl: Fixed typo
diff --git a/src/odbc/odbc_queries.erl b/src/odbc/odbc_queries.erl
index 614e1d6ec..343405b26 100644
--- a/src/odbc/odbc_queries.erl
+++ b/src/odbc/odbc_queries.erl
@@ -381,6 +381,11 @@ list_users(LServer) ->
LServer,
"EXECUTE dbo.list_users").
+users_number(LServer) ->
+ ejabberd_odbc:sql_query(
+ LServer,
+ "select count(*) from users with (nolock)").
+
add_spool_sql(Username, XML) ->
["EXECUTE dbo.add_spool '", Username, "' , '",XML,"'"].