- Zope - Zope lists

Re: [Zope] feed ZSQL "select" to a multiple selection property
by Daniel Ajoy 01 Sep '03

01 Sep '03

Thanks but what I need is the opposite. I what the result of this: select field1 from table order by field1 be the posible values of a property of type "multiple selection" of an object. Daniel On 1 Sep 2003 at 13:30, David Hassalevris wrote: > Daniel, > Here is a snippet from some old zsql method. > --------------- > code -------------------------------------------------------- > select segment3,segment4, description from COA_DETAIL > where postflag = 1 and base_acct_type_id = 4 > and <dtml-sqltest accounts column="segment3" type="string" op="eq" multiple> > order by segment3,segment4 > > Notes: > . accounts is a list. In the parameters section I used accounts:list. > . I could not get this to work using zSql TEST. Try it from a method. > --------------------------------------------------------------------------- > ----- > David >

2 1

ZSyncer: last stable version
by Gérard Oogle 01 Sep '03

01 Sep '03

Hi, On http://www.zope.org/Members/andym/ZSyncer, the last version of Zsyncer is 0.4.6 and is 10 months old. Andym -the author?- also invites the visitor to pick the latest ZSyncer from CVS where there seems to have been changes committed less than 2 weeks ago. Which version should a newbie pick? Regards, -- Gérard

4 3

List Prolblems
by Philip Kilner 01 Sep '03

01 Sep '03

Hi All, In the last 24 hours, I have only seen five posts on this list. Is that correct, or is there a problem? TIA! -- Regards, PhilK Email: phil(a)xfr.co.uk / Voicemail & Facsimile: 07092 070518 "the symbols of the divine show up in our world initially at the trash stratum." Philip K Dick

1 0

feed ZSQL "select" to a multiple selection property
by Daniel Ajoy 01 Sep '03

01 Sep '03

How can I feed a ZSQL "select" to a multiple selection property? Daniel

1 0

Highlighting bad data fields in Formulator
by Tom P. Allred 31 Aug '03

31 Aug '03

Hi, It seems like I've seen this question in the mailing list before but couldn't find it when I searched. I'm currently using code from a Formulator example to display input errors to the user. Here is the code from the python 'formaction' script. # Here we'll catch errors try: result = context.dataform.validate_all(context.REQUEST) except FormValidationError, errlist: print "I'm sorry. Some of the information you entered was either incorrect or incomplete. Please use the "back" button and fill it in correctly. Thank you! " for error in errlist.errors: print '' + error.field.get_value('title') + ': '+ error.error_text + ' ' print '' return printed What I'd like to do instead is re-display the input form with highlighted (say red) field labels and a message at the top asking the user to fix the highlighted fields and re-submit. Here is the code displaying the fields, again taken from an example. It is defined in a macro called by the folder's index_html.  <table tal:define="form here/dataform" align=left>  <tr tal:repeat="itemz here/dataform/get_field_ids">  <th align="left">  Field Display Label : </th> <td>  <input type="text" name="itemz" tal:replace="structure python:fieldobj.render()"> </td> </tr> It seems like the 'formaction' script will need to set some values for the error fields that the ZPT will use to set their label color. Any suggestions on how to do this? Thanks, Tom P. Allred Tom(a)AllredData.com

1 0

VirtualLogMonster
by Michael Dexter 30 Aug '03

30 Aug '03

Hello, It turns out that VirtualHostMonster was exactly what I was looking for to set up simple virtual hosts with Zope. Any word on VirtualLogMonster so I can separate the log files from those virtual hosts? Thanks, MD.

2 1

Variables and SubFolders
by rpenatez＠lattice.com.co 30 Aug '03

30 Aug '03

Hello Zopistas! I'm trying to pass a variable value from the root folder to a subfolder but I can't. How can I do that??? Thanks for your help. RicardoP

2 1

2.7.0b2 install error
by Edward Muller 30 Aug '03

30 Aug '03

