- Zope - Zope lists

Re: [Zope] Resolving nvarchar fields via ZmxODBCDA
by J�lio Dinis Silva 20 Mar '01

20 Mar '01

>It fails under ZmxODBC >the following example shows how to convert the nvarchar fields to char type >fields within an SQL query so that ZmxODBC can deal with them: > > >SELECT >table_catalog = CONVERT(char(30),table_catalog), >table_name = CONVERT(char(30),table_name), >column_name = CONVERT(char(30),column_name), >data_type = CONVERT(char(30),data_type) >FROM INFORMATION_SCHEMA.COLUMNS >where column_name like <dtml-sqlvar search_string type=string> >order by ordinal_position >The same technique should apply to other unsupported types. This works ok. But Meanwhile I've seen other problems: -There are problems also with TimeStamp/smalldatetime, and even a convert to char(x) still gives an InternalError. -And if a column returns null,i.e, the field is empty, then there is also an InternalError(I remember this null problem was mentioned in the past by the author of zmxodbc). Regards, Júlio Dinis _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

Zope on HP-UX?
by Farrell, Troy 20 Mar '01

20 Mar '01

Has anyone tried zope on HP-UX. I am nearing deployment of my application and IT has suggested a home on an HP server. I will have to try zope there, b

1 0

RE: [Zope] Getting Errors trying to map permissions in Zope 2.3.0 for win32
by Farrell, Troy 20 Mar '01

20 Mar '01

Anton, This is a known bug with Zope 2.3.0. To fix this bug, you will need to upgrade to 2.3.1b1 or 2.3.1b2 or the CVS version. Troy -----Original Message----- From: Anton A. Zotov [mailto:futurb@nh.km.ua] Sent: Monday, March 19, 2001 6:07 PM To: zope(a)zope.org Subject: [Zope] Getting Errors trying to map permissions in Zope 2.3.0 for win32 I'm getting permanent errors trying to map permissions in Zope product created by myself. I seem to do everything right. Could anybody tell me how to avoid the problem ? Please see Zope trace page attached. Thx in advance, Anton.

1 0

Oops, SiteRoot
by Rich Young 20 Mar '01

20 Mar '01

> Okay.... > So I've got these two boxes, one Win98 and one Linux (RH6.0, not > that it matters). Zope 2.3.0 on both. I've been playing with ZODBC, > MS-SQL Server, and Zope in hopes of getting data across the OS barrier to > the Linux box for web serving purposes. I have good database connectivity > from the windows box, and I was looking around for the way to create a > zope-to-zope connection to get ZSQL Methods from Windows into use on > Linux. I thought SiteRoot looked promising.... > But SiteRoot just made my linux zope a transparent interface to the > windows zope. Worse, I can't seem to undo it, and setting site root again > affects the windows zope, not the linux zope. This is a problem, because > I want the non-database-driven docs to come from the linux box (due to > load issues), not the windows box. > So I have two questions. First, how *do* you get win/zope ZSQL > Methods into linux/zope DTML docs? And second, is there any way (short of > un/re-installing) to reset Site Root on my linux box to be the default > instead of the windows machine? > > --Rich Young > rich at xplus dot com

2 1

Re: AW: [Zope] manage_clone - Pleeeease help !!!
by Dieter Maurer 20 Mar '01

20 Mar '01

Marc Fischer writes: > But I think I don't understand the syntax of Dtml/ Python! I never now what > syntax to use like ... _.[xxx] or _['xxx'] or ... or what ever. > > Perhabs someone could tell me where to start learning. It's really difficult > to understand !!!! I suggest, you look at the "Name lookup" section of URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

Re: [Zope] dtml login
by Dieter Maurer 20 Mar '01

20 Mar '01

David Kyte writes: > I want to create a DTML method/form that provides > a login for other areas of the site ie form > contains username/password text boxes and > then forwards to userfolder protected areas. > > I presume that some manipulation of REQUEST is required. You may have a look at Shane "CookieCrumber" product (--> zope.org) Dieter

1 0

Re: [Zope] PDF Files
by Dieter Maurer 20 Mar '01

20 Mar '01

Kenneth Ellested writes: > Can Zope (ZCatalog) index PDF files ? If you provide a method that extracts the text for the PDF.... Dieter

1 0

Re: [Zope] Strange ZCatalog behaviour
by Dieter Maurer 20 Mar '01

20 Mar '01

Ingo Wilmer writes: > I experience Problems using ZCatalog, > See following example: > <dtml-in "Catalog(meta_type=3D'ZClass_seite_press',region=3Dzregion)"> > where zregion is one string and region is a list indexd as text If "region" is a text index, the corresponding (indexed) value should be a string. I do not know (doubt it) that ZCatalog can index lists in a text index. > when i change this to =20 > <dtml-in "Catalog(meta_type=3D'ZClass_seite_press',region in zregion)"> > where zregion itself is a list, containing 3 or more strings that=20 > should match on some instances of ZClass_seite_presse i can't > even get this into zope, because i recive this error > > non-keyword arg after keyword arg That is clear: "in" is a Python operator. "region in zregion" evaluates to either 0 or 1. Thus, you call: "Catalog(meta_type='ZClass_seite_press',1)" Not what you want... And Python does it neither... Dieter

1 0

Re: [Zope] Render SQL method as lines
by Rich Young 20 Mar '01

20 Mar '01

Kenneth- How about <dtml-in getNames> <dtml-var name><dtml-var expr="_.chr(13)"><dtml-var expr="_.chr(10)"> </dtml-in> The expr="_.chr(#)" gives you the ASCII value corresponding to that number -- here, it's carriage return/line feed, which should return query results separated by lines --Rich > How do I render a SQL method as lines ? > > I'd like to make a DB lookup for a Multi-Selection property. > > This is my DTML method (getNames is a SQL method): > <dtml-in getNames> > <dtml-var name> > </dtml-in> > But this renders as a string which is not compatible... > Regards

2 1

Re: [Zope] Zope security management
by Dieter Maurer 20 Mar '01

20 Mar '01

Simon Michael writes: > I agree with John that this is a weakness in the current system. I > have often found myself wishing for something like tri-state > checkboxes (grant/deny/don't care). > > Would it be correct to say this is not a limitation of the zope > security model, but a user interface issue ? Yes, as you can already get what you want: When you uncheck the acquire checkbox, you can explicitly control (locally) which roles have the respective permission independant of any setting higher up in the hiararchy. Thus, your third state is not locally at each cell but sticks to a complete permission role. Dieter

8 9