# HG changeset patch
# User casties
# Date 1372697842 -7200
# Node ID 6d6076e28430a4fd18bb3d5bff4f452d00854176
# Parent  938add25f81b435684bd191ce6aa51b0d3f4324d
fix deleteField for additionalLink (still ugly though)

diff -r 938add25f81b -r 6d6076e28430 MPIWGStaff.py
--- a/MPIWGStaff.py	Mon Jul 01 12:59:10 2013 +0200
+++ b/MPIWGStaff.py	Mon Jul 01 18:57:22 2013 +0200
@@ -476,7 +476,7 @@
 
 
     def getAdditionalLinks(self):        
-        return self.folder.executeZSQL("SELECT oid,* FROM additionalLink  WHERE  key_main = %s ORDER BY priority",[self.content.key]) 
+        return self.folder.executeZSQL("SELECT oid,* FROM additionallink  WHERE  key_main = %s ORDER BY priority",[self.content.key]) 
 
     
     def getPathStyle(self, path, selected, style=""):
@@ -751,14 +751,11 @@
 
             
 
-    security.declareProtected('View management screens','deleteField') 
-   
+    security.declareProtected('View management screens','deleteField')    
     def deleteField(self,REQUEST):
         """delete entry"""
-        
-        CHANGEABLE=['talks','taching','pubmanbiblio']
-        
-        
+        # TODO: this is ugly
+        CHANGEABLE=['talks','teaching','pubmanbiblio','additionallink']
         
         table = REQUEST.form.get('table',None);
         oid = REQUEST.form.get('oid',None);
@@ -772,9 +769,9 @@
         if table is None or oid is None:
             return
         
-        query="DELETE FROM %s WHERE oid = '%s'"%(table,oid)
-
-        self.executeZSQL(query)
+        query="DELETE FROM %s WHERE oid = %%s"%(table)
+        self.executeZSQL(query, [oid])
+        
         REQUEST.response.redirect(self.REQUEST['HTTP_REFERER'])
  
    
diff -r 938add25f81b -r 6d6076e28430 zpt/staff/edit_additionalLinks.zpt
--- a/zpt/staff/edit_additionalLinks.zpt	Mon Jul 01 12:59:10 2013 +0200
+++ b/zpt/staff/edit_additionalLinks.zpt	Mon Jul 01 18:57:22 2013 +0200
@@ -13,7 +13,7 @@
     <input type="hidden" name="main_fields" value="additionalLink__title">
     <table tal:define="links python:here.getAdditionalLinks()">
     <tal:x tal:repeat="link links">
-    <tr class="fliesstext">
+    <tr>
       <td>Text over Link</td>
       <td><input tal:attributes="name python:'additionalLink__title__'+str(link.oid); 
 				     value python:link.title" size="80" /> </td>
@@ -32,7 +32,7 @@
         <span tal:define="name string:additionalLink__published__${link/oid}; value link/published;">
           <tal:block metal:use-macro="here/common_template/macros/yesno_input_radio"/>
         </span>
-      &nbsp;&nbsp;<a tal:attributes="href string:$root/deleteField?table=additionalLink&oid=${link/oid}">delete this link</a>
+      &nbsp;&nbsp;<a tal:attributes="href string:$root/deleteField?table=additionallink&oid=${link/oid}">delete this link</a>
       </td>
     </tr>
     <tr>