Hi Gitte, time is on your side if you are with zope :) We brougt up a complete b2b e-commerce site with 3 not-even-python-knowers and one well-python-knower (me) We did not know anything about zope and it was with first betas of zope 2.0 :) 4 Months later the site was up :) Ok, you should get a little bit familar with the way the web works, what is sent by the browser and what in return from the server. A little page with <dtml-var REQUEST> is also very helpful for understanding. Please see the many examples how to work with ZSQL methods, how to explicitely pass parameters to them. The loop you got already so its all you need. Hint: Your zsql-method could look like: DELETE FROM TABLE blah WHERE ItemID=<dtml-sqlvar arg_ItemToDelete type=string> So you would call it inside your DTML-Method: <dtml-call expr="YourZSQLMethodToDeleteItems(arg_ItemToDelete=_['sequence-item'])"> (Note: the _['sequence-item'] expression is used to get from the namespace (_) the value for the name 'sequence-item'. Sequence-item runs from the beginning to end of your sequence (list, array) in the in-tag. NB: sequence-item is unhandy because its hypenation and its special meaning in python: hypenation is the minus-sign. You can expect a better solution to this soon) Alternatively: DELETE FROM TABLE blah WHERE ItmID in ('<dtml-var "_.string.join(arg_ItemSequence,_.chr(39)+','+_.chr(39))" sql_quote>') With the call: <dtml-call expr="YourZSQLMethodToDeleteAllAtOnce(arg_ItemSequence=ids)"> (in this case no in-tag is required) However, to understand the above examples please consult the various documents all around on python at first and zope in special. Remember: if you are really in trouble with the shedule and need to get things done, consider using professional help. There are now many companys and single persons here who would help you. (not me, I dont have the time ;) Regards Tino Gitte Wange wrote:
On 03 Apr 2001 11:55:57 +0200, Tino Wildenhain wrote:
Hi Gitte,
Gitte Wange wrote:
Well I'm sorry to say this, but it seems a bit more complicated than what I need. Isn't it possible to make an array out of a select box (with only the selected items in the array) and just run through this array to delete the items ?
Thats no way complicated. The "list" is the word python people use instead of "array" :-) If you note for your checkbox name a name and :list, zope automatically converts all selected entrys into a list containing the selected entrys. If you dont write :list, it does it anyway if there is more then one selected. To be save, use "ids:list" so the list is called ids. (refering to the example below)
As mentioned, you dont have to delete item by item if they are stored in Zope as objects. you only need to pass it to the manage_delObjects method of the folder:
<dtml-call expr="yourfolder_with_items.manage_delObjects(ids)">
(schould work. Untested)
If you have your items in a sql database, you may want to ilterate like this:
<dtml-in ids> <dtml-call expr="dosomethingtodelete(itemtodelete=_['sequence-item'])"> </dtml-in>
well I made the list: NAME="ids:list" in the checkbox line When you hit the deletebutton a method is called. The code for deletion is here: <dtml-in ids> <dtml-call sqlDeleteClips> <-- That's the sqlmethod </dtml-in>
What's funny is that I get an 400 error. And I have 3 hidden fiels in the same form - normally they would be passed as ActionList=1 etc. etc. but now they are passed as ActionList=['1', '1', '1', '1', '1', '1', '1', '1']
Yes I know I should learn some python but I'm working against time :-)
Gitte
Regards Tino
Gitte
On 02 Apr 2001 09:47:41 -0500, Farrell, Troy wrote:
I use a python script to do this all day :) Zope Coolness: You don't have to run through the array. Pass the array as a parameter to manage_delObjects. Remember to bind the namespace to _ The check boxes are listed as follows in a form that calls my script:
<dtml-in expr="objectValues()"> <li><input type="checkbox" name="ids:list" value="<dtml-var name="id">"<dtml-if name="checkall"> checked="checked"</dtml-if> /> <a href="&dtml-absolute_url;?ex=.log"><dtml-var name="title"></a></li> </dtml-in>
The Script:
## Script (Python) "manageLogFiles" ##bind container=container ##bind context=context ##bind namespace=_ ##bind script=script ##bind subpath=traverse_subpath ##parameters= ##title= ## if context.REQUEST.has_key('ids') and context.REQUEST.has_key('doThis'): if context.REQUEST.doThis == 'Delete these!': # Delete all selected LogFiles # note the .logs. in the command below context.logs.manage_delObjects(context.REQUEST.ids) context.REQUEST.RESPONSE.redirect(context.REQUEST.SourceURL)
else : # I don't know what to do raise KeyError
else: # Do this if they didn't check any of the boxes # I used to raise a KeyError, but that is stupid # Nobody wants a computer to tell them that they pushed # a button at the wrong time. Now, we essentially do # nothing, but send them back to where they came from. # raise KeyError context.REQUEST.RESPONSE.redirect(context.REQUEST.SourceURL)
Troy
-----Original Message----- From: Gitte Wange [mailto:gitte@babytux.dk] Sent: Monday, April 02, 2001 6:05 AM To: zope@zope.org Subject: [Zope] Delete multiple posts
Hello,
I have a list of items where it should be possible to delete all the items you wish. Each item have a checkbox with the value equal to them itemid.
I have done this is PHP just by naming these checkboxes "deletearr[]" to make an array, then run through the array an delete each item. But how do I do the same thing in Zope ?
Or - a more specifik question - can I make an array the same way in Zope that I did in PHP ?
Regards, -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )