From: Andrew V. <av...@us...> - 2005-04-03 19:13:26
|
Update of /cvsroot/mailmanager/mailmanager/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21153 Added Files: Tag: db-backend deleteTickets.zsql Log Message: Added a method to delete tickets. --- NEW FILE: deleteTickets.zsql --- <dtml-comment> title:Delete Tickets connection_id:mailmanager_db arguments:account_id status category0 category1 category2 </dtml-comment> DELETE FROM <dtml-var schema>mm_ticket <dtml-sqlgroup where> <dtml-sqltest account_id type="nb" optional> <dtml-and> <dtml-sqltest status type="nb" optional> <dtml-and> <dtml-sqltest category0 type="nb" optional> <dtml-and> <dtml-sqltest category1 type="nb" optional> <dtml-and> <dtml-sqltest category2 type="nb" optional> </dtml-sqlgroup> |