- Zope - Zope lists

Zope2 and ZSybaseDA problem
by Chad McDaniel 26 Aug '99

26 Aug '99

Did something change with how the new ZSybaseDA handles the results from a Sybase stored procedure? I noticed that with the 'Test' tab on the ZSQL Method that the results are quite different with Zope2. Zope1 just returned the simple key/value results. Zope2 returns keys called: Query, Status, and Calls. With the results hidden in Status. Is there a way to get the old behavior? thanks -- -chad

2 1

Re: [Zope] DTML syntax
by Kevin Dangoor 26 Aug '99

26 Aug '99

-----Original Message----- From: Tim Wilson <wilson(a)chemsun.chem.umn.edu> To: Paul Everitt <Paul(a)digicool.com> Cc: Zope Listserv <zope(a)zope.org> Date: Wednesday, August 25, 1999 7:56 PM Subject: RE: [Zope] DTML syntax >Thanks Paul. I was making it way too hard. Here's another Zope style >question. From a long-term site maintenance perspective, would it be >better to create my PDF file objects in scattered directories, or should I >create a /download folder with some hierarchical storage system there? >Perhaps the question is too abstract. > >I'd like to create some sort of navigation tree that would allow someone >to download any of the available PDFs from one central page in addition to >the links that I'm provding in the sub-folders dedicated to each of our >curriculum units. (See >http://206.131.108.122:8080/atlas/curriculum/particle/ for an example.) >Are there any special issues to consider in this case as I decide where in >the ZODB to store my PDFs? If it works better for you, you can store the PDFs in the same area as other related content. If you want to make a central PDF download page, you could then set up ZCatalog to index the property "content_type", and do a Find to catalog the objects. Then, your download page just needs to search the catalog for content_type: application/pdf (or whatever the type is). It could be as simple as: <dtml-in "Catalog({'metatype': 'File', 'content_type': 'application/pdf'})"> <a href="/<dtml-var "getpath(data_record_id_)">/index.html"><dtml-var title></a> </dtml-in> Kevin

3 3

ZClass tutorial?
by Tim Wilson 26 Aug '99

26 Aug '99

Hi everyone, I'm searching for docs on ZClasses. Are there any to be found? Searches at the new Zope site don't come up with anything. Specifically, I'm wondering if a ZClass would be of use in my situation. I'd like to create a form where the teachers in the science dept. would enter the topics they covered, assignments they gave, etc. for a particular course on a certain day and in a given period. Then, when students miss school for any number of perfectly good reasons (grumble...), they could go to a different form and view and/or print the assignments they missed. Would a ZClass fit in here somewhere? My initial thinking was to use MySQL to store the assignments, simple SQL queries to get the data, and a ZCatalog to provide searching capability. (Wait a minute...will ZCatalog catalog an external DB?) I don't know enough about ZClasses yet to know where to use them. -Tim -- Timothy Wilson | "The faster you | Check out: Henry Sibley H.S. | go, the shorter | http://slashdot.org/ W. St. Paul, MN, USA | you are." | http://linux.com/ wilson(a)chem.umn.edu | -Einstein | http://www.mn-linux.org/

1 0

Patch for Zope 2.0.0b5 - fixes Squishdot postings
by Elliot Lee 26 Aug '99

26 Aug '99

Without this patch, Zope seems to create FileUpload objects for fields that shouldn't have them. (I'm using lynx 2.8.1 from RHL 6.0 as my browser - I think it is sending the content-type for the fields as 'text/plain; charset=iso-8859-1'). I don't claim that this is the right solution, just that it solves my specific problem and may be helpful in tracking down the final solution. --- Zope-2.0.0b5-src/lib/python/ZPublisher/HTTPRequest.py Tue Aug 17 14:51:39 1999 +++ /usr/local/www/Zope/lib/python/ZPublisher/HTTPRequest.py Wed Aug 25 18:20:12 1999 @@ -317,9 +317,7 @@ if (hasattr(item,'file') and hasattr(item,'filename') and hasattr(item,'headers')): if (item.file and - (item.filename is not None or - 'content-type' in map(lower, - item.headers.keys()))): + (item.filename is not None)): item=FileUpload(item) else: item=item.value Hope this helps, -- Elliot Who me? I just wander from room to room.

2 1

Zope vs Servlet-EJB
by steve＠hosys.com 26 Aug '99

26 Aug '99

Hello, How is Zope architecture different/similar to a servlet communicating rmi to an EJB container ? thanks, Steve

2 1

Zope Zen needed
by Jody Winston 26 Aug '99

26 Aug '99

I need some help with the Zen of Zope and SQL. I've tried several different approaches and I have not been happy with either result. The goal of this Zope project is to allow individuals with different roles (e.g. views) to perform queries of objects in a database. These queries will run from simple queries, such as how many times a company has used a service, to complex queries to build final reports. Zope was selected over a report generating product since Zope provides security, a web based management system, different ways to submit and to retrieve data, and Zope didn't tie us to a single, closed, data source. The first approach was to have the most frequently used queries for each role stored along with some code to render them. This was too static and inflexible for the "power" users. The advantages were that the data was always insync with the SQL database since it was always generate from the database and that we knew how long the queries would take. The next approach was to used the primary keys in the table to generate trees of the data. This approach allowed quick navigation and retrieval of the data. The disadvantage was that selecting the data by it's primary key does not allow us to select data that the role was interested in. The third approach was to build ZClasses that had the same attributes as a row of the data in a given table. The attributes of a given instance were then populated from the results of an ad-hoc query. The GUI for querying the data was changed to be a form with multiple selection fields for every attribute in the class. ZClasses allowed the results of the queries to be stored in ZODB. The traversal of the results, a tree, can then be traversed and examined with the normal Zope mechanisms. This feature comes at the cost that the results of the queries will become out of sync with the database. The ad-hoc queries from this approach will not be as fast as optimized queries. I'm starting to lean towards a hybrid approach of canned queries for the 80% solution with forms for the other 20%. What's the general thoughts on this approach? Will the use of the ZClasses help when the underlying data is in a SQL database? Another issue is disconnected access from the main database/Zope server. A portion of the data from the database, either from ZODB or the SQL database, needs to be replicated from the server to the client at the client's request. The client then will become a its own server until the client reconnects with the main database/Zope server. Currently, we do not need to rectify the differences between the two Zope instances, but I can see that day coming. Any ideas on how to support this need with Zope? Jody Winston

