Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

2010-08-24 Thread Garry Saddington
Garry Saddington wrote: Andreas Jung wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would assume that you can use DTML-IN for looping and generating multiple SQL statements of the same kind. You have to ensure that the statements having a proper delimiter (there was something

Re: [Zope] Storing DTML in SQL

2010-08-18 Thread Garry Saddington
Justin Dunsworth wrote: I am currently working on a project where I am storing HTML within a MySQL database to display dynamic pages and content in sequences. I would like to be able to store DTML within the tables as well and be able to call them within the page to display that content. I

Re: [Zope] Storing DTML in SQL

2010-08-18 Thread Garry Saddington
Garry Saddington wrote: Justin Dunsworth wrote: I am currently working on a project where I am storing HTML within a MySQL database to display dynamic pages and content in sequences. I would like to be able to store DTML within the tables as well and be able to call them within the page

Re: [Zope] Storing DTML in SQL

2010-08-18 Thread Garry Saddington
Andrew Milton wrote: +---[ Garry Saddington ]-- | Garry Saddington wrote: | Justin Dunsworth wrote: | I am currently working on a project where I am storing HTML within a | MySQL database to display dynamic pages and content in sequences. I | would like

[Zope] Placeless Translation service

2010-08-08 Thread Garry Saddington
I am using PTS to translate our application and it works perfectly in every browser except IE8. Can anyone cast any light on why IE8 may not work? Regards garry ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No

[Zope] run raw sql

2010-07-27 Thread Garry Saddington
Is there any way to run raw sql statements from within a python script? Any help at all much appreciated. Thanks Garry ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related

[Zope] cookie crumbler

2010-06-18 Thread Garry Saddington
I have just been reading a Z2 log and have noticed that when I am logged in as a manager my username is displayed in the log, however when logged in using cookie crumbler as a normal user only 'Anonymous' appears as the user name in the log. Is there some way to make the correct user name

[Zope] javascript experts?

2010-05-22 Thread Garry Saddington
I am using some dynamic javascript to build form input controls and I have got everything working perfectly in all browsers except IE. The javascript uses square bracket notation to allow the phones.number:records to build multiple database input records for Zope. if

[Zope] cron like service

2010-05-05 Thread Garry Saddington
Can anyone suggest the easiest way to automatically have a python script fire at set times of the day/month/year. Regards Garry attachment: garry.vcf___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or

Re: [Zope] cron like service

2010-05-05 Thread Garry Saddington
Chris Withers wrote: Garry Saddington wrote: Can anyone suggest the easiest way to automatically have a python script fire at set times of the day/month/year. I just use Stepper and fire it from cron ;-) http://www.simplistix.co.uk/software/zope/stepper Chris Just got TimerService

Re: [Zope] javascript problem

2010-04-23 Thread Garry Saddington
Jaroslav Lukesh wrote: Did You have the number field in the hidden layer? - Original Message - From: Garry Saddington ga...@schoolteachers.co.uk I'm using the following javascript to gather phones:number values for form submission. for (var idx = 1; idx max; idx

Re: [Zope] javascript problem

2010-04-23 Thread Garry Saddington
Jaroslav Lukesh wrote: - Original Message - From: Jaroslav Lukesh luk...@seznam.cz I think that you have bad code - see your error message. So try somethong like: document.forms.playlist.phones.number[1] instead of document.forms.playlist.phones.number:records.1.value Oh,

[Zope] javascript problem

2010-04-22 Thread Garry Saddington
I'm using the following javascript to gather phones:number values for form submission. for (var idx = 1; idx max; idx++) { if (eval(document.forms.playlist['phones.number:records'][ + idx + ].value) 0) Has anyone got any idea why it works fine in every browser (Safari,FF,Chrome,Webkit) but

[Zope] preventing form submission

2010-02-02 Thread Garry Saddington
Has anyone any suggestions as to how to prevent form submission by the using pressing the refresh or back buttons? Garry ___ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related

[Zope] python help needed

2010-01-19 Thread Garry Saddington
I am trying to upload a csv file (called data) using the following script: i=0 d=data.readlines() for row in d: i+=1 a=row.split(',') if i 1: subjectid=a[0] entry=a[1] type=a[2] studentid=a[3] try:

