- Zope - Zope lists

Q; Date / ZCatalog / Search
by Jørgen Skogstad 22 May '00

22 May '00

Kindest sir, I have a small question I hope someone could share some wisdom with. I am not that familiar with the various objects available within the Zope framework yet. .. I have made a ZCatalog which works seamlessly for text only searches etc. However; I need to search on a date basis on the generated object in the ZCatalog. For now my "date" entry/column is [string] coded.. not "date" as would be apropriate? How can I use date .. and then make a search to get the last 5 entries in a table? http://www.zope.org/Members/Zen/howto/AdvZCatalogSearching .. shows some possible ways to do this; but I can't seem to get them to work properly; <dtml-comment> Items modified in the last 14 days </dtml-comment> <dtml-in "Catalog(bobobase_modification_time=_.DateTime(date)-14, bobobase_modification_time_usage='range:min')"> New item: <dtml-var "Catalog.getpath(data_record_id_)"><br> </dtml-in> .. does anyone have any information on how they have used this and gotten it to work? .. and might have an example or two? ;) What exactly does the various elements in the above example do? .. like "Catalog(bobobase_modification_time=_.DateTime(date)-14, bobobase_modification_time_usage='range:min')" ?? .. mm .. any input? ;) Thanks in advance.. Kindest, Jørgen Skogstad

3 2

RE: Generate edito form from dtmlDocument : property type
by Dr. Ross Lazarus 22 May '00

22 May '00

I think the general idea of automating html generation for data entry web forms is a very good one, but IMHO it's heroic to even think about doing this sort of stuff in dtml!! (This discussion probably should be moved to zope-dev?) I've got something which generates useful DTML and ZSQL code automagically from ZClass BASIC propertysheet contents and so can be used to do the grunt work for making zclass add and edit methods. It generates ZSQL code which is only tested for the sybaseda but would be relatively easy to tweak for other DA's It uses a single python external method - have a look at http://www.zope.org/Members/rossl/ZClassExtender for an example of what's possible...feel free to extend it?!! Sin Hang Kin wrote: > I have the method form_dtmlDocument which generate the data entry form from > an existing dtmldocument, How can I determine the type of the properties? > Moreover, if the property is expected as list, how can I convert it into > multiple input tag? -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, Room 126A, A27, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au

2 3

how do you iterate over tiny tables?
by Graham Chiu 22 May '00

22 May '00

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have a folder full of Tiny Tables. I would like to go over each table, and iterate thru their contents. <dtml-in "objectValues(['TinyTable'])"> <dtml-in sequence-item> <dtml-var value><br> </dtml-in> </dtml-in> doesn't do anything. Clues? - -- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope -----BEGIN PGP SIGNATURE----- Version: PGPsdk version 1.7.1 iQA/AwUBOShmmLTRdIWzaLpMEQK1bgCfZzGV36/mDJUv0cMs+l0aLXIx2eMAoKwF fFOcpW6t4quJ2qisBnvYU/n4 =hdRX -----END PGP SIGNATURE-----

4 7

LocalFS Question
by Jim Sanford 22 May '00

22 May '00

Does anyone out there know how I can prevent LocalFS from translating CR/LF pairs in a text file to LFs when serving up the file? Or will I need to "massage" it in Zope before sending it? In this case the files are Windows/DOS batch files. They will not run with the CR/LFs replaced with LFs. Jim Sanford

2 1

dtml-in Tag problem
by Tom Scheidt 22 May '00

22 May '00

<dtml-if related_stories> <table width=175 height=2 cellpadding=0 cellspacing=0 border=0> <tr><td> <font></font> </td></tr> </table> <table width=175 cellpadding=0 cellspacing=0 border=0 bgcolor="#e7e7e7"> <tr><td valign=top> <font size=2> <b>Related Stories</b><br> </font> <font size=2> <dtml-in related_stories> <dtml-let si=sequence-item rs_name_url="_.string.split( si, '^' )" rs_name="rs_name_url[0]" rs_url="rs_name_url[1]"> <li> <a href="http://<dtml-var rs_url>"><dtml-var rs_name></a></li> </dtml-let> </dtml-in> </font> </td></tr> </table> </dtml-if> gives me an error that says: "list index out of range" The related_stories property contains: King Kong website^www.kong.com Empire State Building Website^www.empirestate.com It worked at first but when I made any changes to other properties it gave me that error message. Any ideas? Tom Scheidt | www.falsemirror.com | tom(a)falsemirror.com ---------------------------------------------------------------------------- -----------

2 1

Zope + Apache + Mailman
by pehr anderson 22 May '00

22 May '00

