June 2000 - Zope - Zope lists

Q: Accessing ZSQL methods from Python
by a.wacknitz＠francotyp.com 07 Jun '00

07 Jun '00

Hi all, my question is what type or value is returned by a ZSQL method that is invoked from Python? Or, more precisely, how can I determine if a field contains a NULL value? Sample code: def myZSQLAccessFromPython(self, aParameter): """myZSQLAccessFromPython() returns a record set from a database table.""" #Call the ZSQL method rs = self.zsqlMethod(parameter=aParameter) if len(rs) == 1: #I expect exactly one result column if rs[0].field is not NULL: <- How to code this? rs[0].field == None does not work Do_some_interesting_work() TIA, Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

Re: [Zope] Newbie Question,
by Chris Withers 07 Jun '00

07 Jun '00

CURTIS David wrote: > I wish to use use the date of a database file in my dynamic html code. For example, this database was last updated on 06/06/2000. I suppose that there must be a dynamic html tag that zope uses. What could it be? I looked at all the documentation and have yet to discover it. <DTML-ZOPE-FILE-DATE> Any help is apprechiated. <dtml-var bobobase_modification_time> ...obviously... :( This will give you the time your current object was last modified. Why has this not been renamed to something sensible? We lost PrincipiaSearchSource a while back, I hope this goes the same way ;-) cheers, Chris

1 0

How to catch URL in DTMLDocuments/Methods
by Ian Sparks 07 Jun '00

07 Jun '00

Hi, As a Zope newbie I'm still not entirely sure about how to capture the URL as Zope traverses the tree. For instance, my site called with : mysite.com/members/ian/preferences/10 "members" is a DTMLMethod or Document. What I want to do is trap the URL once it has entered "members". So inside "members" I want to do things like : 1. Get the next part of the url ("ian") and run an SQLMethod using this as a parameter (calling SQLMethods I understand). 2. Get the part after that, "preferences" and pull in my "preferences" DTML page from /templates/preferences, possibly passing it the next part of the url "10" as a parameter to that DTML page. The conceptual problem I have is that DTMLMethods/Documents don't have a parameters tag like SQLMethods do, so I don't see how I can "trap" parts of the URL like SQLMethods do and use them internally in my Method/Document. I know I keep asking this type of question, please bear with me 'till I get it! - Ian Sparks.

3 2

(no subject)
by Alexandre A. Drummond Barroso 07 Jun '00

07 Jun '00

You both had the same problem I have now: make Oracle 8i (in my case, Oracle 8.1.6) work with Zope. DCOracle is working well (Makefile attached to this message) but ZOracle isn't running yet. We are posting e-mails about it on the list for a while and nobody answered, so I must think that nobody on Zope universe is using Oracle 8i (neither NT nor Linux Oracle 8i client). There isn't any detailed documentation about it. The ZOracle installation instructions are simple but, in my opinion, incomplete. To solve this situation, I'm making a call to everybody that uses or wants to use Zope with Oracle 8i. My goal is finally document the installation process and make it work properly. Please contact me ASAP. Regards, Alexandre A. Drummond Barroso.

6 5

Newbie Question,
by CURTIS David 07 Jun '00

07 Jun '00

Newbie Question, I wish to use use the date of a database file in my dynamic html code. For example, this database was last updated on 06/06/2000. I suppose that there must be a dynamic html tag that zope uses. What could it be? I looked at all the documentation and have yet to discover it. <DTML-ZOPE-FILE-DATE> Any help is apprechiated.

1 0

Re: [Zope] stupid question I guess
by Petr Knapek 07 Jun '00

07 Jun '00

Look at dtml-let tag. It is what are you looking for. Any other way is REQUEST.set (name, value). >>>>> On Wed, 7 Jun 2000 14:48:37 +0100, "josh on" <josh(a)zesty.com> said: jo> but I can't find the answer... can I set a local variable in jo> zope on a dtml page eg jo> <dtml-var variablename = 1> jo> thanks josh on Petr -- Petr Knápek NEXTRA Czech Republic, s.r.o., Veveří 102, 659 10 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-41 558 394 FAX:+420-5-41 558 390 "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998

1 0

Re: [Zope] manage primitives documentation
by Petr Knapek 07 Jun '00

07 Jun '00

I think you are looking for Zope Quick Reference http://www.zope.org/Members/ZQR Look at Full version of that. >>>>> On Wed, 07 Jun 2000 15:59:26 +0200, Pierre Rougier <prougier(a)ina.fr> said: PR> Hi all! I just have a problem of documentation.... does anyone PR> know where I can find the doc about all the manage_something PR> primitives (like manage_upload(), manage_clone()...) My problem PR> is that I want to insiantiate an abject from a method, but I PR> can't find the good primitive..... PR> Thanks for your attention... :^) PR> Pio. Petr -- Petr Knápek NEXTRA Czech Republic, s.r.o., Veveří 102, 659 10 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-41 558 394 FAX:+420-5-41 558 390 "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998

1 0

Searching Catalog for Permissions/Roles
by Jason Spisak 07 Jun '00

07 Jun '00

Zopists, Does anyone know if it's possible to create a search in the ZCatalog based on permission or role. Such as: Search of the things from the ZCatalog where the current user has the 'View' permission for the text 'smith'. I love to push the envelope. :) -- Jason Spisak 444(a)hiretechs.com

1 0

Combining a search and uniqueValues..
by Anders Holmbech Nielsen 07 Jun '00

07 Jun '00

Hi, I want to find the unique values from a search. This first search return (among others) som keywords (emneord) which unique values I want get(second search). <dtml-in "artikler.artikel_catalog(artikel_dato=[artikel_dato_fra, artikel_dato_til], artikel_dato_usage='range:min:max', raw=fritekst, kategorier=kategori_valg, emneord=emneord_valg, publikation=publikation_valg)" size=10 start=query_start sort=artikel_dato reverse> <dtml-in "artikler.artikel_catalog.uniqueValuesFor('emneord')" sort> Is it possible to do this with standard dtml and catalog or should dive into some python coding ? -- Regards ------------------------------------------------- Anders Holmbech Nielsen | Tlf: (+45) 70 22 56 00 Software Engineer | Fax: (+45) 70 22 57 00 Integrator Uniware A/S | http:/www.integrator.dk

1 0

News tickers
by Oleg Broytmann 07 Jun '00

07 Jun '00

Hello! I'm looking for News Products (yes, I know KM News :). I need a news ticker with the followin features: -- rubrics in news item - one item can belong to few rubrics (it is news item about both Zope and Python, e.g) -- one customizeable interface for entering news items in different rubrics -- few different customizeable interfaces for viewing every rubric -- SQL storage (SQL seems much more natural storage for news items than ZODB) -- export to RDF/RSS I am not in hurry, I'll write such Product myself if I couldn't find one ready. Also I'm looking a Product to import RDF/RSS files - I rememeber seeing it somewhere. Oleg. (All opinions are mine and not of my employer) ---- Oleg Broytmann Foundation for Effective Policies phd(a)phd.russ.ru Programmers don't die, they just GOSUB without RETURN.

3 4