- Zope - Zope lists

The tree tag, SQL and what should be simple
by icottee＠bluefountain.com 24 Aug '00

24 Aug '00

I thought this was going to be simple but having read numerous postings on the mailing list and all related HOW-TOs I can find, I think I can confirm I am stuck. This is sad because I've just spent a very productive couple of days with Zope and MySQL making the world a better place. I have a table for chickens. Basically it looks like this CREATE TABLE T_CHICKEN ( ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, CODE CHAR(10) NOT NULL, DESCRIPTION CHAR(40) NOT NULL, NOOFLEGS INT NOT NULL DEFAULT 2, TYPEID INT NOT NULL ); And another table for types. CREATE TABLE T_TYPE ( ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, CODE CAR(10) ); Each chicken has a type associated with it. At the end of the day I want to display the chickens underneath the type it has ... start the screen up it would say + BIG + MEDIUM + SMALL And the users can then expand to see the chickens available in each category. + BIG - Flossie - Wombat - Hank + MEDIUM - Debbie - Fruitbat - Harold + SMALL - Bob It would appear that I need to feed two things to the dtml-tree tag. Firstly my starting levels (my types) and then the related data underneath but I can only feed one SQL query to the tag. All the stuff I read seems to assume the info at the top level comes from the same file (and from a key id). How do I do this or indeed, is it possible? I have a nasty feeling I am missing something obvious. Ian

1 0

Re: [Zope] Can't compare apples to apples. (document_id != id_of_my_document)
by Jens Quade 24 Aug '00

24 Aug '00

"T.J. Mannos" <MannosTJ(a)slcc.edu> writes: > Hi, there, > > I have a DTML document called "apples". > > A call to <dtml-var document_id> gives the string "apples" > > However, a <dtml-if "document_id == 'apples'"> returns false. Am I missing > something? I've tried _.str(document_id) and even > _.string.strip(_.str(document_id)). document_id is a function, document_id() returns the document_id. dtml-var calls any function automatically, python (inside the quotes) doesn't. Compare <dtml-var document_id><br> <dtml-var "document_id"><br> <dtml-var "document_id()"> -- Jens Quade * jq(a)jquade.de * Bonn

1 0

RE: [Zope] Including a method returning batches inside a page.
by Jean Jordaan 24 Aug '00

24 Aug '00

hi Dieter > For a DTML method(!), "id" is the id of the object of which > the method is used as a method. > In your case, this is the folder. No, actually -- since 'index_html' is a document, it turns out to be the id of 'index_html'. > In some cases, you would use "this().id". OK, I'll try and understand that .. -- jean

1 0

Faulty default ZClass constructor method?
by Jean Jordaan 24 Aug '00

24 Aug '00

Hi all If I add a product from ' /Control_Panel / Products ', and then add a ZClass in there with 'Create constructor objects' checked, I end up with a ' /Control_Panel / Products / ccTest / testClass_add ' method containing:: <dtml-if DestinationURL> <dtml-call "RESPONSE.redirect( DestinationURL+'/manage_workspace')"> <dtml-else> <dtml-call "RESPONSE.redirect( URL2+'/manage_workspace')"> </dtml-if> This generates:: Error Type: TypeError Error Value: bad operand type(s) for + File C:\programs\ZopeDev\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: RESPONSE.redirect( DestinationURL+'/manage_workspace')) (Info: DestinationURL) File <string>, line 0, in ? TypeError: (see above) Adding a () to the DestinationURL above made it work:: <dtml-call "RESPONSE.redirect( DestinationURL()+'/manage_workspace')"> Shouldn't this be fixed somewhere? -- Jean Jordaan -- technical writer -- Mosaic Software -- Zope 2.1.6 on WinNT and W2K

2 1

RE: [Zope] Permissions / roles question
by Jean Jordaan 24 Aug '00

24 Aug '00

Hi RDM > Actually, in at least some versions of GUF, all users also > have the Anonymous role. Not in mine (from '/docs/acl_users/userRoles'):: <dtml-comment> njj: from the Readme: "Don't force Anonymous role for users - it isn't needed?" I certainly hope it isn't. At present my users are both 'ZWikiUsers' and 'Anonymous', for example, and that makes no sense. Anonymous </dtml-comment> -- Jean Jordaan -- technical writer -- Mosaic Software -- Zope 2.1.6 on WinNT and W2K

