- Zope - Zope lists

New releases of Zwiff and ZCVSMixin...
by Steve Spicklemire 23 Nov '00

23 Nov '00

For those who are paying attention.... ;-) there are new releases of Zwiff and ZCVSMixin at zope.org. There will be a new DumbZPatternsExample later today or tomorrow... The Zwiff release has been updated with the latest patches of ming and now has lots of working examples. You download the examples, and the source files (fonts, sounds, pics etc... ) for the examples separately. ZCVSMixin just has a minor bug fix about comments in CVS log files. DumbZPatternsExample now has three interacting Specialists and better separation of UI, Domain and Implementation stuff.... cheers, -steve

2 3

ZCatalog-weirdness again ??
by Geir B�kholt 23 Nov '00

23 Nov '00

i am having a bizarre problem with zcatalog (Zope2.2.2 win2k): I use Zcatalog for indexing a Zclass( todo-task, (catalogaware)) with a property named 'priority' (an integer between 1 and 10,- a field-index in the catalog) among others .. If i pass 'sort_on=priority' to the catalog-search, new instances of todo-task show up twice... if i leave the sort_on out, or also pass sort_order=reverse, everything works as expected.. Each instace shows up once. The instances are just listed once in the cataloged-objects-tab in my catalog. When i update my catalog manually, instances created before the update show up only once, but new instances (created after the update) still show up twice..(but still only if i pass 'sort_on=priority')..... Any ideas ? Anyone experienced anything like it ? -- Geir Bækholt web-developer/designer geirh(a)funcom.com http://www.funcom.com

1 0

Deleting files with URLs
by ListBot 23 Nov '00

23 Nov '00

Hello, I have the following method, having problems understanding how to get the "delete" link to work correctly. I get the following error: No items were specified! This is because there is no checkbox checked to pass on a file name? Is there another way to delete files by url? Thanks for helping a newbie. Regards, Sean <sean(a)scj.net> ------------------------ FileArchive/index_html: ------------------------ <p> <a href="upload_file">Add File</a> | <a href="upload_image">Add Image</a> <p> <hr> <table border="0" width="100%" cellspacing="5"> <tr><th valign="top" align="left"><u>Type</u></th><th valign="top" align="left"><u>Name</u></th><th valign="top" align="left"><u>Size</u></th><th valign="top" align="left"><u>Modified</u></th><th valign="top" align="left"><u>Info</u></th><th valign="top" align="left"><u>Actions</u></th></tr> <dtml-in expr="FileArchive.objectValues()"> <tr> <td valign="top" align="left">type</td> <td valign="top" align="left"><a href="<dtml-var absolute_url>"><dtml-var id></a></td> <td valign="top" align="left"><dtml-var getSize></td> <td valign="top" align="left"><dtml-var bobobase_modification_time></td> <td valign="top" align="left"><a href="<dtml-var absolute_url>/manage_workspace"><img border="0" src="images/info.gif"></a></td> <td valign="top" align="left"><a href="<dtml-var absolute_url>">Fetch</a> | <a href="delete_file">Delete</a></td> </tr> </dtml-in> </table> ----------------- delete_file: ----------------- <dtml-var expr="FileArchive.manage_delObjects()"> Your file <dtml-var id> has been deleted from the File Archives. <p> <a href="index_html">Return to File index<a/>

1 0

date in Z Gadfly Database
by Angietel 23 Nov '00

23 Nov '00

When i create a table, one of the fields is consider as date type, but the Z Gadfly Database does not allow me to do that, it only accepts INTEGER instead of DATE type. The following is my SQL for creating a table:- CREATE TABLE customer (custid VARCHAR(10), custname VARCHAR(15), custactdate DATE, custadd1 VARCHAR(30), custadd2 VARCHAR(30)) Please let me know if i got an error.Thank You.

1 0

neat trick
by magnus＠websys.no 23 Nov '00

23 Nov '00

Just wanted to share something that I thought was kind of neat (if obvious). I often present properties from a property sheet, and this is an easy way to do it: Assuming there are three fields in the property sheet, called field1, field2 and field3. <table> <tr><th>Name</th><th>Value</th></tr> <dtml-in "('field1', 'field2', 'field3')"> <dtml-if "_[_['sequence-item']]"> <tr> <td> <dtml-var "_['sequence-item']" capitalize> </td> <td> <dtml-var "_[_['sequence-item']]"> </td> </tr> </dtml-if> </dtml-in> </table> It will give you something like this: Name Value ------- ----- Field1 abc Field2 def Field3 ghi -Magnus

1 0

Re: [Zope] Question about security
by Tres Seaver 23 Nov '00

23 Nov '00

Harris Peter <PHarris(a)jimbeam.co.uk> wrote: > > I'm sorry, I must be missing something. > > The API reference I have doesn't contain any such thing. Neither does the > Zope book, before anyone else suggests that. The DTML on zope.org uses > a method that isn't recognised by the standard User Folder, so no help > there. > > If ANYONE has EVER successfully implemented a way for users to > change their own passwords using standard 2.2 Zope then *please* - > post your source code here or put a HOWTO on zope.org! > > It's a basic requirement of any system that uses passwords, but if it can't > be done just admit it. After all, zope is still *quite* good without it. ;-) See http://www.zope.org/Members/tseaver/user_settable_passwords. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

