- Zope - Zope lists

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

RE: [Zope] ZClass security : a solution
by Bowyer, Alex 30 Nov '00

30 Nov '00

Seb, you were right, I was referring to ZClass security, which is very poorly documented. And no you're not being intellectually lazy, that sentence does make no sense!!!! I have kind of got a working solution now, so I will share it for anyone interested: To recap, the scenario is a news page with a DTML method for viewing which is accessible by all but also DTML methods for editing the content, which are only to be available to users holding a certain role, which I happen to have called UAAdmin (if you're wondering what UA is, it's the name of the newsletter "Update Australia"). Each instance of the class is a separate news page. What I did is this, it's a bit of a messy solution but it works for me: 1) Create a role at the root level of Zope called UAAdmin (I keep all roles at this level for simplicity). 2) At the level which instances of the news page class are to be created, go to the Security tab and assign permissions to the UAAdmin role. If possible include at least one permission which is not held by any other roles or users at this level (other than the Manager of course). In my case "Manage properties" could only be done by UAAdmin or Manager roles. This could be anything, even something you don't use such as perhaps "Add ZGadfly Database Connection" (ZODBC is much better!). 3) Within your ZClass class definition, for each DTML method you want to assign security to: a) Go to the 'Define Permissions' tab b) Go to the dropdown next to 'View' and change "View" to "Manage properties" (or whatever permission was unique to the role you want to give access to). For methods that should have anonymous access, leave it as "View" You will find that this will have the desired effect of limiting access to those pages/methods only. Essentially what we are doing is saying "If you want to View this object, you have to have the Manage Properties permission" There are probably better ways, but if it ain't broke don't fix it. I don't understand why you have to choose a permission for each permission (which is a very confusing concept). It would be much better if you could choose a role to say e.g. "If you want to View this object, you have to have the UAAdmin Role" Apparently there's something called ZPermissions where you can create your own, so I could create a permission "Manage News Pages" and then say "If you want to View this object, you have to have the Manage News Pages permission" but I never worked this out fully. If anyone has any suggestions for improvement, by all means put me straight, but this worked for me. Thanks Alex ================================== Alex Bowyer IT Contractor, Logica Australasia Tel : +61 2 9202 8130 Fax : +61 2 9922 7466 E-mail : bowyera(a)logica.com WWW : http://www.logica.com.au/ ================================== > -----Original Message----- > From: seb bacon [mailto:seb@jamkit.com] > Sent: Thursday, November 30, 2000 12:53 AM > To: Dieter Maurer > Cc: Bowyer, Alex; 'zope(a)zope.org' > Subject: Re: [Zope] security > > > * Dieter Maurer <dieter(a)handshake.de> [001128 00:12]: > > Bowyer, Alex writes: > > > Can some one explain how the Define Permissions screen > works. I really don't > > > understand the concept behind it, what does it mean for > a permission setting > > > to own a permission? > > > > > > All I need to do is to make certain ZClass methods have > a certain level of > > > security and the other methods of the class have no security. > > > It is quite good explain in the upcoming Zope book. > > In fact, I think Alex was referring to ZClass security, which isn't > covered in the book, and is something I've never go to the > bottom of either. > on the 'define permissions' tab, it says: > > The table below has two columns. The first column lists the > permissions for this object. The second column specifies the > permissions that should have this permission in this product > or ZClass. > > I'm probably being intellectually lazy or something, but that doesn't > make any sense to me at all. > > seb. >

2 1