Re: [Zope] python help needed

2010-01-19 Thread Garry Saddington
Andrew Milton wrote: +---[ Garry Saddington ]-- | I am trying to upload a csv file (called data) using the following script: | | i=0 | d=data.readlines() | for row in d: | i+=1 | a=row.split(',') | if i 1: | subjectid=a[0

[Zope] dynamically call zsqlmethod

2009-11-25 Thread Garry Saddington
I am passing a variable named 'column' to the following script and trying to fill a select box with the result of a zsqlmethod chosen dynamically using this variable. print select name=nonboolean method=post command=context.column() for row in command: code=row.code

Re: [Zope] dynamically call zsqlmethod

2009-11-25 Thread Garry Saddington
Jeff Peterson wrote: IF it's a variable passed to the script wouldn't you simply access it as 'column'? Also, is it a variable or a function? Or is the variable the name of a function somewhere? If it's the former just call it: column(). If it's the latter, Andreas should be correct,

Re: [Zope] zope2.zope.org launched

2009-10-01 Thread Garry Saddington
Andreas Jung wrote: I am pleased to announce the launch of a new website dedicated to the Zope 2 application server: zope2.zope.org This site gives the Zope 2 application a much better representation on the web (which was more than necessary after having lived for years with

[Zope] moving a zope install

2009-07-30 Thread Garry Saddington
Before I investigate any further perhaps someone here may be able to save me a little time. Is it possible to move a zope installation from one directory to another and have zope.conf pick up the correct paths dynamically? I've looked at the zope on a cd but I want the db to be writeable. Thanks

Re: [Zope] external method

2009-06-16 Thread Garry Saddington
Chris Withers wrote: Garry Saddington wrote: I have the following external method to back up a postgres database, using the following software versions. Why on earth would you not just do this in a cron job?! Chris Because I want the backup to be done manually, through

Re: [Zope] external method

2009-06-16 Thread Garry Saddington
Garry Saddington wrote: Chris Withers wrote: Garry Saddington wrote: Because I want the backup to be done manually, That doesn't seem like such a hot idea. Something that's easilly forgotten. Thanks, I've sorted it. Turns out that pg_dump was being run by SYSTEM

[Zope] external method

2009-06-15 Thread Garry Saddington
I have the following external method to back up a postgres database, using the following software versions. Zope Version (Zope 2.9.0, python 2.4.2, win32) Python Version 2.4.2 (#67, Sep 28 2005, 12:41:11) [MSC v.1310 32 bit (Intel)] System Platform win32 Zope is

[Zope] appending paths in zpt

2009-01-12 Thread Garry Saddington
I have this: tal:attributes=href here/getUserName in a link that works but I want to append a hard coded extension to it. How would I turn it into this and get it to work ? tal:attributes=href here/getUserName/listview?page=1000 Regards Garry ___ Zope

Re: [Zope] appending paths in zpt

2009-01-12 Thread Garry Saddington
On Monday 12 January 2009 20:45, Thibaud Morel l'Horset wrote: Sounds like you need to use a string: tal:attributes=href string:${here/getUserName}/listView?page=1000 Thanks that's done it Garry ___ Zope maillist - Zope@zope.org

[Zope] cron or time server

2008-12-27 Thread Garry Saddington
Does anyone know of a time/cron server for Zope that works. I want to be able to schedule a script to run every hour or so? Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML

Re: [Zope] problem with a form in IE 7

2008-12-15 Thread Garry Saddington
On Monday 15 December 2008 15:04, Peter Bengtsson wrote: 2008/12/15 ga...@schoolteachers.co.uk: Quoting Peter Bengtsson pete...@gmail.com: Has nothing to do with Zope but... Use Firefox to debug it and you'll get to see the error. put method=post on form tag and the submission won't be

Re: [Zope] sorting ids in python

2008-12-09 Thread Garry Saddington
On Tuesday 09 December 2008 03:15, Andreas Jung wrote: On 08.12.2008 21:11 Uhr, robert rottermann wrote: Garry Saddington schrieb: Can anyone help me sort the following by id in a python script? for object in context.objectValues(['Folder', 'DTML Document','ZipFolder','File','Image

[Zope] sorting ids in python

2008-12-08 Thread Garry Saddington
Can anyone help me sort the following by id in a python script? for object in context.objectValues(['Folder', 'DTML Document','ZipFolder','File','Image']): Import of sequence is not authorised in my python scripts, I am presuming (probably wrongly) that sequence is needed for sort. Regards

[Zope] Obtaining user name in python

2008-11-27 Thread Garry Saddington
I can do this in DTML: dtml-var _.SecurityGetUser().getUserName() but I want to do it from a Python script, where the use of the underscore is not allowed. Can anyone point me in the correct direction? Regards Garry ___ Zope maillist - Zope@zope.org

Re: [Zope] Was Problem using nested dtml-in with zsql

2008-11-09 Thread Garry Saddington
On Saturday 08 November 2008 21:59, Tim Nash wrote: +1 Well spoken. It is painful to see all the cheers for django templates when dtml has been around longer and is just as good, maybe better. Just had a look. They do the same as dtml but with less functionality. Amusing that something that is

Re: [Zope] Was Problem using nested dtml-in with zsql

2008-11-08 Thread Garry Saddington
On Saturday 08 November 2008 06:21, Andreas Jung wrote: Any particular reason for using DTML instead of ZPT? DTML is dead. Firstly let me say that I do not wish to relight the ZPT vs DTML argument, only to make a few points. I find this an extraordinary attitude coming from someone so important

[Zope] zope's clipboard

2008-10-27 Thread Garry Saddington
Is there a way to programmatically remove items from the clipboard. Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists -

Re: [Zope] zope's clipboard

2008-10-27 Thread Garry Saddington
On Monday 27 October 2008 17:37, Andreas Jung wrote: On 27.10.2008 18:05 Uhr, Garry Saddington wrote: Is there a way to programmatically remove items from the clipboard. There nothing like a clipboard. The information you consider as clipboard is stored as __cp cookie on the client side. OK

Re: [Zope] zope's clipboard(solved)

2008-10-27 Thread Garry Saddington
On Monday 27 October 2008 18:35, Garry Saddington wrote: On Monday 27 October 2008 17:37, Andreas Jung wrote: On 27.10.2008 18:05 Uhr, Garry Saddington wrote: Is there a way to programmatically remove items from the clipboard. There nothing like a clipboard. The information you consider

Re: [Zope] .html from python

2008-10-17 Thread Garry Saddington
On Friday 17 October 2008 21:30, Andrew Milton wrote: +---[ Garry Saddington ]-- | How would I do this: | | dtml_method = context.singleitemview.html | s = | return s dtml_method = getattr(context, 'singleitemview.html') return dtml_method(client=context, REQUEST

[Zope] changing permissions in python

2008-10-13 Thread Garry Saddington
I have been searching everywhere for the correct syntax to use to change permissions on a dtml method from a python script. I know it could be using manage_changePermissions() but exactly how can I call it on any method. Regards Garry ___ Zope maillist

[Zope] remote authentication

2008-08-31 Thread Garry Saddington
Is there a way to have two separate zope instances on different machines and have them both authenticate against one acl_users folder on only one of these machines? regards garry ___ Zope maillist - Zope@zope.org

Re: [Zope] remote authentication

2008-08-31 Thread Garry Saddington
On Sunday 31 August 2008 15:10, Andreas Jung wrote: --On 31. August 2008 15:01:24 +0100 Garry Saddington [EMAIL PROTECTED] wrote: Is there a way to have two separate zope instances on different machines and have them both authenticate against one acl_users folder on only one

Re: [Zope] remote authentication

2008-08-31 Thread Garry Saddington
On Sunday 31 August 2008 15:31, Andreas Jung wrote: --On 31. August 2008 15:38:38 +0100 Garry Saddington [EMAIL PROTECTED] wrote: On Sunday 31 August 2008 15:10, Andreas Jung wrote: --On 31. August 2008 15:01:24 +0100 Garry Saddington [EMAIL PROTECTED] wrote: Is there a way to have

[Zope] iterating over result sets in python

2008-08-24 Thread Garry Saddington
I am trying to iterate over a result set from a zsql method in a python script in Zope 2. In the results is a date field. What I want to do is test whether a date is younger than the date in the previous row by at least 30 days but I am having problems working out how, not coming from a

[Zope] python split

2008-08-17 Thread Garry Saddington
Is it possible to split a string at the first occurence of a non-digit character using a python script in zope, or does this need an external method for security purposes? regards garry ___ Zope maillist - Zope@zope.org

Re: [Zope-DB] Calling SQL Query in DTML Method with a string argument

2008-07-28 Thread Garry Saddington
On Monday 28 July 2008 15:59, Matylda Sawicka wrote: Hello, I am a fresh Zope Explorer. I was trying to call an SQL Query that requires an argument in a DTML Method that would be called with an argument passed in the URL. The Query looks more or less like this: SELECT Uni_Name,

[Zope] CMF content types

2008-07-23 Thread Garry Saddington
I would like to use ZipFolder as an addable type in a CMF site. All the documentation I can find is either out of date or confusing. Can anyone help by pointing me to some accurate documentation on this subject. regards Garry ___ Zope maillist -

Re: [Zope] Bug in ZSQL test?

2008-07-10 Thread Garry Saddington
On Thursday 10 July 2008 20:47, Allen Schmidt Sr. wrote: I know, I know...too old to worry about... Zope 2.8.9.1 on RedHat and MySQL5 In the Test tab of a ZSQL method, where the query has parameters, when we enter parameters that generate a result of more than 20 rows, we get the link for

Re: [Zope] zope stops responding

2008-07-05 Thread Garry Saddington
Thanks for all your help. I have solved the problem with the Deadlock Debugger which showed up threads locked by a call to Aspell. Re-installing Aspell was the solution. I was very impressed with this product and all your assistance. Thanks again Garry

[Zope] zope stops responding

2008-07-03 Thread Garry Saddington
Following a hard disk crash 2 weeks ago we have installed Zope onto a new server and all was fine until yesterday morning when Zope stopped responding and required a restart to get it working. It did the same at 3-30pm today. We are using Zope 2.9.0 on Centos 5.1 on a quad Zeon server with 4gb.

Re: [Zope] unicode support

2008-06-27 Thread Garry Saddington
On Friday 27 June 2008 00:23, Peter Bengtsson wrote: I would advice against relying on default-zpublisher-encoding. I never used that. By specifying the encoding like this variablename:utf8:ustring you override whatever default-zpublisher-encoding was set to. If you rely on

Re: [Zope] unicode support

2008-06-27 Thread Garry Saddington
On Friday 27 June 2008 05:38, Andreas Jung wrote: --On 26. Juni 2008 22:05:06 + Garry Saddington [EMAIL PROTECTED] wrote: On Thursday 26 June 2008 15:12, Andreas Jung wrote: --On 26. Juni 2008 14:09:50 + Garry Saddington [EMAIL PROTECTED] wrote: I am using Zope 2.9 connected

Re: [Zope] unicode support

2008-06-27 Thread Garry Saddington
On Friday 27 June 2008 07:42, Andreas Jung wrote: --On 27. Juni 2008 06:42:28 + Garry Saddington [EMAIL PROTECTED] wrote: On Friday 27 June 2008 05:38, Andreas Jung wrote: --On 26. Juni 2008 22:05:06 + Garry Saddington [EMAIL PROTECTED] wrote: On Thursday 26 June 2008 15:12

[Zope] unicode support

2008-06-26 Thread Garry Saddington
I am using Zope 2.9 connected to a Posgres DB via psycopg. My database encoding is UTF8. I am getting the following error when users try to insert text in the database containing £ signs: ERROR: invalid byte sequence for encoding UTF8: 0xa3 This is due to the encoding of a £ sign in the text

Re: [Zope] unicode support

2008-06-26 Thread Garry Saddington
On Thursday 26 June 2008 15:12, Andreas Jung wrote: --On 26. Juni 2008 14:09:50 + Garry Saddington [EMAIL PROTECTED] wrote: I am using Zope 2.9 connected to a Posgres DB via psycopg. My database encoding is UTF8. I am getting the following error when users try to insert text

Re: [Zope] UTF8 encoding

2008-06-18 Thread Garry Saddington
On Wednesday 18 June 2008 07:56, Tino Wildenhain wrote: Hi Garry, Garry Saddington wrote: I am getting a few of this type of error only coming from Windows machines, does anyone know how to sort this out? ProgrammingError: ERROR: invalid byte sequence for encoding UTF8: 0xa3 HINT

[Zope] UTF8 encoding

2008-06-17 Thread Garry Saddington
I am getting a few of this type of error only coming from Windows machines, does anyone know how to sort this out? ProgrammingError: ERROR: invalid byte sequence for encoding UTF8: 0xa3 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server,

[Zope] dtml-tree documentation

2008-05-25 Thread Garry Saddington
Is there a complete documentation of the dtml-tree tag anywhere? The dtml reference of the Zope book has the following for some options: This attribute is for advanced usage only Where can I find out about this 'advanced usage'? Regards Garry ___ Zope

[Zope] centos

2008-05-13 Thread Garry Saddington
Does anyone have any experience running Zope on Centos 5. I have some Python scripts which just will not work. They work on Windows, Ubuntu, and SuSe but just don't do anything on Centos. I have tried various Zope 2.9.0 and 2.9.6-final, various psycopg connectors and Postgres 8.1 and 8.3. Here

Re: [Zope] centos

2008-05-13 Thread Garry Saddington
On Tuesday 13 May 2008 08:09, Andreas Jung wrote: --On 13. Mai 2008 08:14:05 +0100 Garry Saddington [EMAIL PROTECTED] wrote: Does anyone have any experience running Zope on Centos 5. I have some Python scripts which just will not work. They work on Windows, Ubuntu, and SuSe but just

[Zope] disappearing external methods

2008-05-07 Thread Garry Saddington
I have recently moved our Zope installation over to a centos server. Since the move all the external methods periodically stop working for no apparent reason and the error is returned as: external method can not be called because it is none The thing is that it works well and then stops. Does

Re: [Zope] disappearing external methods

2008-05-07 Thread Garry Saddington
On Wednesday 07 May 2008 16:54, Jonathan wrote: - Original Message - From: Garry Saddington [EMAIL PROTECTED] To: zope@zope.org Sent: Wednesday, May 07, 2008 11:52 AM Subject: [Zope] disappearing external methods I have recently moved our Zope installation over to a centos server

Re: [Zope] Re: disappearing external methods

2008-05-07 Thread Garry Saddington
On Wednesday 07 May 2008 18:13, Josef Meile wrote: Garry Saddington schrieb: Have you tried deleting the .pyc files associated with the external methods and then restarting zope? There are no .pyc files in any of our installations. Have you used the Zope that comes with Centos or from

[Zope] try clause in external method

2008-04-14 Thread Garry Saddington
I have the following external method which takes an input .csv file and enters the data into a database by calling a ZSQL method. There may be errors in the input file and so I am trying to catch them and insert each bad row in a different table. The errors are detected by table constraints on

[Zope] type checking

2008-04-14 Thread Garry Saddington
Is there any way to do data type checking in dtml-if, for example to check that a variable is an integer? regards garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related

[Zope] how many zope instances

2008-04-04 Thread Garry Saddington
I have tried to find information on how many Zope instances can be run on a single machine but all searches have failed to be definitive. Is there any information on this, because I would like to have a separate instance for each of my customers running on a different port number and it would

Re: [Zope] how many zope instances

2008-04-04 Thread Garry Saddington
On Friday 04 April 2008 16:38, Andreas Jung wrote: --On 4. April 2008 16:33:48 +0100 Garry Saddington [EMAIL PROTECTED] wrote: I have tried to find information on how many Zope instances can be run on a single machine but all searches have failed to be definitive. Is there any

Re: [Zope] silly DTML question: in test

2007-11-28 Thread Garry Saddington
if foo in (select foo_col from table where x=y) then z='t' else z='f' I tried putting the simple SELECT query into a zSql and then calling it like: dtml-call REQUEST.set('foo_list',IfShowNextDoor()) dtml-if expr=foo in foo_list dtml-call REQUEST.set('z','t') dtml-else

Re: [Zope] Frustrated with Python and Frameworks. Zope, Grok, Django, CherryPy

2007-11-27 Thread Garry Saddington
On Tuesday 27 November 2007 17:19, Martijn Faassen wrote: We need to identify some targets and see what resources we have to accomplish them. Of course this shouldn't degenerate into a long wishlist discussion, but let's see what kind of steps can be taken. I came to Zope as a newbie about 4

[Zope] bounties

2007-11-10 Thread Garry Saddington
How would I go about offering bounties to Zope developers? Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists -

Re: [Zope] running pg_dump on windows as external method

2007-10-26 Thread Garry Saddington
On Friday 26 October 2007 05:24, Andreas Jung wrote: --On 25. Oktober 2007 22:48:42 +0100 Garry Saddington [EMAIL PROTECTED] wrote: I am using zope on windows with an external python method to backup my database. I am struggling to run the following command: pg_dump.exe database file

[Zope] running pg_dump on windows as external method

2007-10-25 Thread Garry Saddington
I am using zope on windows with an external python method to backup my database. I am struggling to run the following command: pg_dump.exe database file I have tried using os.popen - no luck and also subprocess.Popen. eg: import subprocess        

Re: [Zope] sql and auto generated forms

2007-09-16 Thread garry saddington
On Sun, 2007-09-16 at 09:24 +0200, Dieter Maurer wrote: Jaroslav Lukesh wrote at 2007-9-14 19:50 +0200: I looking for such a tool, for which I define table columns and this tool generates SQL create,insert, update, select ZSQL methods and generate forms with methods for insert, update and

Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread garry saddington
On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: is there an easy way to make the following ZSQL query case-insensitive? select * from clients dtml-sqlgroup where dtml-sqltest firstname op=like type=string optional dtml-or dtml-sqltest lastname op=like type=string optional

[Zope] dtml method contents

2007-08-30 Thread garry saddington
I found this method on Zopelabs to get the contents of all ZSQL methods. dtml-in ZopeFind(restrictedTraverse(['']), obj_metatypes=['DTML Method'], search_sub=1) h2dtml.-id; (dtml.-title_or_id;)/h2 pidtml-var absolute_url/i/p blockquotepredtml-var template/pre/blockquote /dtml-in Is it

[Zope] htmldoc problem

2007-07-15 Thread Garry Saddington
I am using the following external method to write pdf files. import subprocess def html2pdf(self,source): f=open('/opt/scholarpack/ancillary/pdf.html','w') f.write(source) f.close p=subprocess.Popen(['htmldoc', '--webpage', '/opt/scholarpack/ancillary/pdf.html','-f',

[Zope] html2pdf

2007-07-12 Thread Garry Saddington
I am trying to use html2pdf and htmldoc to generate pdfs on the fly. I can get it to work perfectly if I set all view permissions for anonymous. However, this is not suitable for a member only site. Can anyone point me in the right direction for such use? I am using: (Zope 2.9.0,

Re: [Zope] Re: html2pdf

2007-07-12 Thread Garry Saddington
On Thursday 12 July 2007 18:19, Maurits van Rees wrote: Garry Saddington, on 2007-07-12: I am trying to use html2pdf and htmldoc to generate pdfs on the fly. I can get it to work perfectly if I set all view permissions for anonymous. However, this is not suitable for a member only site. Can

[Zope] datetime format

2007-03-04 Thread Garry Saddington
I have 'datetime-format international' set in zope.conf but the date output is still rendered in the format (y,m,d) when using ZopeTime or when returning dates from python scripts. How can I change this behaviour? My server config is: Zope Version (Zope 2.9.0, python 2.4.2, win32)

Re: [Zope] datetime format

2007-03-04 Thread Garry Saddington
On Sunday 04 March 2007 13:32, Andreas Jung wrote: --On 4. März 2007 12:45:20 + Garry Saddington [EMAIL PROTECTED] wrote: I have 'datetime-format international' set in zope.conf but the date output is still rendered in the format (y,m,d) Reading helps.. Yes, indeed it does, how did

[Zope] frameset problems

2007-02-21 Thread Garry Saddington
I have this page: frameset rows=75%,25% frame src=dtml-var page frame src=dtml-call expr=getproperty(page=_['page']) /frameset The 'page' variable is in the request but no matter what I try I am having problems passing it the the python script 'getproperty'. Can anyone point me in the

[Zope] add user from python problem

2007-02-15 Thread garry saddington
The following script adds a new folder with a user folder inside it and then adds a user to the user folder. It works fine but the new user is unable to log in until I go to the ZMI and go to change the user password. I do not need to do anything more than press the change button on this page for

Re: [Zope] add user from python problem

2007-02-15 Thread garry saddington
On Thu, 2007-02-15 at 18:58 +0100, Andreas Jung wrote: --On 15. Februar 2007 17:34:10 + garry saddington [EMAIL PROTECTED] wrote: roles='Manager' As the name 'roles' indicates you have to specify a sequence of roles and not a *single* one. -aj Thanks this has

Re: [Zope] add user from python problem

2007-02-15 Thread garry saddington
On Thu, 2007-02-15 at 19:35 +0100, Andreas Jung wrote: --On 15. Februar 2007 18:31:46 + garry saddington [EMAIL PROTECTED] wrote: On Thu, 2007-02-15 at 18:58 +0100, Andreas Jung wrote: --On 15. Februar 2007 17:34:10 + garry saddington [EMAIL PROTECTED] wrote

Re: [Zope-DB] Please help me about driver adapter

2007-02-15 Thread garry saddington
On Fri, 2007-02-16 at 07:38 +0100, robert rottermann wrote: I do not think any one of us can help you unless you tell us what exactly your problem with installing pymssql ist. by the way: do you mean MySQLdb? there is very good documentation on using Z SQL in the zope book:

[Zope] python script syntax

2007-02-14 Thread garry saddington
I want to do something like this in a script: forms='7L' context.forms.manage_addFolder('filey') ie. substitute the variable 'forms' for the correct value but I can not get the syntax correct, can anyone help? regards garry ___ Zope maillist -

Re: [Zope] zope sql_delimiter windows

2006-12-27 Thread garry saddington
On Sun, 2006-12-24 at 21:00 +0100, Dieter Maurer wrote: garry saddington wrote at 2006-12-23 22:26 +: I have a Zope application that runs perfectly on Linux. However, my target audience is likely to use Windows so I am trying to port my app. to that platform. Whenever I use a multiple

Re: [Zope] zope sql_delimiter windows

2006-12-24 Thread garry saddington
On Sat, 2006-12-23 at 23:39 +0100, Jaroslav Lukesh wrote: Does run your multiple INSERT queries at Database Adapter Test tab? None of them run (and I have many) from the test tab as I collect the data from a web form using the :records structure. Regards Garry

Re: [Zope] zope sql_delimiter windows

2006-12-24 Thread garry saddington
Andreas Jung wrote: Please read this: http://opensource.zopyx.com/helpcenter/misc/writing-smart-and-reasonable-postings-or-how-to-use-a-mailinglist/view If there had been anything else to send I would have. I thought the question was quite clear: Is there an issue with sql_delimiter on

Re: [Zope] zope sql_delimiter windows

2006-12-24 Thread garry saddington
On Sun, 2006-12-24 at 16:10 +0100, Andreas Jung wrote: -BEGIN PGP SIGNED MESSAGE- OK, sorry for the lack of info. What happens is that Zope stops responding when I fire off a ZSQL method containing a 'sql_delimiter' and then I get the standard Windows message: python.exe has encountered a

[Zope] zope sql_delimiter windows

2006-12-23 Thread garry saddington
I have a Zope application that runs perfectly on Linux. However, my target audience is likely to use Windows so I am trying to port my app. to that platform. Whenever I use a multiple insert Zsql method that includes sql_delimiter, python.exe crashes. eg. dtml-in att dtml-var sql_delimiter

Re: [Zope] external method strangeness

2006-10-19 Thread garry saddington
On Wed, 2006-10-18 at 15:07 -0400, Paul Winkler wrote: On Wed, Oct 18, 2006 at 06:13:38PM +0100, garry saddington wrote: Can anyone explain what is happening here. I am using Saxon to transform an xml file(source) using a stylesheet(style) the result is then written to Postgres

[Zope] external method strangeness

2006-10-18 Thread garry saddington
Can anyone explain what is happening here. I am using Saxon to transform an xml file(source) using a stylesheet(style) the result is then written to Postgres. The contents of source are uploaded in Zope and passed to the external method as a string. When I run this external method: import

[Zope] zope 3 psycopda

2006-08-12 Thread garry saddington
I am trying to install psycopda for zope 3 by following the instructions in the readme file with the svn checkout of this product and I get the following error when starting Zope. I have tried searching for rdb module but have not found anything of use. I am using Zope 3 as installed by Ubuntu.

[Zope] os module on different os's

2006-05-30 Thread garry saddington
I have a Zope application that runs on WinXP and Debian sarge without problems. I am using os.popen and popen2 to run locally installed applications and use their output in Zope (particularly aspell and diction). On Ubuntu Dapper and FC5 however, these os calls fail. Is there a problem with recent

Re: [Zope] windows python differences

2006-05-19 Thread garry saddington
On Fri, 2006-05-19 at 06:06 +0200, Andreas Jung wrote: --On 18. Mai 2006 23:21:50 +0100 garry saddington [EMAIL PROTECTED] wrote: hrows a string index out of range at the sentence[0] constructs. the popen command on windows is: ispell=os.popen(echo +word+ \scholarpack\ancillary

Re: [Zope] windows python differences

2006-05-19 Thread garry saddington
On Fri, 2006-05-19 at 09:01 +0200, Tino Wildenhain wrote: garry saddington wrote: This code on linux works without a problem ispell = os.popen(echo + word + | /opt/scholarpack/ancillary/ispell/bin/ispell -a) ispell.readline sentence = ispell.readline() What if the word is like

[Zope] windows python differences

2006-05-18 Thread garry saddington
This code on linux works without a problem ispell = os.popen(echo + word + | /opt/scholarpack/ancillary/ispell/bin/ispell -a) ispell.readline sentence = ispell.readline() if (sentence[0] == ''): parts = string.split(sentence, : ) gluedwords = parts[1] words =

Re: [Zope] now learning zpt

2005-10-19 Thread Garry Saddington
Chris Withers wrote: Hi Gary, Garry Saddington wrote: Having had a bit of a lambasting over my use of dtml, I have started to learn zpt. Congratulations, welcome to the zLight ;-) However, I am curious about the following: How do you do the equivalent of name=comp.name:records

[Zope] now learning zpt

2005-10-18 Thread Garry Saddington
Having had a bit of a lambasting over my use of dtml, I have started to learn zpt. However, I am curious about the following: How do you do the equivalent of name=comp.name:records to submit multiple values to zsql or to a python script, especially when the initial list is generated

Re: [Zope] selected in select lists

2005-10-14 Thread Garry Saddington
Chris Withers wrote: Garry Saddington wrote: DTML: select name=groupabbrev dtml-in getpastoralgroups option value=dtml-var thisgroupabbrev dtml-if expr=groupabbrev==_.str(thisgroupabbrev) selected/dtml-if dtml-var thisgroupabbrev/option /dtml-in /select And just for comparison, here's

Re: [Zope] selected in select lists

2005-10-14 Thread Garry Saddington
Tino Wildenhain wrote: Am Freitag, den 14.10.2005, 20:03 +0100 schrieb Garry Saddington: Chris Withers wrote: Garry Saddington wrote: DTML: select name=groupabbrev dtml-in getpastoralgroups option value=dtml-var thisgroupabbrev dtml-if expr=groupabbrev==_.str

[Zope] selected in select lists

2005-10-12 Thread Garry Saddington
I have a variable called 'groupabbrev' in the REQUEST. I am trying to automatically select an option in a select list based on this variable. I have tried this code and many others, and many googles but have not found anything that works. Can anyone see what I am doing wrong? select

  1   2   >