November 2000 - Zope

restarting
by ethan mindlace fremen 15 Nov '00

15 Nov '00

Please bear with me, this nonsense will be over soon.... ~ethan

1 0

Re: [Zope] DTML and SQL question...
by Pavel 15 Nov '00

15 Nov '00

good day, create a ZSQLMethod ... let`s call it genericSQL having your sql query in it, then do a <dtml-if "genericSQL(_.None,_)"> YES! There's some data! <dtml-else> no records found! </dtml-if> in your DTML Method not tested. but should work. regards. -- pashah -----Original Message----- From: zope <zope(a)isp.lu> To: zope(a)zope.org <zope(a)zope.org> Date: 15 íîÿáðÿ 2000 ã. 19:38 Subject: [Zope] DTML and SQL question... >Hi. > >I want to test if there is some data in a table. >If so, I want to perform some action, otherwise I wan't to print out a message. >(<dtml-if>..<dtml-else>..</dtml-if>) > >My SQL statement is something like: > >Select count(*) from my_table where my_field = something > >What DTML code do I need to perform that if-statement? > >Something like the following does not work :-( > ><dtml-if "genericSQL(SQLStatement='Select count(*) from my_table where >my_field = \'0\'') == 0"> > YES! There's some data! ><dtml-else> > no records found! ></dtml-in>

1 0

Installation Troubles
by Ben Ocean 15 Nov '00

15 Nov '00

Hi; I d/l'd the latest distro. Looked inside and couldn't find any installation instructions. Went to the Web site and found some instructions here: http://www.zope.org/Members/mcdonc/HowTos/zopeinstall/ZOPE-INSTALL-HOWTO They didn't work for me. I have crazy ownership problems all over the place. If I go into /usr/local/ I have to be root (I own the server), and the author indicates that I should be my regular user (webmaster) not root. No can do (security reasons). I unpacked the distro and had a bunch of files with user permissions for one of my clients! Not even webmaster! What gives? (I'm still new to Linux/UNIX.) Then I tried to do the ./install and was told there's no such directory (I *do* have ZServer, lib, doc, pcgi, and z2.py). Please help. Distributing installation instructions with the distro might be a nice thought... BenO

3 5

How reindex the Catalog programatically
by Menard.Jean-Francois＠hydro.qc.ca 15 Nov '00

15 Nov '00

To work around my problem with my Catalog reindexing (see previous message...), I would like to let my users manually reindex the Catalog, as the "Update Catalog" button in the "Cataloged Objects" do. When I use this button, my Catalog get fixed and work again. So I looked at the method used by the button source (manage_catalogReindex), and created a method calling this function. When I invoke this method, there is no error, but the Catalog still doesn't work! Any ideas ?$%%? Jean-François Ménard Intranet DPAS Pratiques d'affaires et orientations * (514) 840-3000 poste 3939 * (514) 840-5585 * menard.jean-francois(a)hydro.qc.ca * 855 Ste-Catherine est, 6e étage Montréal, Qué. H2L 4P5

1 0

Do Zope Haz Templates?
by Padrino 15 Nov '00

15 Nov '00

I Was Serching And looking For Templates and I Was Guessing if Zope really Has It?

4 3

_delObject errors
by seb bacon 15 Nov '00

15 Nov '00

When I try to call self._delObject('foo') from my Product, it seems to work, but I get an error logged: AttributeError: 'string' object has no attribute 'manage_beforeDelete' The offending line is in ObjectManager.py: def _delObject(self, id, dp=1): object=self._getOb(id) try: object.manage_beforeDelete(object, self) So, it would appear that self.getOb('foo') returns a string rather than whatever it's expecting. I presume this is because the object I'm deleting doesn't have some requisite base class to make it zope-manageable. It's a ZClass which has ZObject as its only base class. Am I missing something? Cheers, seb

1 0

ZCallable
by Stefan H. Holek 15 Nov '00

15 Nov '00

I have this ZCallable product (from the PTK, I think). I do however not manage to derive a ZClass from ZCallable. The error is something like "Too many datafull base classes". Is ZCallable not intended to work like that (the source hints to some ExtensionClass business) or am I missing something? TIA Stefan -- Things work better when plugged in

1 0

creating ZClass instances from an external method
by Gary Reynolds 15 Nov '00

15 Nov '00

I have a need to do some creating of objects from python code. Am I correct in thinking that to add a new object, that is one of my products, I need to do something like: folder.manage_addProduct['ProductName'](id='foo', title='bar') I have sample code to create simple things like using manage_addDTMLMethod, etc, but nothing for a product. The way I've got my data stored is in a combination of dictionaries and lists... it was an ugly enough process to export it - now importing it seems worse. Any help would be appreciated. Cheers, Gary -- Web Site Developer Faculty of Dentistry University of Sydney Ph: 02 9351 8350 garyr(a)dentistry.usyd.edu.au

2 1

RE: [Zope] ZGDChart product...
by Furbach, Andreas 15 Nov '00

15 Nov '00

Hello. The function _chartdata in ZGDchart.py returns only one label column and one data column. You may want to change this to: ********************************************************************* def _chartdata(self): """ return the first and second columns of sql query results as a pair of tuples """ rows = getattr(self, self.SQL)() # data[0] is list of labels data = [] start = 0 for row in rows: # each row is a list of fields # initialize empty lists for each column if start == 0: start = 1 for i in range(len(row)): data.append([]) # # Only insert rows with zero values if # it is not a pie chart # Pie Chart only makes sense with 1 data column # for i in range(len(row)): if (self.REQUEST['zgdchart_runtime_type'] != GDC_3DPIE and self.REQUEST['zgdchart_runtime_type'] != GDC_2DPIE) or row[1] != 0: # # Coerce the first field into a string # and other fields into a float # if i == 0: data[i].append( str (row[i])) else: data[i].append( float(row[i])) # # convert lists to tuples # apparently, gdchart.chart() accepts lists # as well, but I better check with # M Steed first. # # I just tried. return data **************************************************************************** *** and restart Zope, which worked for me. Andreas Furbach _______________________________________________________ EDS Informationstechnologie und Service GmbH Semerteichstr. 50-52 D-44141 Dortmund Tel.: 0231 / 944-1533 mailto: andreas.furbach(a)eds.com >Hi. > >This is really a great product. > >Unfortunately, I'm not able to create a chart with multiple columns using a >ZSQL Data Method. >Multiple columns with a DTML-Method works fine. > >Do I miss something. Any ideas? > >Thanks for any help. Regards, Marc Ludwig (zope(a)isp.lu)

1 0

DateTime problem
by Alejandro Pancani 15 Nov '00

15 Nov '00

if I have a string that represent a date with the format dd/mm/yyyy How could I do to obtain a DateTime object from it? Alejandro Pancani alejandrop1(a)topgroup.com.ar

2 1