2 1

Re: [Zope] Re: [Zope-dev] PROPOSAL: html_quote implicit in entity-reference var tagsyntaxsyntax
by Kevin Dangoor 26 Aug '99

26 Aug '99

-----Original Message----- From: Mauricio <mauricio(a)hiper.com.br> To: ZOPE <zope(a)zope.org> Date: Wednesday, August 25, 1999 8:11 PM Subject: [Zope] Re: [Zope-dev] PROPOSAL: html_quote implicit in entity-reference var tagsyntaxsyntax >Or, we can create a new sintax like: >&dtml-name#html_quote; >equivalent to: > I think this syntax somewhat eliminates the "shorthand" style of &dtml-name; Typing &dtml-name; is nicer than <dtml-var name html_quote> Typing &dtml-name#html_quote; is not much different than <dtml-var name html_quote>, IMHO Kevin

2 1

RE: [Zope] DTML syntax
by Paul Everitt 26 Aug '99

26 Aug '99

Tim wrote: > 1. How do the options of storing these PDFs in the ZODB > compare to keeping > them separately where people can use my ftp server to get > them? I think > there will initially be < 20MB of files. Good question. First, you gain the benefits of being an object vs. a file: o Security settings o Undo if you make a mistake o Attach logic - Create a DTML wrapper for the file that checks to see if someone came from the correct referrer - Increment a property on the file to count the number of times it has been viewed I could go on... :^) > 2. What DTML syntax would I use to create a link to this PDF > file so it > can be downloaded? I've tried some different things, but none work. Hmm, <a href="somefile.pdf">My pdf file</a> should work, no? > BTW, if some of you other newbies (or cagey veterans for that matter) > would like to see an example of a pretty basic site that's built with > Zope, feel free to have a look at mine. It's at > http://206.131.108.122:8080/atlas/ > > This is very much a work in process. The only section that is > approaching > completion is "Curriculum." Let me know if you have > suggestions or ideas. > I'd love to hear them. My first impression -- I like the look! --Paul

3 2

FYI: Zope Weekly News
by Pam Crosby 25 Aug '99

25 Aug '99

Hello, We had several discussions on the mailing list as to the gender of Zope. It's an 'it'. For a relatively quiet, vacation week, we had another beta release, some HowTo's and two announcements. CNET mentioned Zope favorably in Dan Shafer article about Python. Also, Linux Today mention the same article. http://buzz.builder.com/cgi-bin/WebX?14@101.PwqganhkenJ^0@.ee7bc67/0 http://linuxtoday.com/stories/9043.html Zope 2.0.0b5 release now available. History of fixes available on line and in the installation documentation. http://www.zope.org/Download/Releases/Zope-2.0.0b5 Paolo Bizzarri has made available version 0.1 of the SQLPackage online. Documentation is included in the email. http://www.zope.org/pipermail/zope/1999-August/008638.html Alexander Staubo has announced Redirector 1.0. Redirector is an experimental folder product for redirecting object requests. http://www.zope.org/pipermail/zope/1999-August/008755.html The O'Reilly conference went exceedingly well. A review of the tutorial Paul Everitt delivered: http://legacydiscuss.userland.com/msgReader$9785 Andreas Kostyrka offered a HowTo to change a DTML method into a document or the other way. http://www.zope.org/pipermail/zope/1999-August/008791.html A mailing list strictly for the purposes of discussing E-Commerce solutions using Zope has been established. It's called ZCommerce. Anyone who is interested in subscribing can either go to http://lists.codeit.com/mailman/listinfo/zcommerce to subscribe, or email zcommerce-request(a)codeit.com with 'subscribe' as the subject to be added to the list. Until next week, Amos will be back! -- Pamela Crosby Technical Writer mailto:pam@digicool.com Digital Creations http://www.digicool.com

1 0

Re: [Zope] DTML syntax
by Kevin Dangoor 25 Aug '99

25 Aug '99

-----Original Message----- From: Tim Wilson <wilson(a)chemsun.chem.umn.edu> To: Zope Listserv <zope(a)zope.org> Date: Wednesday, August 25, 1999 5:05 PM Subject: [Zope] DTML syntax >Hi everyone, > >I can't find the answer to this anywhere. > >I've added a file object to my ZODB. The file is a PDF file that I'd like >to make available for download. A couple questions: > >1. How do the options of storing these PDFs in the ZODB compare to keeping >them separately where people can use my ftp server to get them? I think >there will initially be < 20MB of files. It's probably less headache for you to keep them in the ZODB... and you could make the links appear automatically if the docs are there... >2. What DTML syntax would I use to create a link to this PDF file so it >can be downloaded? I've tried some different things, but none work. You should be able to just use the url of the object. To come up with this programmatically, you could do: <a href="<dtml-var "fileob.absolute_url()">">Download the PDF</a> Kevin

1 0