[Nmailserver-commits] SF.net SVN: nmailserver: [141] NMail/trunk/NMail.LocalStoreData.MySql/ MySqlLocalStoreData.cs

[<tmy...@us...>]

Revision: 141
          http://svn.sourceforge.net/nmailserver/?rev=141&view=rev
Author:   tmyroadctfig
Date:     2007-02-09 20:00:15 -0800 (Fri, 09 Feb 2007)

Log Message:
-----------
Fixed a defect in the handling of message flags.

Modified Paths:
--------------
    NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStoreData.cs

Modified: NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStoreData.cs
===================================================================
--- NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStoreData.cs	2007-02-10 03:58:53 UTC (rev 140)
+++ NMail/trunk/NMail.LocalStoreData.MySql/MySqlLocalStoreData.cs	2007-02-10 04:00:15 UTC (rev 141)
@@ -780,7 +780,7 @@
 
 				MySqlCommand cmd = cnn.CreateCommand();
 				cmd.Transaction = transaction;
-				cmd.CommandText = "SELECT FolderMessageId FROM Message WHERE FolderId = ?FolderId AND MessageFlags = ?DeletedFlag";
+				cmd.CommandText = "SELECT FolderMessageId FROM Message WHERE FolderId = ?FolderId AND ((MessageFlags & ?DeletedFlag) != 0)";
 				cmd.Parameters.Add("?FolderId", folder.FolderId);
 				cmd.Parameters.Add("?DeletedFlag", (int) StoreMessageFlags.Deleted);
 				


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.