aboutsummaryrefslogtreecommitdiff
path: root/src/odbc/odbc_queries.erl
diff options
context:
space:
mode:
authorMickaël Rémond <mickael.remond@process-one.net>2007-06-18 10:22:54 +0000
committerMickaël Rémond <mickael.remond@process-one.net>2007-06-18 10:22:54 +0000
commitd2dd6eef09057b11c278d0253b96857460f2dd44 (patch)
tree6270a998287e48931ed8446486961e68e94a734c /src/odbc/odbc_queries.erl
parent* src/mod_roster_odbc.erl: Fixed typo (diff)
* src/odbc/odbc_queries.erl: Added missing users_number/1 for MSSQL (EJAB-239).
SVN Revision: 785
Diffstat (limited to 'src/odbc/odbc_queries.erl')
-rw-r--r--src/odbc/odbc_queries.erl5
1 files changed, 5 insertions, 0 deletions
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,"'"].