August 2002 - Zope - Zope lists

Updating Multiple Database Records
by Michael 20 Aug '02

20 Aug '02

Is there a resource that explains how to update multiple ZODB records without have to edit each one individually? I've looked through the how-to's and did a search on Google, but can't seem to turn anything up. Michael

3 3

multiple mysql tables
by Jacob Behm 20 Aug '02

20 Aug '02

Hi, This may be more of a MySQL question than a Zope one. Is there an easy way to create multiple MySQL tables all in one shot without calling an outside shell script or something. >From what I've seen, MySQL can only accept one CREATE statement at a time. But I'd really like to put them all in one file. Thanks, Jacob

3 3

Sharing content between zope instances
by Mark Gibson 20 Aug '02

20 Aug '02

Is there an easy or suggested way of sharing specific content between zope instances? Thanks, Mark

3 2

Discussion Item
by Ashish Gautam 20 Aug '02

20 Aug '02

Hi all, When i have enabled discussion on any content type, then by default all the replies(Discussion Item) are visible to all the users. The replies dont go through a workflow. I want to apply workflow to these replies(discussion items). Any suggestion is most welcome, Ashish.

2 1

Date Time Problem
by zope 20 Aug '02

20 Aug '02

Hi I have been working using Pagetemplates,XML,python script and Postgres sql At times when I use a select statement to select values from a table in zope I get an error on the time variable. The error is : Error, Invalid Date-Time String: 2002-06-08 00:00:00+05 SQL used: select * from calendar order by cuser Traceback (innermost last): File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/zope/Zope-2.5.1/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/zope/Zope-2.5.1/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 328, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 306, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 421, in __call__ (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/db.py, line 205, in query File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/DA.py, line 120, in cast_DateTime File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 651, in __init__ File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 1022, in _parse Invalid Date-Time String: (see above) But at other times there is no error thrown .I rectify the error usually by checking the properties of the Database connection and saving the settings again.The error does nopt appear always only at times Couls you please tell me how I can avoid this error from creeping up.Because I have found that at some time or the other this error comes up and so far I have not been able to find a solution. Best Regards John Kunchandy

2 1

RE: [Zope] Uploading a file to a SQL DB
by Stuart Foster 20 Aug '02

20 Aug '02

Here is an example using ASP http://www.aspfree.com/aspnet/uploadimage.aspx Here is an article talking using PHP, http://www.phpbuilder.com/columns/william19990908.php3 I have used this one before. .NET also has a method to do this that works well. -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Tuesday, August 20, 2002 9:31 AM To: Stuart Foster Cc: zope(a)zope.org Subject: Re: [Zope] Uploading a file to a SQL DB How would you do ti with other scripting languages? Chris Stuart Foster wrote: > I am trying to upload a file to a database and store it in an image field. > I am using MS SQL as the server and am able to do it with other scripting > languages but have not been able to figure out how to do it with Zope. > > Does anyone have an example of how to do this? > > TIA > Stuart > > > _______________________________________________ > 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

Uploading a file to a SQL DB
by Stuart Foster 20 Aug '02

20 Aug '02

I am trying to upload a file to a database and store it in an image field. I am using MS SQL as the server and am able to do it with other scripting languages but have not been able to figure out how to do it with Zope. Does anyone have an example of how to do this? TIA Stuart

2 1

Dynamic content in ZPT
by Chetan Kumar 20 Aug '02

20 Aug '02

Hi all I have a form in ZPT which calls a python script which looks up a database to generate some data. Now, the data needs to appear in the same page in a table if the submit button is used. The problem here is to generate the <form method="post" action="GetProjectWiseDataPython"> further down the selection is made as <select name="ProjectName"> <option tal:repeat="options here/GetProjectsPython" tal:content="options/ProjectName">name</option> </select> </form> This is passed to GetProjectWiseDataPython. At the end of the page I need to put a condition "if data obtained from script" show the data obtained from GetProjectWiseDataPython Now, As I understand I need to tal:define="GotData here/GetProjectWiseDataPython" and later tal:content="GotData/Somedata" This is the error message I get while loading the page. *Error Type: TALESError * *Error Value: exceptions.AttributeError on ProjectName in "standard:'here/GetProjectWiseDataPython'", at line 52, column 1* This is not seen when I do not attempt to display the data. What is the way out ? TIA Chetan

4 5

user object - not AUTHENTICATED_USER
by Bryan C. Andregg 20 Aug '02

20 Aug '02

How does one create a user object based on an arbitrary username so that one can use methods like getRoles() or hasRoles() on it? -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

2 1

White paper for executives
by Gilles Lenfant 20 Aug '02

20 Aug '02

Hi, I'm looking for White Papers for executives (low sw engineering background) about Zope in English and/or French. Google didn't find anything interresting in that field. Thanks in advance for your URLs --Gilles

1 0