- Zope - Zope lists

ODBC Bridge / SQL Server stuff
by Phill Hugo 25 Aug '00

25 Aug '00

Hello, Easysoft (www.easysoft.com) supply a simple, efficient SQL bridge which works well with unixODBC (.org) and iodbc (.org) driver managers. We use it on one of our PHP sites to link to an SQL Server db from Linux. It works fine but its a close product. So given the easy of use of XML-RPC or SOAP from Python, it may be sufficient to create your own bridge which calls a remote DB connection made with ASP or Zope on NT. I've set this up with a Python method calling a remote DB connection in PHP using XML-RPC (just pass the query over and get the records back) and it works perfectly. Hope this helps. Phill

1 0

Small Tip
by Maik Roeder 25 Aug '00

25 Aug '00

Hi ! It always got on my nerves that I needed to change the column size of the DTML Method and DTML Document Edit Forms manually by pressing "Wider" and "Narrower". Instead of patching the Zope source code, I found the following a good approach: Define a property in your root folder: id: dtpref_cols type: int value: 80 The magic of acquisition does all the rest ;-) Greetings, Maik Röder -- "The computing future is based on "cyberbodies" - self-contained, neatly-ordered, beautifully-laid-out collections of information, like immaculate giant gardens." The second coming - A manifesto. David Gelernter http://www.edge.org/3rd_culture/gelernter/gelernter_p1.html

3 2

Microsoft SQL Server Access under Linux?
by Darin Lee 25 Aug '00

25 Aug '00

Zopistas, Is it possible to access an ODBC data source through Zope running under Linux? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment. I would very much like to setup ZAP (for many reasons), but our "organizational standard" is MS SQL Server 6.5. Thanks, -Darin Lee Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm(a)state.mi.us Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm(a)state.mi.us

4 3

ZClass and Custom Personal Zclass included
by Vincent 25 Aug '00

25 Aug '00

Hi, I created a ZClass named 'Z1' and another one classed 'Z2', I defined a Property Sheet 'P1' into Z2, how is it possible to declared a property inside P1 of the type Z1 ? Thanks

1 0

ZMenu 0.0.2 product
by Hugo Ramos 25 Aug '00

25 Aug '00

Yellow ppl, ZMenu is a complete navigational system that uses a tree like display. It allows you to dinamicly add a navigational link menus system to your site. This ZClass based product is still in a development stage and I'dd like to have some feedback about it... so email me about any problems or sugestions. You can download it here (there is also a pic): http://www.zope.org/Members/hramos/products/ZMenu ===== Hugo Ramos - hugo(a)zopers.org ZopersORG - http://www.zopers.org ===== Do not meddle in the affairs of programmers, for they are easy to annoy, and have all the source code!!!

7 9

RE: [Zope] Where do I find out about cookies?
by Jean Jordaan 25 Aug '00

25 Aug '00

Hi Loren, J. Atwood, Maik Thanks for all the info! I'll digest & give feedback where I can. In the meantime, this is what I've fixed up for myself (with a LOT of help from Roche Compaan) .. In DTML Document 'index_html':: <dtml-var docsSorted> In DTML Method 'docsSorted':: <dtml-if "REQUEST.form.has_key('sort_key')"> <dtml-call "REQUEST.set('sort_key', REQUEST.form['sort_key'])"> <dtml-call "RESPONSE.setCookie('sort_key', REQUEST.form['sort_key'])"> <dtml-else> <dtml-if "REQUEST.cookies.has_key('sort_key')"> <dtml-call "REQUEST.set('sort_key', REQUEST.cookies['sort_key'])"> <dtml-else> <dtml-call "RESPONSE.setCookie('sort_key', 'title')"> <dtml-call "REQUEST.set('sort_key', 'title')"> </dtml-if "REQUEST.cookies.has_key['sort_key']"> </dtml-if "REQUEST.form.has_key('sort_key')"> <table border="1"> <tr> <th> <a href="<dtml-var id>?sort_key=title">Title</a> </th> <th> <a href="<dtml-var id>?sort_key=origin">Origin</a> </th> <th> <a href="<dtml-var id>?sort_key=series">Series</a> </th> </tr> <dtml-if "sort_key=='title'"> <dtml-in "PARENTS[0].objectItems(['ccDocClass'])" size=10 start=qs sort=title> <tr> <td> <a href="<dtml-var id>"><dtml-var title></a> <dtml-if "AUTHENTICATED_USER.has_role('ContentManager')"> [<b><a href="<dtml-var id>/manage_workspace">Edit</a></b>] </dtml-if> </td> <td> <dtml-var origin> </td> <td> <dtml-var series> </td> </tr> </dtml-in> <dtml-elif "sort_key=='series'"> <dtml-in "PARENTS[0].objectItems(['ccDocClass'])" size=10 start=qs sort=series> <tr> <td> [... and so on for the other possibilities ...] The rationale is: 'docsSorted' is called as method by 'index_html'. - Upon the first iteration, there is no cookie and no form variable. A cookie and a form variable is set to 'title' as default. The form variable governs. - Upon subsequent iterations, if there is a form variable, then 'index_html' was called from 'docsSorted' and the sort-order has *just* changed. The cookie is changed (which will not be noticed during this iteration since it first has to be received again) and the form variable governs. - If there is a only a cookie and no form variable, it governs. Now I want to extend it so that choosing a sort-order for the *second* time reverses the order -- does this really entail repeating the entire '<dtml-if "sort_key=='title'">' section for '"order=='reverse'"'? I think I'm probably better off using the catalog for this, rather than dtml-in batching .. -- Jean Jordaan -- technical writer -- Mosaic Software -- Zope 2.1.6 on WinNT and W2K

2 1

ANN: External Methods and Products ebook
by Mark Pratt 25 Aug '00

25 Aug '00

hello all, Beehive is pleased to announce its 3rd ebook "External Methods and Products". If your thinking about developing Zope products or writing External Methods this 67 page ebook can save you several days of trial and error. Find out more about this and other beehive Zope ebooks via our website: http://www.beehive.de regards, mark -------------------------------------------------------------- mark pratt (managing director) mark(a)beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299

1 0

Imagemap in an image object
by Radim Gelner 25 Aug '00

25 Aug '00

Greetings, is there an easy way to add imagemapping to an image object or do I have to create a new class for such a purpous? Thank you Radim

3 3

Re: [Zope] strange login behaviour
by Didier Georgieff 25 Aug '00

25 Aug '00

I finally found the reason. I was redirecting with a property as URL. When i gave the url in *plain* text it worked OK. I still don't understand why. Thanks for the responses. Le 24 Aug 00, à 15:27, Chris Withers a écrit : > Is it possible that your browser is just caching the old page the first > time round? Le 24 Aug 00, à 22:15, Dieter Maurer a écrit : > I am not sure... > ... but it might be possible that the browser sets a cookie only > after the redirect. Didier georgieff.

1 0

ZClass Property : DTML Document ?
by Vincent 25 Aug '00

25 Aug '00

Dow do I create a ZClass Property of the type : DTML Document ? Thanks Vincent

2 1