BUG: Nasty dtml-sendmail bug - Zope 2.2.4b1, Zope 2.1.6
by Dieter Maurer 22 Nov '00

22 Nov '00

Today, I spend 3 hours to analyse a nasty dtml-sendmail bug (Zope 2.1.6): Zope reported an SMTP exception: "recipient required" It turned out that the "messageText" that arrived in "Products.MailHost.MailHost.send" started with an empty line. Therefore, "decapitate" could not find the "To:", "From:" and "Subject:" headers and called "smtplib.send" with an empty "to" list. What really confused me: my DTML code did not show any sign, where this empty line should come from. Moreover, an identically locking DTML object worked as expected. Explanation: A collegue had edited the DTML object causing the problems with a *WINDOWS* editor and then uploaded the file. The Windows editor had added a Control-M after the "<dtml-sendmail mailhost=...>". This Control-M caused the spurious empty line. In the edit view, the browser did not show the Control-M. Therefore, the faulty and the correct DTML objects looked completely identical. I verified that the same bug is in Zope 2.2.4b1, too. Furthermore, the check for missing "To" and "From" is ineffective (as "extractHeader" always adds a "To" and "From" to header, just empty if it can not find the headers). I will put this into the collector. Dieter

1 0

RE: [Zope] Multiple ZODBC sources
by Capesius, Alan 22 Nov '00

22 Nov '00

Thanks All, I was hoping I had missed a clean way to do this. :) Access provides link tables, but what if I had two SQL servers? I thought (still thinking) about the Access link table solution, but I'm not sure I want the ODBC linking through Access to get to SQL. MS SQL Server also supports server links via Transact-SQL/XML. The dtml-in/dtml-with technique suggested by Chris Gray looks the promising. That will eliminate cross-product problems too. Probably the closest thing I'll find to a true join. So, after some digging and trying I found that you can access multiple Databases on the same SQL server by setting the ODBC driver up WITHOUT a default table and qualifying the database as such: select * from DBNAME..TABLENAME This method sacrifices the ability to browse for tables through this DSN, but this can be recovered by creating a secondary table-specific DSN for browsing purposes. ODBC also supports a configuration that allows SERVERNAME.DBNAME..TABLENAME configurations but I haven't been able (yet) to get that working through Zope. This would support direct links to multiple SQL servers. Since the ODBC DSN is part of the ZODBC configuration parameters, I expect that ZODBC cannot provide support for different source types at the ZSQL Method level. As far as writing a method to copy from one table to another, this would be OK in my case because I am using small databases on this app, but not for larger dbs. That would result in (2 + #_of_records) queries against the SQL in a realtime database. My app uses a static table (once a day update) for the Access side, so just moving/migrating this once a day to SQL may be the best bet. The SQL source is a third party package so I'd rather not put my table into their database just in case. (Avoid all that finger pointing later on). The copy table method along with the ZODBC solution above allows me to add a database to the server outside of the 3rd party's database and join tables via Zope ZSQL. >>>-----Original Message----- >>>From: Chris Gray [mailto:cpgray@library.uwaterloo.ca] >>>Sent: Wednesday, November 22, 2000 10:31 AM >>>To: Andrew Kenneth Milton >>>Cc: Capesius, Alan; zope(a)zope.org >>>Subject: Re: [Zope] Multiple ZODBC sources >>> >>> >>>I wonder if something like this would work: >>> >>><dtml-in selectFromTable1> >>> <dtml-in selectFromTable2> >>> <dtml-if idFromTable1 = idFromTable2> >>> ....display parts of the two records.... >>> </dtml-if> >>> </dtml-in> >>></dtml-in> >>> >>>Might be more efficient to make one of the dtml-ins a >>>dtml-with and find >>>the item with the matching id. >>>

1 0

Re: [Zope] Executing Z SQL Methods via a URL request
by Dieter Maurer 22 Nov '00

22 Nov '00

Please do *NOT* send HTML mails into this list! Nick McDowell writes: > I have a Z SQL method that requires an �id� value which it users to perform > a select statement. I am trying to pass this �id� value via a URL, which > calls a DTML method who in turn calls the Z SQL Method. When I remember right, someone introduced into Zope 2.1.6's Z SQL methods that acquisition is stronger than explicitely passed arguments (and arguments from REQUEST, this is your case). One says, it was for security reasons. I think, this is a big bug, and I will change it, whenever I should see it. If it is still in Zope 2.2, then you will have only 2 chances: 1. rename you argument to something that is not acquired (as 'id' is). In your SQL, you can of cause use the column name as it is defined by the table - similar to the following: .... where id = <dtml-sqlvar renamed_id type=string> .... 2. change the code in "Shared.DC.ZRDB.DA.__call__", as I would do. I did not yet work enough with Zope 2.2 to got hit by the bug (if it is still there). Therefore, I do not yet have a patch. Dieter

1 0

Re: [Zope] Speaking of Python Methods....
by Dieter Maurer 22 Nov '00

22 Nov '00

Steve Drees writes: > What's the PythonMethod equivalent of: > <dtml-with callTypes> > <dtml-var "_.getitem(_.str(2)).Name"> > </dtml-with> To get the object: getattr(callTypes,'2').Name then you must do something with it. "dtml-var" would render it. This means call it, if it is callable and convert to a string. The "callTypes" above may need to be replaced by "self.callTypes" or "context.callTypes", if "callTypes" is not yet in the functions namespace. Dieter

1 0