- Zope - Zope lists

can't use a cast operator in a sql query
by Graham Chiu 28 Mar '00

28 Mar '00

I couldn't see this covered in the Zsql user's guide. select myfield from foo works as expected. As the current ODBC driver I am using has a bug which truncates varchar fields, it was suggested I cast it to char while retrieving the field. But select cast(my_varchar_field as char(140)) from foo gives an error with the following traceback... Zope Error Zope has encountered an error while publishing this resource. ValueError Sorry, a Zope error occurred. Traceback (innermost last): File D:\zope2\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\zope2\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\zope2\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: sqlTest) File D:\zope2\lib\python\ZPublisher\Publish.py, line 165, in publish File D:\zope2\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File D:\zope2\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_test) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 319, in manage_test (Object: sqlTest) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 300, in manage_test (Object: sqlTest) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 415, in __call__ (Object: sqlTest) File D:\zope2\lib\python\Shared\DC\ZRDB\RDB.py, line 151, in __init__ ValueError: Empty column name, Using 2.1.6 with the ODBC DA. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

2 1

RE: [Zope] How do I use the math module ?
by Marcus Collins 28 Mar '00

28 Mar '00

Hi The following snippet (tested) works as expected, printing the values in three columns. <dtml-var standard_html_header> <dtml-call "REQUEST.set('WordList', ['word_a', 'word_b', 'word_c', 'word_d', 'word_e', 'word_f', 'word_g'])"> <dtml-in WordList> <dtml-unless sequence-start> <dtml-if "_.math.fmod(_['sequence-index'], 3) == 0"> <br> </dtml-if> </dtml-unless> <dtml-var sequence-item> </dtml-in> <dtml-var standard_html_footer> hth, -- Marcus > Hi, > > I have a simple question - how do I use the fmod function in the math > module with dtml ? > > I've tried something like this(and a lot of variants): > > <dtml-if expr="_.math.fmod(x,y) == 0"> > do something > </dtml-if> > > > > What is it for: > > I have some words returned from a search which I want to be displayed > like this: > > word_a word_b word_c > word_d word_e word_f > word_g word_h word_i > > Thanks in advance. > > 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 > > _______________________________________________ > 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 ) >

2 1

Is Zope suitable?
by Anders Eriksson 28 Mar '00

28 Mar '00

Hello! I have some questions about Zope and I thought I ask them before spending alot of time reading the documentation. Can I install zope on a apache system WITHOUT being root? My ISP is running apache on a Solaris 5.6 system. I want to create a system that lets any user create his own User Data Record. The user data record will contain data about the user, e.g. Name, email address, etc. This record should only be editable by the user (and admin) with somekind of login. This user data must then be searchable! Listings on all or some of the data should be able to present in different sorting orders, e.g. Lastname, country, etc. Is Zope suited for this kind of system? Maybe someone already has created a system like this? // Anders -- Thought I could organize freedom how Scandinavian of me

3 2

How do I use the math module ?
by Anders Holmbech Nielsen 28 Mar '00

28 Mar '00

Hi, I have a simple question - how do I use the fmod function in the math module with dtml ? I've tried something like this(and a lot of variants): <dtml-if expr="_.math.fmod(x,y) == 0"> do something </dtml-if> What is it for: I have some words returned from a search which I want to be displayed like this: word_a word_b word_c word_d word_e word_f word_g word_h word_i Thanks in advance. 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

2 1

background image
by Murat Kasikcioglu 28 Mar '00

28 Mar '00

hi all, how can i use background image in dtml document? for example: .... <body background="<dtml-var "myimage>"> ... this syntax returns an error. thanks for your help. -- Murat Kasikcioglu Innova Consulting Company http://www.innovaconsulting.com

4 3

Curious FreeBSD problem: Too many open files in system
by John Hanna 28 Mar '00

28 Mar '00

