mailmanager/sql listMessages.zsql,1.1.2.4,1.1.2.5

[Andrew V. <av...@us...>]

Update of /cvsroot/mailmanager/mailmanager/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19578/sql

Modified Files:
      Tag: db-backend
	listMessages.zsql 
Log Message:
Assignment engine now works properly.


Index: listMessages.zsql
===================================================================
RCS file: /cvsroot/mailmanager/mailmanager/sql/Attic/listMessages.zsql,v
retrieving revision 1.1.2.4
retrieving revision 1.1.2.5
diff -u -d -r1.1.2.4 -r1.1.2.5
--- listMessages.zsql	26 Mar 2005 21:22:56 -0000	1.1.2.4
+++ listMessages.zsql	28 Mar 2005 20:21:16 -0000	1.1.2.5
@@ -1,10 +1,12 @@
 <dtml-comment>
 title:List Messages
 connection_id:mailmanager_db
-arguments:ticket_id
+arguments:ticket_id message_id
 </dtml-comment>
 SELECT * FROM mm_message
 <dtml-sqlgroup where>
   <dtml-sqltest ticket_id type="int" optional>
+<dtml-and>
+  <dtml-sqltest message_id type="string" optional>
 </dtml-sqlgroup>
 ORDER BY id