- Zope - Zope lists

left(string) equivalent
by joel grimes 16 Jun '00

16 Jun '00

I should have given a little more detail. I have an odbc connection and a zsqlmethod that work fine when the zsqlmethod says: select description, datein from san_jose But I just want the first 4 characters of the description field. So I've tried: select substring(description, 1, 4), datein from san_jose I've also tried substr(), and some variations. I even tried the Access version - left(description, 4). If it can't be done in the query, and I have to get the whole string in the sql method and slice it later, I can live with that, but then I have another problem: I let the wizard create a report for me and it gave me results that include: <tr> <td><dtml-var description null=""></td> <td><dtml-var datein null=""></td> </tr> works fine. so I changed "description" to "description[:4]" (no quotes, though). If I try to view the report I get an error. Error Type: KeyError Error Value: description[:4] Any ideas? Thanks ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

2 1

Virtual hosts: How to make proper intra-site URL's?
by rob＠hooft.net 16 Jun '00

16 Jun '00

I have set up a site: www.site In this site, there are a few virtual hosts: www.host1 --> www.site/Host1 www.host2 --> www.site/Host2 Thanks to a nice access rule, both the left and right names can be used to refer to the information. So far so good. In www.site/Host1 I have define a navigation bar dtml method to show some important check points in the host. Question: How do I make relative URLs in the navigation bar work so that they work under all circumstances. E.g. if I have a "People" Folder under "Host1" listed in the navigation bar, I'd like to see that the link shows up as follows: If I am looking at page: "People" should link to: http://www.host1/ People or http://www.host1/People http://www.host1/News ../People or http://www.host1/People http://www.site/Host1 People or http://www.site/Host1/People http://www.site/Host1/News ../People or http://www.site/Host1/People I have not been able to produce this effect using either BASE0..N or URL0..N. Help? Rob Hooft -- ===== rob(a)hooft.net http://www.hooft.net/people/rob/ ===== ===== R&D, Nonius BV, Delft http://www.nonius.nl/ ===== ===== PGPid 0xFA19277D ========================== Use Linux! =========

2 3

More DCOracle real examples...
by Juan Jose Garcia Garcia 16 Jun '00

16 Jun '00

Hello, I have installed DCOracle both in UNIX an Windows Systems and it is running ok... but.. Where can I get more DCOracle real examples ?? I need for example, trap Oracle errors via try/except etc,... Many thanks... -- --------------------------------------------------------------------- Juan Jose Garcia INFORMATICA EL CORTE INGLES S.A. Departamento de Desarrollo de Plataformas Sectoriales Laboratorio StoreFlow Avda. de Cantabria, 51 28042 - MADRID e-mail: jjgarcia(a)ieci.net Tfno: 91-329-82-00 Ext. 8341 Movil: 629-08-56-73 Fax: 91-329-54-59 ---------------------------------------------------------------------

1 0

Re: [Zope] Mozilla for mgmt
by Anthony Baxter 16 Jun '00

16 Jun '00

>>> Anthony Baxter wrote > > > Has anyone besides me had trouble using Mozilla to manage Zope ie access > > > the control panel via log in? > > There are regressions in recent Mozilla builds that prevent the authenticat oops. I forgot this other one that I found. Mozilla writes the username/password with a trailing null. I just logged it: http://bugzilla.mozilla.org/show_bug.cgi?id=42782 A patch that allows Zope to workaround this: diff -u -r1.110 User.py --- User.py 2000/06/05 15:31:43 1.110 +++ User.py 2000/06/16 06:26:32 @@ -439,6 +439,8 @@ if lower(auth[:6])!='basic ': return None name,password=tuple(split(decodestring(split(auth)[-1]), ':', 1)) + if password[-1] == '\000': + password = password[:-1] # Check for superuser super=self._super

1 0

Creating a FRAMESET
by Wayne Izatt 16 Jun '00

16 Jun '00

Maybe I'm going crazy, but I can't seem to get my FRAMESET to render. If I understand things correctly, the SRC of the html is the same as the ID. Or am I wrong? Should I completely qualify the SRC, or will Zope take care of this for me?... ciao

2 1

