- Zope - Zope lists

New Zope.org
by emf 30 Nov '00

30 Nov '00

Zopatistas! Zope.org is finally living in its new home. Right now, you may be getting zope.org through the old apache, so don't be surprised if it's a tad slow. By late tomorrow, just about everybody's dns should have updated to the new IP address. If you want to know, do a nslookup www.zope.org: you should get 63.102.49.33 as your answer. When I finally wake up tomorrow, the first thing I'm going to do is start working on a write-up of what the new zope setup is all about. Thanks for your patience! ethan mindlace fremen Zopatista Community Liason

4 3

sqlgroup
by Tom Deprez 30 Nov '00

30 Nov '00

Hi, Is there a reason why the attribute 'having' doesn't exists? I want to use <dtml-sqlgroup having> <dtml-sqltest ... optional> </dtml-sqlgroup> this way when the sql-test tag contains nothing, also the having clause is not attached to the query. Why does 'where' exists and 'having' not? Is there another way to mimic 'having'? Thanks, Tom.

1 0

RE: [Zope] date in Z Gadfly Database
by Farrell, Troy 30 Nov '00

30 Nov '00

Note that Gadfly does not support the DATE datatype. You can use VARCHAR to store a string, or switch to a different database, such as PostgreSQL (my personal preference) or MySQL. The answer to your question is found here: http://www.chordate.com/kwParsing/gadfly.html#table The main Gadfly pages are here: http://www.chordate.com/gadfly.html Troy -----Original Message----- From: Angietel [mailto:angietel@hotmail.com] Sent: Thursday, November 23, 2000 2:16 AM To: zope(a)zope.org Subject: [Zope] date in Z Gadfly Database When i create a table, one of the fields is consider as date type, but the Z Gadfly Database does not allow me to do that, it only accepts INTEGER instead of DATE type. The following is my SQL for creating a table:- CREATE TABLE customer (custid VARCHAR(10), custname VARCHAR(15), custactdate DATE, custadd1 VARCHAR(30), custadd2 VARCHAR(30)) Please let me know if i got an error.Thank You.

1 0

login dialog text
by Ragnar Beer 30 Nov '00

30 Nov '00

Hi Zopistas! When users connect to a restricted area a dialog box pops up that looks more or less like this: ------------------------------------ Enter user name for Zope at myhost: User: _________ Password: _________ ------------------------------------ Where and how can I change the content of the first line so that it would e.g. read "Enter user name for funky stuff at myhost"? Ragnar

2 2

Re: [Zope] DC and the PTK?
by Tres Seaver 30 Nov '00

30 Nov '00

Dennis Nichols <nichols(a)tradingconnections.com> wrote: > At 11/29/00 03:42 PM, ethan mindlace fremen wrote: > >Dennis Nichols wrote: > > > >>At 11/28/00 11:34 AM, albert boulanger wrote: > >> > >>>Whether to go with portal products from Plumtree or iPlanet. > >> > >>If this implies that you are considering using Zope's PTK, then you > >>should be aware of this: You can *not* get commercial support from > >>Digital Creations for PTK because PTK is not a released product. If you > >>think you may need such support before PTK gets to 1.0, then you had > >>best not use the PTK. But that's no reason to not use the rest of Zope. > > > > > >This needs to be clarified. We actively do consulting with the PTK. > >If you want to enter into a consulting contract with Digital Creations > >that involves the PTK, that's not a problem. > > > >If you decide you want to use the PTK yourself, there exists a mailing > >list and a product tracker. (see http://www.zope.org/Products/PTK ) The > >PTK is under heavy development and is not a full release yet, so that does > >need to be taken into account if you wish to use it yourself. > > What Ethan says, however true it may be, is contrary to my experience. I > worked on developing a site based on PTK for several months and was within > a month of going live, but had problems I could not solve, either alone or > with the help of the mailing lists. I contacted DC via email, explained > what my problems were, and asked how to arrange for consulting time. That > was 11 weeks ago, on 10 Sept 2000. The very next day I received an email > from Gary Graham (gary(a)digicool.com, Director, Sales & Marketing) stating: > > "PTK is a 0.01 release and not commercially supported yet. Zope is > commercially supported yet. Zope.org is the best PTK source at > present until we are able to release a commercially supportable > version." I think we need to distinguish between "support" and "consulting". DC is primarily a *consulting* company (we build custom software for our clients), which also sells support contracts for Zope. Because the PTK is not (yet) a "released product", we don't (yet) sell support contracts for it; we *do* use it in consulting engagements, however. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

