diff options
| -rw-r--r-- | ChangeLog | 4 | ||||
| -rw-r--r-- | src/odbc/odbc_queries.erl | 4 |
2 files changed, 6 insertions, 2 deletions
@@ -1,5 +1,9 @@ 2008-10-03 Jerome Sautret <jerome.sautret@process-one.net> + * src/odbc/odbc_queries.erl: Fix empty query that fail on MySQL. + +2008-10-03 Jerome Sautret <jerome.sautret@process-one.net> + * src/mod_vcard_odbc: added vCard support for MS SQL Server 2005. * src/odbc/odbc_queries.erl: likewise. * src/odbc/mssql2005.sql: likewise. diff --git a/src/odbc/odbc_queries.erl b/src/odbc/odbc_queries.erl index b3248dfa2..c9f6819be 100644 --- a/src/odbc/odbc_queries.erl +++ b/src/odbc/odbc_queries.erl @@ -329,11 +329,11 @@ update_roster_sql(Username, SJID, ItemVals, ItemGroups) -> " values (", ItemVals, ");"], ["delete from rostergroups " " where username='", Username, "' " - " and jid='", SJID, "';"], + " and jid='", SJID, "';"]] ++ [["insert into rostergroups(" " username, jid, grp) " " values (", ItemGroup, ");"] || - ItemGroup <- ItemGroups]]. + ItemGroup <- ItemGroups]. roster_subscribe(_LServer, Username, SJID, ItemVals) -> ejabberd_odbc:sql_query_t( |