- Zope - Zope lists

RE: MSSQL7 ZSQL method works, can't use in DTML
by Capesius, Alan 14 Mar '01

14 Mar '01

Your ODBC is set up to use the new user you created? All Zope access to SQL will flow through the ODBC connection. your connect string should be ODBC_DSN username password What account Zope service runs under is irrelevant in this context as long as that user can utilize ODBC and is using the SQL driver and security. I haven't done alot with intergrated security models under SQL (using NT account security). If the SQL Server is using integrated security model AND if Zope is running on the desktop under Win98, it is running under the account used to login to Windows. In this case, you must logon to Windows 98 using the NT account that has been given the authority on SQL or you will not have ODBC access to SQL. Since you can browse the tables, this is working. Look at permissions asssigned to the DTML document (make sure it's a dtml doc). Should have Use database Methods, Access Contents, View at least. If the user authenicated to Zope or Anonymous? Are you able to call the SQL Method directly (outside the management interface)? "http://123.45.67.89/sql_method" Your HTML tested fine here. Alan http://twsite.bizland.com/zopetips.htm >>>refuses to accept anything that oughta work. I've created a >>>user in MS-SQL >>>specifically for this purpose, and it doesn't work. My own >>>All of this had me thrilled, until I tried to use the ZSQL >>>method in a dtml >>>document, as follows: >>> <dtml-var standard_html_header> >>> <H2>Here's SQL output:</H2> >>> <UL> >>> <dtml-in test> >>> <LI><dtml-var tour_name></LI> >>> </dtml-in> >>> </UL> >>> <dtml-var standard_html_footer>

1 0

RELEASE StarRave 0.0.19 - A call for help -
by ed colmar 14 Mar '01

14 Mar '01

Hi All! My little zope project is almost a year old. And Even though the main page (www.starrave.org) is down, there are still sites in operation. See www.trustcrew.org for a site that is in active use. This product automates many functions of websites for local rave scenes, and rave production companies. This release fixes some problems with newer zopes, and works with the new 2.3 The main problem I'm having is getting the catalog to work right... I strayed from the path of the new Squishdot catalog, because I couldn't get that format to work properly... but now it is all messed up. If anyone could take a quick look that would be great! You can find the new product here: http://www.zope.org/Members/element/StarRave -e-

1 0

Re: [Zope] Keep track of language.
by Dieter Maurer 14 Mar '01

14 Mar '01

Pattreeya Tanisaro writes: > Dieter, do we need to do something with database? I searched the > CoreSession-how to and it said something I have to do with database...that's > why I am confused. The term "database" is used in a very wide sense in Zope's context. You surely have heard of the ZODB (Z Object Database). It is where Zope stores its objects. It is an embedded part of Zope. The CoreSession product currently supports two SessionDataManager types, a RAM session data manager that keeps the session information in RAM (i.e. no database) and an external SessionDataManager that stores the session information in ZODB. If you like (but I assume you do not), you could implement the SessionDataManager interface in your own class and then use an external database (or a file, or ...) to store your session data. Usually ZODB, itself an interface and not an implementation, is implemented by "FileStorage". This is an undoable storage that uses a file to store objects. Whenever you modify an object, a new object version is created and stored. This way, you can undo changes (as old versions are still there), but any small change increases the amount of storage necessary (for the new object version). Thus, the standard ZODB implementation is not very good to store the volatile session information. There are non-undoable ZODB implementation (not yet complete) that do not exhibit this problem. But probably, you will not go this way. You will either stick to a RAM based SessionDataManager or (if your load is expected to be low enough that you remain on a single computer) use a different session product. I, e.g., use FSSession, a file based session manager, and I am very satisfied. Such a file based solution will not scale well when the site needs to be spread over different computers. Dieter

2 1

Re: [Zope] XML Parsed for all platforms?
by Karl Anderson 14 Mar '01

14 Mar '01