Dear Mailmen, I've been studying this all weekend and finally, *finally* understood enough to get it to work. I wanted to proxypass both sites into zope, however I needed access to CGI scripts and images to run mailman. I had to find the appropriate rewrite rule to allow this to work. The zope Zserver serves pages on port 8080. Apache has the ability to proxy this on port 80 either through "ProxyPass x y" which gives you very little control or through "RewriteRule x y [proxy]" which gives you tremendous control. In zope I have two SiteAcess objects. One at the root, says "http://morseall.org", "/" and the other inside /osm says "http://osm.cx", "/" This worked with the following configuration: Redhat Linux 6.2 apache-1.3.12-2.i386.rpm Zope-2.1.6-1.i386.rpm Zope-zserver-2.1.6-1.i386.rpm # added to /etc/httpd/conf/httpd.conf ScriptAlias /mailman/ "/home/mailman/cgi-bin/" Alias /pipermail/ "/home/mailman/archives/public/" <VirtualHost 24.218.234.247> ServerName osm.cx RewriteEngine On RewriteOptions 'inherit' RewriteRule ^/icons(.*) - [last] RewriteRule ^/mailman(.*) - [last] RewriteRule ^/pipermail(.*) - [last] RewriteRule ^/(.*)$ http://localhost:8080/osm/$1 [proxy] ProxyPassReverse / http://localhost:8080/osm/ ProxyPass /p_ http://localhost:8080/p_ ProxyPass /misc_ http://localhost:8080/misc_ </VirtualHost> <VirtualHost 24.218.234.247> ServerName morseall.org RewriteEngine On RewriteOptions 'inherit' RewriteRule ^/icons(.*) - [last] RewriteRule ^/mailman(.*) - [last] RewriteRule ^/pipermail(.*) - [last] RewriteRule ^/(.*)$ http://localhost:8080/$1 [proxy] ProxyPassReverse / http://localhost:8080/ </VirtualHost>

2 1

Executing an external program
by Mabe, Brad 22 May '00

22 May '00

Is there a way for zope to call an external program (exe, batch file, etc.) and have it execute on the server? I have several home grown utilities on my server that I would like to access/execute via the browser. -=Brad=-

4 3

Re: [Zope] Calling External Method...
by Dieter Maurer 22 May '00

22 May '00

Eric L. Walstad writes: > I am trying to invoke a C++ program from an external method. Platform is > Linux. The C++ program returns HTML. Note that the Python function is > working properly from the Python command line; That is, > ExecCGI.xCGI("./websim") outputs all the expected html. I have placed the > C++ program in the same folder as the ExecCGI module. The C++ program works > from apache: here's an example of the program's output, which is what I'm > trying to get into Zope: > > http://63.203.42.146/cgi-bin/websim > > > ExecCGI module: > import sys, os, string > > def xCGI( cmdLine ): > """ > Run an external command and return its standard output as a string. > """ > f = os.popen( cmdLine ) > lines = f.readlines() > status = f.close() > if status: > raise "CGI returned error: %d" % status[1] > return string.join( lines ) > You have two problems here! First, your program returns a non-zero exit status. Second: "f.close()" returns a simple integer, not a sequence that may be indexed. Remove the "[1]" from status and you should see the nonzero exit status. Dieter

1 0

Zope Pgsql 7.0/SQL Schema HeLp!
by Richard Smith 22 May '00

22 May '00

This is going to be a long winded questions. Ok I have been hacking around with Zope and Pgsql for awhile now. I am trying to learn both at the same time, not any easy task, I don't know SQL that well. I learn by doing ,and this is really fun, kinda like a digital puzzle of sorts. So any way I set up a database in pgsql to hold contact information. This was no small task for me, like I said, I am new to SQL. I did discover a neat way to use CREATE VIEW foo AS SELECT that is not in the book though. Anyway the PRIMARY KEY for the table of names is a SERIAL type, all other tables such as phone numbers and addresses use REFERENCES to this KEY. The database works quite well, I think I have it normalize as much as need be (bare with me I am still learning). Now on to Zope I have Zope all set, and I can run all your standard SELECT, INSERT, UPDATE stuff. But I have one hitch, I can't seem to figure out how to make it so an end user could add a name and email address without knowing about the PKEY number. This is no problem for a DBA but I want to make it easy for anyone to INSERT and UPDATE records. Did I make a bad design choice in use unique numbers to glue all the tables together. Is this an interface problem. Am I missing something. I need some help. Can someone point me in the right direction please? Richard

3 2

Zope.org tracker
by mindlace 22 May '00

22 May '00

Zopistas! There is now a zope.org tracker at http://www.zope.org/Tracker for bugs and feature requests for Zope.org. If there's anything that's been driving you nuts about the zope.org website, or something you'd just like to see, please feel free to add it to the Tracker! Thanks, ethan mindlace fremen Zopista Community Liason

1 0