- Zope - Zope lists

Re: Insert Help
by Todd Loomis 25 Feb '02

25 Feb '02

Dieter: Could you explain a little more I still seem to be trying to input everything all on one record. I need to break out in an array then each needs to be added to the database as a separate record. Maybe I missed something. Thanks, Todd Todd Loomis writes: > I want to insert to a database a id and a option, however each id can have > more than one option. And I want them inserted separately to make 2 records. > > The form will be checkboxes they check all the options they want and they > all get save in the database seperately but with the same id. I've tried to > no luck. Can anybody help? Some basic observations: ZSQL Method bodies are DTML objects. You use DTML there to generate SQL in the same way you use DTML usually to generate HTML. Especially, you have the "dtml-in" in order to iterate over sequences. A ZSQL Method can generate and execute several SQL commands. These commands need to be separated by "<dtml-var sql_delimiter>". Thus, you use something like: <dtml-in options> insert into ... <dtml-unless sequence-end><dtml-var sql_delimiter></dtml-unless> </dtml-in> You need to be a bit careful with your options in the form. It should probably contain something like: <input type="hidden" name="options:list" value="dummy"> ... <input type="checkbox" name="options:list" value="..."> ... The hidden variable ensures that you always get something for options. The ":list" ensures that the case of a single option leads to a list as well as multiple options. When you use the hidden variable approach as shown above, then your options list contains a bogus first element. You need to drop it again. The "dtml-in options" above becomes 'dtml-in expr="options[1:]"'. Dieter _______________________________________________ Zope maillist - Zope@z... 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 )

1 0

dtml-sqlgroup broken
by Andy Dustman 25 Feb '02

25 Feb '02