Martijn Pieters <mj(a)digicool.com> writes: > On Wed, Mar 14, 2001 at 11:42:21AM +0100, Zanotti Michele wrote: > > I see that XMLParsed 0.1 b3 is only for generic Unix-like platform, while > > 0.1 b1 and b2 are for all platforms. Do you know if XMLParsed developers > > want to abandon Win platform? > > Actually, that may be a mistake; b3 is also ment for all platforms, but I > know that karl hasn't yet managed to get a Windows development environment > running for him to compile a Win32 version. > > We will certainly not abandon the Windows platform; if anyone can assist > us with compilation of the Product on the Windows platform however, I am > sure it would help matters :) The thing that a win32 version of ParsedXML needs is a compile of PyExpat (which is included in the distribution). People have reported problems with the doing that, and we haven't been able to give it a good look yet. If anyone has gotten PyExpat to compile, we could have a win32 binary release. The version that we're using is just a CVS checkout; eventually we hope to use the release. We don't plan on abandoning windows, but without a windows PyExpat our plan is to look at windows after we've released the unix version. -- Karl Anderson karl(a)digicool.com

1 0

Re: [Zope] Namespace confusion
by Dieter Maurer 14 Mar '01

14 Mar '01

Joel Burton writes: > .... > <adtml-call "REQUEST.set('id', 'discuss')"> > <adtml-call "REQUEST.set('title', 'Discussion Area')"> > > <dtml-with "manage_addProduct['JDiscuss']"> > <dtml-call "JDiscuss_Folder_add( _.None, _)"> > </dtml-with> > > > </dtml-with> > .... > The problem is that it overwrites the current values of title and id, so I > can refer later to the book title and id. > > I've tried to do this like wrap the JDiscuss_add in <dtml-let> or > <dtml-with> bands to supply a namespace for the title and id, but haven't > been successful.... > would work, but it doesn't. (No error, just doesn't use the new id or > title.) Apparently, the "JDiscuss_Folder_add" only looks on "REQUEST" and not on the namespace. Do you have control over it? Then, you may change it. Otherwise, you may try <dtml-let REQUEST="{ ... your assignments ...}"> .... <dtml-call "JDiscuss_Folder_add(_.None,_)"> </dtml-let> May be difficult, as the true "REQUEST" is quite complex and may be difficult to emulate in a dictionary sufficiently for your "add". Dieter

2 1

Re: [Zope] Newbie: uploading file with python script (problem with it)
by Dieter Maurer 14 Mar '01

14 Mar '01

Hans de Wit writes: > I have a problem uploading files via a form and a python script. > The content of the uploaded file after uploading it is only a string, ie the name of the > file, not the file itself. ..... > <form action="addFile"> Forms that submit files must use method="POST" enctype="multipart/form-data" Maybe, you look at URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html to learn more about form processing. Dieter

1 0

Fwd: CGI Question
by Network Administrator 14 Mar '01

14 Mar '01

Hi Zopists, Is there a simple way to run CGI scripts from Zope without using Apache? Thanks ahead of time for any help, Luis.

3 2

Re: [Zope] sorting based on object url
by Dieter Maurer 14 Mar '01

14 Mar '01

Parikh, Jay writes: > I have a simple ZCatalog that I am trying to sort via the path of the > objects. I have the following so far, and it doesn't seem to work. > > <dtml-in catalog sort="catalog.getpath(data_record_id_)" size=50 > start=query_start> With Zope 2.3, you can use "sort=getpath". I fear, it is much more difficult with older Zope versions. The "sort_expr" is evaluated just once at the start of the sort to get a sort specification for the complete sort. It is not evaluated in the context of each element, thus, it can not use the elements attributes (such as "data_record_id_". You can use a Python Script (or external method) that returns "catalog.getpath(data_record_id_)" and use that as sort criterion. Dieter

1 0

Re: [Zope] ZClass property sheets and permissions
by Dieter Maurer 14 Mar '01

14 Mar '01

John Morton writes: > I'd like to bind the management of each sheet to a particular permission - > 'Change TODO item properties' and 'Mark TODO Item As Complete'. The available permissions can be configured in one of the ZClass tabs. Dieter

1 0

Re: [Zope] FTDraw
by Dieter Maurer 14 Mar '01

14 Mar '01

Paz writes: > ERROR: Cannot find PIL.Image module > > > Grrr.... Fine... At least the error message is different... Progress by Old > Bell's standard. Lets check it out.. Um.... > /lib/python/Products/PIL/Image.py.... Duh... can the compiler read or has > the third bottle of wine FUBAR'd me? Can you verify, that "PIL" contains a "__init__.py" file. Some broken unpackers remove empty files. But "__init__.py" is essential, even if empty. Dieter

1 0