running the following... /opt/python/2.2.3/bin/python setup.py install --prefix=/opt/zope/2.7.0 warning: ZopeInstall: modules installed to '/opt/zope/2.7.0/lib/python/', which is not in Python's module search path (sys.path) -- you'll have to change the search path yourself running install running build running build_scripts Traceback (most recent call last): File "setup.py", line 1128, in ? distclass=ZopeDistribution, File "/opt/python/2.2.3/lib/python2.2/distutils/core.py", line 138, in setup dist.run_commands() File "/opt/python/2.2.3/lib/python2.2/distutils/dist.py", line 902, in run_commands self.run_command(cmd) File "/opt/python/2.2.3/lib/python2.2/distutils/dist.py", line 922, in run_command cmd_obj.run() File "setup.py", line 142, in run install.run(self) File "/opt/python/2.2.3/lib/python2.2/distutils/command/install.py", line 491, in run self.run_command('build') File "/opt/python/2.2.3/lib/python2.2/distutils/cmd.py", line 330, in run_command self.distribution.run_command(command) File "/opt/python/2.2.3/lib/python2.2/distutils/dist.py", line 922, in run_command cmd_obj.run() File "/opt/python/2.2.3/lib/python2.2/distutils/command/build.py", line 107, in run self.run_command(cmd_name) File "/opt/python/2.2.3/lib/python2.2/distutils/cmd.py", line 330, in run_command self.distribution.run_command(command) File "/opt/python/2.2.3/lib/python2.2/distutils/dist.py", line 922, in run_command cmd_obj.run() File "/opt/python/2.2.3/lib/python2.2/distutils/command/build_scripts.py", line 46, in run self.copy_scripts() File "/opt/python/2.2.3/lib/python2.2/distutils/command/build_scripts.py", line 55, in copy_scripts self.mkpath(self.build_dir) File "/opt/python/2.2.3/lib/python2.2/distutils/cmd.py", line 360, in mkpath self.verbose, self.dry_run) File "/opt/python/2.2.3/lib/python2.2/distutils/dir_util.py", line 35, in mkpath raise DistutilsInternalError, \ distutils.errors.DistutilsInternalError: mkpath: 'name' must be a string (got None) Anyone have any ideas? -- Edward Muller Interlix (http://www.interlix.com) Phone: 417-862-0573 - Cell: 417-844-2435 - Fax: 417-862-0572 Web Hosting - PC Service & Support - Custom Programming - Network Service & Support Specializing in Open Source Solutions

2 1

File types and OpenOffice documents (text)
by Gilles Lenfant 29 Aug '03

29 Aug '03

Hi, When uploading an OpenOffice text document ("foo.sxw") to a File object ("foo.sxw"), it's content type prop is set to "application/x-zip-compressed" !!! When downloading it with IE or Mozilla (Windows) it renames the file "foo.sxw.zip". The user has to rename it :-(. Is there a way to set the correct content type automatically at upload time (dunno which) and prevent renaming the file ? * Upload through Python scripts that detects those strnga behaviours and set the content type according to the file extension ? * Add a plugin to the File class to check the right type and set content type accordingly ? * Other ? I didn't test but this happens perhaps to other OpenOffice files too (spreadsheets, presentations...) Thanks in advance. --Gilles

2 1

Newbie Questions on ZODB Scale
by Robert B 29 Aug '03

29 Aug '03

I have recently discovered Zope and like what I see. I have some basic questions on how the object database scales. I come from a conventional RDBMS background... DB2 and Oracle. I would like to use the database for a content management solution, but I am worried about how the database will scale and perform. Where can I find documentation on how to administer the object database? Many of the links on http://www.zope.org on the ZODB are broken. My concern is that, based on my cursory look, it seems that the object database is stored in essentially one file on the file system. What happens when you outgrow that filesystem, or when you want to span disks in order to spread the load? Or, if I am expecting a large amount of files stored in the database, should I set up the server to store the files external to the object database? Any and all help would be appreciated, Robert

3 2