Re: [Zope] Difference between &dtml-myvar; and <dtml-var myvar>
by Hung Jung Lu 16 Jun '00

16 Jun '00

>From: andres(a)corrada.com >From the Using the DTML entity syntax How-To >(http://www.zope.org/Members/AlexR/EntitySyntax) : Very very cool. Thanks a lot! Hung Jung ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

sql and zope-2.2
by Bak ＠ kedai 16 Jun '00

16 Jun '00

hi all, i managed to upgrade my site from 2.1.6 to 2.2b1 with no problems (thanks Brian) but now, something else cropped up. what used to work on my 2.1.6 doesn't anymore. following are the sql snippets and tracebacks --show_subtree_index <dtml-in "qry_msg_thread(_.None,_,par_id=obj_id)"> <a class="root-msg" href="view_msg_html?obj_id=<dtml-var obj_id>" target="main"> - <dtml-var username></a> </dtml-in> --- my sqlmethod select * from msg where par_id=<dtml-sqlvar obj_id type=int> --- and the traceback --- Traceback (innermost last): File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/kdie/Zope-2.2.0b1-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 611, in renderwb (Object: qry_msgs_by_par_id(par_id=0)) File /home/kdie/Zope-2.2.0b1-src/lib/python/OFS/DTMLMethod.py, line 164, in __call__ (Object: show_subtree_index) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: show_subtree_index) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: qry_msg_thread(_.None,_,par_id=obj_id)) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_Util.py, line 339, in eval (Object: qry_msg_thread(_.None,_,par_id=obj_id)) (Info: qry_msg_thread) File <string>, line 0, in ? File /home/kdie/Zope-2.2.0b1-src/lib/python/Shared/DC/ZRDB/DA.py, line 444, in __call__ (Object: qry_msg_thread) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: <string>) File /home/kdie/Zope-2.2.0b1-src/lib/python/Shared/DC/ZRDB/sqlvar.py, line 168, in render (Object: obj_id) Missing Input: (see above) -- i tried encapsulating the dtml method with <dtml-with REQUEST> just in case, but still no go. any help appreciated -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

1 0

Difference between &dtml-myvar; and <dtml-var myvar>
by Hung Jung Lu 16 Jun '00

16 Jun '00

This has been something that I've never been very careful about. Until I got bitten in generating a JavaScript. What is the difference between <dtml-var myvar> and &dtml-myvar; ? I have noticed some differences before, but I don't remember the details, now. I guess one of them mangles the result so it can be looked at in a browser (properly HTML quoted?) <dtml-call "REQUEST.set('myvar', '&')"> <dtml-var myvar> &dtml-myvar; Visually they look the same, but if I looked at the source: & & Is the a technical term (e.g: "rendering", "HTML-quoting", etc.) that describes the difference in the output? regards, Hung Jung ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

2 1

neted dtml-in and ZSQL methods
by jpenny＠universal-fasteners.com 15 Jun '00

15 Jun '00

Suppose, you have a database, items, that has fields product and scheme. You are processing a form that has field old_product and new_product. You have a ZSQL method, get_scheme, with parameter old_product and body select * from items where product = <dtml-sqlvar old_product type=string>. You also have a ZSQL method, new_scheme, with parameter new_product and scheme. Observation: <dtml-in get_scheme> <dtml-call new_scheme> </dtml-in> fails, with message Zope Error Zope has encountered an error while publishing this resource. Error Type: NameError Error Value: scheme Troubleshooting Suggestions This resource may be trying to reference a nonexistent object or variable scheme. The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. even though <dtml-in get_scheme> <dtml-var "scheme"> </dtml-in> prints the expected value. Why? Jim Penny

1 0

left(string, n) equivalent (newbie q.)
by joel grimes 15 Jun '00

15 Jun '00

Pardon my ignorance, I'm coming from a VB/Access background. I need to find an equivalent to using left(string, 4) in a zope SQL method's select query. My SQL book says I can use SUBSTRING(string, 1, 4) in a query but no luck. I'm connecting to an Access database. btw - this mail list ROCKS! I've never waited more than 10 minutes for a response. Thanks ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

3 2