Has anybody seen this before? I seriously doubt my maxusers setting is the problem -- this usually indicates an infinate openfile loop. Anyway, the short of it is that Zope isn't starting. I'm using FreeBSD 3.4 and Python 1.5.2. Thanks! John bash-2.03# ./start Mar 27 10:08:06 larryboy syslogd: /dev/console: Too many open files in system: Too many open files in system Mar 27 10:08:06 larryboy syslogd: /dev/console: Too many open files in system: Too many open files in system Mar 27 10:08:06 larryboy /kernel: file: table is full Mar 27 10:08:06 larryboy /kernel: file: table is full ------ 2000-03-27T17:08:09 PROBLEM(100) ZServer Computing default hostname ------ 2000-03-27T17:08:09 INFO(0) ZServer Medusa (V1.13.4.1) started at Mon Mar 27 10:08:09 2000 Hostname: larryboy.cproject.com Port:8080 ------ 2000-03-27T17:08:09 INFO(0) ZServer FTP server started at Mon Mar 27 10:08:09 2000 Authorizer:None Hostname: larryboy.cproject.com Port: 8021 ------ 2000-03-27T17:08:09 INFO(0) ZServer PCGI Server started at Mon Mar 27 10:08:09 2000 Unix socket: /usr/local/Zope-2.1.6-src/var/pcgi.soc ------ 2000-03-27T17:08:09 INFO(0) ZServer Monitor Server (V1.5) started on port 8099 Traceback (innermost last): File "/usr/local/Zope-2.1.6-src/z2.py", line 586, in ? pf = open(PID_FILE, 'w') IOError: [Errno 13] Permission denied: '/usr/local/Zope-2.1.6-src/var/Z2.pid'

2 1

RE: [Zope] Mailing traceback from standard_error_message
by Marcus Collins 28 Mar '00

28 Mar '00

Hi, The traceback is in error_tb -- try <dtml-var error_tb> Other variables that are defined for error messages are: error_type error_value error_message (may be null) Take a look at /standard_error_message for their usage. hth, -- Marcus > -----Original Message----- > From: Kevin Dangoor [mailto:kid@kendermedia.com] > Sent: 28 March 2000 03:03 > To: zope(a)zope.org > Subject: [Zope] Mailing traceback from standard_error_message > > > Is there a way to make standard_error_message email the > traceback? (I > have it emailing the error message, but I didn't know if > there is a variable > I can <dtml-var> to send the traceback.) > > Kevin > > > _______________________________________________ > 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 ) >

1 0

logical operator in dtml-if
by Matthew Parslow 28 Mar '00

28 Mar '00

I am doing some error checking with <dtml-if>, simply to check that some variables exist, however I can't seem to find a syntax that ZOPE agrees with to use AND. what I want to do: <dtml-if Var AND anothervar AND yetanothervar> render page <dtml-else> you have to enter details in all the fields </dtml-if> I know this is a messy way to do it, and I'd appreciate all suggestions. Thanks, Matthew Parslow

3 2

Including a bunch of binary files in Zope
by Jason Wong 28 Mar '00

28 Mar '00

Hi I've got a load of files (PDFs, TIFs) that needs to be accessible from within a Zope application. I need to be able to link to them so people can download them. What is the best way to go about it? If I add them into Zope (ie [Add new item]>[File]>[Browse]... etc is there an easier way of doing it? I've got hundreds of files to add and I don't want to do it using the HTML interface. If I have the files in directory outside of Zope how do I reference them? Bearing in mind I only need to link to them for download, no need for the information in the files to be accessible by Zope. thanks - Jason Wong Digital View Ltd 2201 Nanyang Plaza 57 Hung To Road Kwun Tong HONG KONG Tel: +852-2861-3615 Fax: +852-2520-2987 www.digitalview.com

3 3

mxDateTime and mxODBC
by Jay, Dylan 28 Mar '00

28 Mar '00

Has anyone got these linked in with Zope esp on NT? Perhaps its my lack of knowledge of python modules but I just can't seem to get past the DateTime name conflict. I've written a mxODBC DA but can't even get off first base with testing it.

1 0