The following Z SQL Method used to work prior to 2.5.0, but now produces an error (2.5.1b1 included): Arguments: spam:int:optional SELECT spam, eggs, sausage FROM foo2 <dtml-sqlgroup where> <dtml-sqltest spam type="int" optional> </dtml-sqlgroup> Error Type: TypeError Error Value: unbound method __init__() must be called with instance as first argument Traceback (innermost last): File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/Shared/DC/ZRDB/DA.py, line 174, in manage_edit (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 350, in cook (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 179, in parse (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 246, in parse_block (Object: <string>) TypeError: (see above) Line numbers may be shifted slightly due to debugging code inserted. The line where the error occurs is: DEBUG and DLOG('parse_block: %s(%s)' % (`scommand`,`blocks`)) r=scommand(blocks) 2002-02-24T06:13:11 PROBLEM(100) DT DEBUG parse_block: <class Shared.DC.ZRDB.sqlgroup.SQLGroup at 0x8628afc>([('sqlgroup', 'where', <DocumentTemplate.DT_HTML.HTML instance at 0x89d999c>)]) I'd also like to draw attention to collector issues 6, 15, and 192... I particularly would like to see 15 implemented... If it will help, I'll put this in the collector as well. Basically, Z SQL Methods are nearly useless at this point. Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy You can have my keys when you pry them from my dead, cold neurons.

3 3

Re: [Zope] Zope and SSL
by Frank Tegtmeyer 25 Feb '02

25 Feb '02

"Thierry Florac" <thierry.florac(a)onf.fr> writes: > I'd like to let users access my Zope web site normally through HTTP, but > make my Zope management screens (in fact, any URL containing '/manage') > only available through HTTPS. We (still) don't use virtual host monster, but virtual site root instead (http://www.zope.org/Members/comlounge/vsr/) In Apache you can do something like this: RewriteRule ^.*/manage(_.*|())$ - [forbidden] Please be aware that there may be products that don't use the 'manage' convention. So this rule doesn't restrict all possible management screens. At the SSL server no special handling of management screens is necessary. Regards, Frank -- CTO fte(a)Lightwerk.com http://www.Lightwerk.com/ Fax: +49-2434-80 07 94 Phone: +49-2434-80 07 81 Lightwerk GmbH * An der Kull 11 * 41844 Wegberg * Germany Besuchen Sie uns auf der CeBIT: Halle 6, Stand F68 / 595

3 3

MASS IMPORT ?
by Zimmermann, Mark 25 Feb '02

25 Feb '02

Hi, i have a big problem. I must import many doc files (ms word). Can i put the files over FTP to ZOPE ? Can ZOPE convert them to HTML ? As result i need a DTML Document. My other question is: when i upload images over ftp the zope server gives them the name as id (id="mark.gif"). How could i tell zope to give the "title" property the same content.

2 1

Re: File Upload via python
by Wade Leftwich 25 Feb '02

25 Feb '02

Jonathan, what browser are you using? I have run into problems trying to use a context object with Internet Explorer 5.0, and I vaguely recall being unable to do a context.manage_addProduct from that browser. I didn't have time to explore, just used PARENTS[0] instead of context. -- Wade Leftwich Ithaca, NY On Saturday 23 February 2002 18:39, Dieter Maurer wrote: > Date: Sat, 23 Feb 2002 13:38:20 +0100 > From: Dieter Maurer <dieter(a)handshake.de> > Subject: Re: File Upload via python > > Jonathan Bryant writes: > > I've been playing around with Zope for several days and really like it. > I'm > amazed at how simple so many things that take alot of effort in php, > asp > etc. are amazingly simple in Zope. One of those things is file > upload,... > .... > > What I'd like to do is easily grab the filename: > > > > context.manage_addProduct['OFSP'].manage_addFile(item.filename, > item_title, > item) > This should work as you write it here. >

3 2

AW: [Zope] Problems with Object-IDs
by Breitenreicher, Marc 25 Feb '02

25 Feb '02

FYI: Found a solution!!!! I found out, that I have to render the variable like this: <dtml-var _.getitem('id',1)> *the 1 means 'render', 0 'don't render'* And so the variable shows the real id 'mydocument.html' > -----Ursprüngliche Nachricht----- > Von: Breitenreicher, Marc [SMTP:Marc.Breitenreicher@friatec.de] > Gesendet am: Montag, 25. Februar 2002 08:36 > An: 'zope(a)zope.org' > Betreff: [Zope] Problems with Object-IDs > > Hi Community, > > I've got a problem with finding out IDs of objects. > > What I want to do is this: > I want to search in a directory, if a special object-id is already used. > > The code is: > <dtml-in "objectItems(['DTML Document'])"> > <dtml-if "id=='mydocument.html' "> > and so on > > But the id I get here, is not the id as it is shown in the management-view > (for example 'mydocument.html'). > Here, the id is something like 'Python Method object at 0x841d1c8' > > > Can anyone tell me, how I can get the 'real' id 'mydocument.html'? > > Thank for your help in advance. > > Marc > > _______________________________________________ > Zope maillist - Zope(a)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 )

1 0

Thumbnail Overview ?
by Zimmermann, Mark 25 Feb '02

25 Feb '02

Hi, i need a DTML Document and don't know how to create it. I have a Image folder: pcms.image there are many subfolders inside example: pcms.image.logo pcms.image.diverses .... Now i need a DTML Document with the following functions: - Thumbnail Overview for all Images inside a specific folder - change the folder Is there some Document out there ? Sorry for my english ... i am from germany....

1 0

Problems with Object-IDs
by Breitenreicher, Marc 25 Feb '02

25 Feb '02

Hi Community, I've got a problem with finding out IDs of objects. What I want to do is this: I want to search in a directory, if a special object-id is already used. The code is: <dtml-in "objectItems(['DTML Document'])"> <dtml-if "id=='mydocument.html' "> and so on But the id I get here, is not the id as it is shown in the management-view (for example 'mydocument.html'). Here, the id is something like 'Python Method object at 0x841d1c8' Can anyone tell me, how I can get the 'real' id 'mydocument.html'? Thank for your help in advance. Marc

1 0

Zope 2.5.0
by Graham King 25 Feb '02

25 Feb '02

And another thing ot two..... Zope/ZSyncer seems to not find the images that normally display next to the type of Object you want to Sync. (eg, blue circle for CMF object, etc) Any clues? And then there's this Syncable meta types.... since we want to Sync any imaginable content of a Project, I suppose I should just select the whole lot? cheers Graham

1 0

Zsyncer 0.4.1 and Zope 2.5.0
by Graham King 25 Feb '02

25 Feb '02

Any clues, anyone? Just updated Zope to 2.5.0, because we noticed a number of crashes in our QA system. Now. today, we're trying to ZSync from devt to QA system,. and I get the following errors: (Note, simply copied the Data.fs file son each of these systems, so nothing internal should have changed....same users, passwords etc) Traceback (innermost last): File /home/Zope-2.5.0/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/Zope-2.5.0/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/Zope-2.5.0/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: QAZSync) File /home/Zope-2.5.0/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/Zope-2.5.0/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_approval) File /home/Zope-2.5.0/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_approval) File /home/Zope-2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: manage_approval) File /home/Zope-2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: manage_approval) File /home/Zope-2.5.0/lib/python/App/special_dtml.py, line 172, in _exec (Object: manage_approval) KeyError: (see above) cheers Graham

1 0