Update of /cvsroot/mailmanager/mailmanager/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7190/sql
Modified Files:
editTicket.zsql
Log Message:
Now have some mangling to protect variables from the evils of acquisition
Index: editTicket.zsql
===================================================================
RCS file: /cvsroot/mailmanager/mailmanager/sql/editTicket.zsql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- editTicket.zsql 22 Sep 2005 12:30:24 -0000 1.8
+++ editTicket.zsql 28 Sep 2005 15:37:46 -0000 1.9
@@ -2,7 +2,7 @@
title:Edit a Ticket
connection_id: mailmanager_db
max_rows:0
-arguments:id subject assigned status priority category0 category1 category2 support_of set_date_closed clear_date_closed date_opened respond_by date_responded date_closed
+arguments:id subject assigned status priority category0 category1 category2 support_of set_date_closed clear_date_closed debug_date_opened debug_respond_by debug_date_responded debug_date_closed
The initial assignment of id = id purely exists so that the commas separating
each sql variable can be added in a clean fashion. It is purely a dummy
@@ -15,17 +15,17 @@
UPDATE <dtml-var schema>mm_ticket
SET id = id
- <dtml-if "REQUEST.has_key('date_responded')">
- , date_responded=<dtml-sqlvar date_responded type="string">
+ <dtml-if debug_date_responded>
+ , date_responded=<dtml-sqlvar debug_date_responded type="string">
</dtml-if>
- <dtml-if "REQUEST.has_key('date_closed')">
- , date_closed=<dtml-sqlvar date_closed type="string">
+ <dtml-if debug_date_closed>
+ , date_closed=<dtml-sqlvar debug_date_closed type="string">
</dtml-if>
- <dtml-if "REQUEST.has_key('date_opened')">
- , date_opened=<dtml-sqlvar date_opened type="string">
+ <dtml-if debug_date_opened>
+ , date_opened=<dtml-sqlvar debug_date_opened type="string">
</dtml-if>
- <dtml-if respond_by>
- , respond_by=<dtml-sqlvar respond_by type="string">
+ <dtml-if debug_respond_by>
+ , respond_by=<dtml-sqlvar debug_respond_by type="string">
</dtml-if>
<dtml-if set_date_closed>
, date_closed=CURRENT_TIMESTAMP
|