mysql & zope
by Alexander DePauli 30 Nov '00

30 Nov '00

Hi Zopistas! we are looking for a method to do a better integration of mysql 3.23.27 with zope 2.2.2. (we are using the Z MySQL database adapter Z MySQL DA 1.1.3.) We have to store data in a mysql database - we can´t use ZODB because we need the data accessible by other programs via ODBC. We habe implemented several ZClasses like "customer", "product" and "orders". We store their instances (eg. each product, customer and so on) to the mysql-database. Our problem: we can´t use the standard ZOPE management interface to manage the objects, because the methods of this interface store content to the ZODB - and not to the mysql-database. Is there a way to extend the standard ZOPE management interface with additional mysql statements? For example: we select an object in a zope folder, press the ZOPE Delete-Button, then this object is deleted on the mysql-database, not on the ZODB? For each zclass (customer, products, orders) we need these extra methods (Delete, Update, Insert ...), so our thought is that we would prefer to use the ZOPE management interface to do this instead of programming "extra methods" which obviously can't be used within the standard ZOPE management interface. Hope there is somebody out there with an similarly problem solved. best regards Ruediger ~~~~~~~~~~~~~~~~~~~~~~~~~ http://www.herrenausstatter.de - Der Online-Herrenausstatter Kostenlose Serviceline: 0800 -999 66 33 Versandkostenfreie Lieferung - 30 Tage Rückgaberecht ~~~~~~~~~~~~~~~~~~~~~~~~~ Verwaltungsadresse: DePauli.com Aktiengesellschaft Stahlgruberring 3 - 81829 München Telefon: 089 / 530 75 170 - Telefax 089 / 514 50 666

2 1

Re: [Zope] Why GUF or Loginmanager??
by Oliver Bleutgen 30 Nov '00

30 Nov '00

> Hallo, > I'got a fundamental question: > Why should you switch from the built-in authentication mechanism to a > product like GUF or Login-manager?? You can choose the storage for your userdata yourself, which may be practical for i.e. - huge user base and/or you also like to store adresses etc. easily. - adding/changing users through mechanism outside of zope - verifying users through mechanism outside of zope (ie. apache's various mod_auth_*) for tasks outside of zope (try to stream a .rm-file only to built-in authenticated users) cheers. oliver

1 0

Rookie Question - Syntax
by Walter Pleyer 30 Nov '00

30 Nov '00

Hi folks! I am a Zope/Python-Rookie and Ihave a probably quite simple problem: I must check if some must-fields from a form were filled out by a user. Checking data from a single field is no problem, but what's the correct syntax for checking more than one field (e.g. "name", "address", "email") ? Thanx Walter

4 3

Fast Access.
by Jason C. Leach 30 Nov '00

30 Nov '00

hi, Is there a faster way to access Zope? I find I wate too long for page refreshing and updates. j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

3 3

User mangement
by Sven B. 30 Nov '00

30 Nov '00

>>Zope has a function "get_valid_userids()". >>Now my question; >>How is it possible to get something like (username;role;path)? >refer to the ZQR: > http://zdp.zope.org/projects/zqr/ZopeQR >and look for the section describing the AUTHENTICATED_USER object. > Thanks seb, but i need to get (username;role;path) for all users (i.e. 500) of a zope site. AUTHENTICATED_USER seems to be only for the current user. sven

1 0