2 1

ZClass Date Fields
by Craig 24 Aug '00

24 Aug '00

I'm sure you've heard this question before, so bare with me. I went through the ZClass tutorial and got everything working right except Date properties. Lets assume, for example, that my ZCLass is called CDClass. When I create a new CDClass instance (using the addForm), it always uses the default date for Date properties instead of the ones I've entered in the form. A co-worker of mine has had the same problem but we have not yet discovered why. Thoughts? Solutions? Later, -- \ Craig "Cowboy" McDaniel /_\ Software Engineer /_/_\ Internet Tool & Die /_/_/_\ craig(a)tool.net /_/_/_/_\ (502) 584-8665 ext 108

2 1

Can't compare apples to apples. (document_id != id_of_my_document)
by T.J. Mannos 24 Aug '00

24 Aug '00

Hi, there, I have a DTML document called "apples". A call to <dtml-var document_id> gives the string "apples" However, a <dtml-if "document_id == 'apples'"> returns false. Am I missing something? I've tried _.str(document_id) and even _.string.strip(_.str(document_id)). Thanks, T.J.

1 0

Simple Directory of URLs problem (Waaa)
by Peter Be 23 Aug '00

23 Aug '00

Roug Installing your Simple Directory of URLs gives me this message when I start up Zope on window98. "that is not valid. This should never happen. (Waaa)." There is something wrong with the permissions I guess but I can't see the error message it generates because either I'm stupid or MS DOS PROMPT is to short on lines. If it was Linux I could at least have scrolled upwards to see the whole error message. I can see that the error must occur in PermissionMapping.py I run Zope 2.2.1b1 on Windows98. The tgz file I downloaded contained three files. __init__.py, version.txt and product.dat. Is that correct? The problem is, that I can't see or Add the Simple URL object from my Add dropdown list. Why is that? I have so far never had any problems with this setup. (I think) It is a development server, so I can knock it off and start again if I have to. I have followed the Installation instructions, and I have successfully installed your product previously on Zope 2.1.6 Cheers, Peter

1 0

Re: [Zope] Microsoft SQL Server Access under Linux?
by Anthony Baxter 23 Aug '00

23 Aug '00

Use Sybase. Sybase even provide the client libs for download for *ahem* evaluation. MS SQL == Sybase wearing a pair of bad Groucho Marx glasses/nose/mustache (aka an annoying management GUI) Or FreeTDS, but last time I looked that wasn't threadsafe. Anthony >>> "Darin Lee" wrote > Zopistas, > > Is it possible to access an ODBC data source through Zope running under Linux ? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment. > > I would very much like to setup ZAP (for many reasons), but our "organization al standard" is MS SQL Server 6.5. > > Thanks, > -Darin Lee > > > > > Darin M. Lee > Analyst / Web Administrator > Office of Automation Coordination > Michigan Department of Environmental Quality > Phone: 517.241.5214 > leedm(a)state.mi.us > > Darin M. Lee > Analyst / Web Administrator > Office of Automation Coordination > Michigan Department of Environmental Quality > Phone: 517.241.5214 > leedm(a)state.mi.us > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Re: [Zope] newbiz : zope connection
by Dieter Maurer 23 Aug '00

23 Aug '00

kguesnet(a)imexpert.com writes: > I want to know how many people are connected on my zope server, and who > are they, has anybody an idea to see this sort of information ? HTTP is a connection less protocol (to be precise, HTTP 1.0). Thus, a priori, there is no notion of connection: A user is only connected to the server for the duration of a single request. The connection is closed as soon as the request is completed. Zope 2.2 has a facility in its Control Panel where you can see, how much requests are currently in work. This gives you the 'currently' connected users. To get more information, you would analyse ZServer's log file: "var/Z2.log". It contains an entry for each HTTP request. There are tools to analyse such a log file. Search the mailing list's archive for suggestions for such tools. Dieter PS: please do not post "multipart/alternative" (or other MIME messages) to the Zope lists.

1 0