November 2000 - Zope

ZODBC configuration problems
by paul_s_johnson＠urscorp.com 28 Nov '00

28 Nov '00

Alas, I am but a Zope newbie and need help getting my database connections to work. I have previously configured the ODBC Data Source Administrator to link Access mdbs with the PERL DBI module and it has worked with no problems. I have installed the ZODBC product and in the Zope database connection window all the names of the ODBC data sources that have been configured show up in the listbox. Upon attempting to add any of the data sources I receive the error "Invalid connection string" except for one of the databases that Zope does accept. Upon testing this database connection with a test query I get the following error: Error Type: sql.error Error Value: ('42000', -1907, "[Microsoft][ODBC Microsoft Access 97 Driver] Record(s) can't be read; no read permission on 'ProjectSheets'.") The permissions on this database are such that any anonymous user can access its data so the error message appears to be inaccurate. I double checked the db permissions to make sure this is the case. I am running Zope on NT 4.0 and using Access 97. The logged-in user on the webserver is not a member of any Access-related workgroups so this eliminates most security-related access issues (I think) and none of the databases are passworded. There's some flakiness going on here. Any recommendations for isolating and resolving these problems? Thanks, P. Johnson

1 0

Re: [Zope] PoPy and Delete results
by Dieter Maurer 28 Nov '00

28 Nov '00

Chris Gray writes: > In psql a delete command returns a count of the number of rows > deleted. Is this returned result available to a ZSQL method using PoPy or > PyGreSQL? I think, Zope should pass integer results from SQL commands. But I fear, it does not. When I looked at the code (quite some time ago), I had the impression, that Zope does only pass sequence results. Integer results are translated into 'None'. Dieter

2 1

html expertise anyone.
by Robin Becker 28 Nov '00

28 Nov '00

I am trying to change the colour of links dynamically using dtml. However, I cannot find the right incantation to change my links using an inline style except for <a href=A style="color: red">A</a> I really would like to be able to set the link, active and visited colours. I can do this using a class eg <head> <style>  </style> ..... <a class=badLink....> works -- Robin Becker

3 4

Factory location and Add box pollution
by Stefan H. Holek 28 Nov '00

28 Nov '00

I want to create a folderish ZClass to contain all my project specific ZClasses. The idea is to only have them show up when inside my projectfolder. Just like the ZClass object only shows up inside a product's folder. Well, when I derive from OFS:Folder I do get all the global stuff, but _not_ my included ZClasses in the Add box. OTOH, deriving from ZClasses:ObjectManager gives me my ZClasses, but _not_ the global objects (DTML Methods, ...) Deriving from _both_ gives me the behavior of whichever was named first. I have seen the LocalFactory product, but this would force me to move the factories and constructors out of my ZClasses. Its very existance though might mean what I want is impossible :( Lost, Stefan -- Things work better when plugged in

2 2

[SybDA]Connection : how does it work ?
by Tony Moutaux 28 Nov '00

28 Nov '00

Hello, I am running Zope 2.1.6 under Linux/RH6.2 on a PC. The Sybase server is version 11.9.2 on a Solaris station with DNS name "sybstat" on port 2040 (or sybase server name "sybtest") and the database is named "picsou". When I try filling in the form to add a new Sybase DA connection, the result is always: Invalid connection string. I have try with this parameters : 1-database: picsou, password: mypasswd, server: sybstat, user: myuser 2-database: picsou, password: mypasswd, server: sybstat:2040, user: myuser But this give the same answer ... On Linux, I have the libraries, include files and all running client for Sybase and I can run isql from my PC on the Sybase server on the solaris station very well using the parameters of the (2-) set. So the connection to the Sybase server seems to work ... How could I check what happens inside Zope, or am I mistaken for the parameters values ? Thanks for any help. Tony

2 1

Re: [Zope] come see new.zope.org
by Oliver Bleutgen 28 Nov '00

28 Nov '00

> If no one manages to break it, we're going to switch over wednesday, late. > In the meantime, if people want to wget or ab it, feel free! > ~ethan Don't forget to change http://63.102.49.33/About/Hardware ;-) cheers, oliver

1 0

Zope and PHP
by Kini Natekar 28 Nov '00

28 Nov '00

Hi, I have got some PHP4 scripts which I want to upload in Zope and make them working. Is there a way I can get those scripts working from Zope or else is it possible that I upload those file in Zope and make them work from Apache itself ? I am just a beginner of Zope, so intricate details would be appriciated. Thanks, Kini, __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/

2 1

PyGreSQL or PoPy
by Andreas Tille 28 Nov '00

28 Nov '00

Hello, I'm a very beginner with zope. Up to now I created some web pages using Servlets accessing a PostgreSQL database. I want to switch to Zope now and found to ways to access PostgreSQL database: PoPy and PyGreSQL. What are the differences and what would you suggest to use in which case. Kind regards Andreas.

1 0

Re: [Zope] Python and EJB (J2EE)
by Tres Seaver 28 Nov '00

28 Nov '00

"Hung Jung Lu" <hungjunglu(a)hotmail.com> wrote: <snip> > I've mentioned two-phase commit to Digicool people. Not sure whether it's > already inside Zope or not, but it seems not. Zope's TM (Transaction > Machinery) does not seem to be two-phase. See the TM.py file itself: it only > has > > def _finish(self): > self.db.commit() > > That is, I don't see the equivalent of prepare_to_commit(). ZODB.Transaction uses a TPC protocol: please notice 'tpc_begin()', 'tpc_vote()', 'tpc_abort()', 'tpc_finish()'. This is how ZODB can synchronize, for instance, with Oracle/Sybase commit/rollback. For the nonce, ZODB expects to be doing the driving; playing nice with others XA's is down the road a bit. See Jim's model: http://www.zope.org/Documentation/Developer/Models/ZODB and, in particular: http://www.zope.org/Documentation/Developer/Models/ZODB/ZODB_Architecture_S… for more than you want to know. :) Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

ZCatalog: How to request boolean NOT searches?
by Doug Morse 28 Nov '00

28 Nov '00

Hi, I have what I'm hoping is a simple question. I've setup a search form against a ZCatalog using field searches and everything works great. In the search form, I have the following code (also works OK): <dtml-call "REQUEST.set('sort_on','date')"> <dtml-call "REQUEST.set('sort_order','reverse')"> <dtml-call "REQUEST.set('meta_type','News Item')"> What want to do, and can't seem to figure out, is to call REQUEST.set to set a logical NOT value. For example, I've tried the following for the goal of making the author field NOT EQUAL to the specified value: <dtml-call "REQUEST.set('author','NOT John Smith')"> <dtml-call "REQUEST.set('author','<> John Smith')"> <dtml-call "REQUEST.set('author','!= John Smith')"> but none of these work (of course, I'm just guessing at syntax). Can anyone tell me how I SHOULD be setting a logical NOT condition in this example? Thanks so much! Doug Morse morse(a)pobox.com

1 0