- Zope - Zope lists

RE: [Zope] setting 'arguments' string dynamically in a ZSQL metho d
by Chas Wareing 08 Jun '01

08 Jun '01

Holger- this still appears to have fixed variable names- my variable names are dynamic, based on sql column names so I can't predefine their existance in the ZSQL 'arguments' box- this is my qryInsert object as of tonight (this morning) - it would work in the proper namespace- field is a sql column, as in 'firstname' or 'address'. _[field] is then its value, which is set in a previous http post form- the ZSQL method bombs out when it can't see the post variables INSERT into <dtml-var sqlvarTable> ( <dtml-in "qryShowColumns(sqlvarTable=sqlvarTable)"> <dtml-if sequence-end> <dtml-var field> <dtml-else> <dtml-var field>, </dtml-if> </dtml-in> ) VALUES ( <dtml-in "qryShowColumns(sqlvarTable=sqlvarTable)"> <dtml-if sequence-end> <dtml-sqlvar "_[field]" type=string> <dtml-else> <dtml-sqlvar "_[field]" type=string>, </dtml-if> </dtml-in> ) Chas. -----Original Message----- From: Holger Lehmann [mailto:lehmann@catworkx.de] Sent: Friday, June 08, 2001 3:38 AM To: Chas Wareing; 'zope(a)zope.org' Subject: Re: [Zope] setting 'arguments' string dynamically in a ZSQL method Hi Chas, why not trying this: (assuming three hardcoded parameters) <dtml-in "YourSQLMethod(param1=value1,param2=value2,param3=None)"> and another time: <dtml-in "YourSQLMethod(param1=value5,param2=_['variable10'],param3=value4)"> with something like this in your ZSQLMethod: params: param1, param2, param3 sql (warning untested): <dtml-if "param3!='None'"> select * from foo where ..... <dtml-else> select * from bar where .... </dtml-if> **and** set the advanced setting " max rows retreived " to 0 (zero) to stop the ZSQLMethod from appending SQL code to your statement dynamically. - Holger Am Freitag, 8. Juni 2001 11:58 schrieb Chas Wareing: > I've been spending way too much time on this-- > > I'd like to set the 'arguments' string while calling a ZSQL method > instead of hardcoding it on the method- my variable names are dynamic > > a namespace hack or zsql product patch would be appreciated- > > I'm using this for a generic/reusable qryInsert object- > > Chas. <c3w(a)ISP.NET> > ISP Networks, Inc. > > _______________________________________________ > 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 ) -- ----------------------------------- catWorkX GmbH Dipl.-Ing. Holger Lehmann Stresemannstr. 364 22761 Hamburg Tel: +49 (0700) catWorkX Tel: +49 (40) 890 646-0 Fax: +49 (40) 890 646-66 mailto:lehmann@catworkx.de http://www.catworkx.de http://www.catbridge.de

2 1

PythonScript -> List item is out of range
by olpa＠sybcom.de 08 Jun '01

08 Jun '01

Hi: I wrote this PythonScript: s1 = { 'a': 1, 'b': 0 } s2 = { 'a': s1['a'] and s1['b'] } return s2 and Zope does not accept this. Zope returns directly a list item is out of range... When I replace the 'and' by '+', then everything is ok! How to do ? --- "I suppose if we couldn't laugh at things that don't make sense, we couldn't react to a lot of life." -Hobbes --- Oliver Pabst .-------------------------. mailto:olpa@sybcom.de : : phone :+49 681 56600600 : project department : SYBCOM GmbH fax :+49 681 56600660 : : http://www.sybcom.de

3 3

Re: [Proiektor] Setup Dependencies
by Sherwood Robinson 08 Jun '01

08 Jun '01

Sure not a problem I changed the _pg line to look like this _pg pgmodule.c -I/usr/include/postgresql -L/usr/include/postgresql/lib -lpq # -lcrypt # worked great. Now if I can just get this module to work in zope... 8^) getting closer every minute of each day... 8^) At 02:56 PM 6/7/2001 -0700, you wrote: >could you post the modifications you made to the setup file to get it to >compile under cygwin? i'm not having any luck. >Thanks > >At 05:05 PM 6/7/01 -0400, you wrote: >>At 09:49 AM 6/7/2001 -0500, Stephan Richter wrote: >>>or Zope <proiektor.imail.iuveno-net.de> >>>List-Unsubscribe: <http://imail.iuveno-net.de/mailman/listinfo/proiektor>, >>> <mailto:proiektor-request@imail.iuveno-net.de?subject=unsubscribe> >>>List-Archive: <http://imail.iuveno-net.de/pipermail/proiektor/> >>>Date: Thu, 07 Jun 2001 09:49:56 -0500 >>> >>>At 08:14 AM 6/7/01, Sherwood Robinson wrote: >>>>Hello I downloaded 0.4.0 and have started to install it. >I found that >>>>on a new Zope there are many dependencies that need to be >>>>installed. One that particularly has me slightly unsure what I am >>>>looking for is the Zope PostgreSQLDA requirement. >>>Yeah, there are some requirements. But I feel better by using standard >>>Zope Products. I do not have to maintain as much code. ;-) >>> >>>>I have found 2 Zope PostgreSQL type objects >>>>ZPyGreSQLDA >>>>and >>>>ZPoPyDA >>>I developed it for ZPyGreSQLDA. ZPoPyDA works differently with booleans. >>> >>>>My first Question is one of these the ProstgreSQL DA object I need? and >>>>please Identify it. >> >>>ZPyGreSQLDA >>> >>>>The second question I must ask is has anyone set up this to work on a >>>>Windows Environment? >>>Oh, I do not know of anyone. It works under Linux and Solaris so far. >>> >>>>I have tried to compile with CYGWIN but neither are doing the job. >>>I have compiled PostGreSQL with CYGWIN before, but I do not know about >>>the ZPyGres and ZPyGreSQLDA. Has anyone else more experience? It would >>>be cool, if we could port it to Windows. Then we could offer Offline >>>functionality! >> >>CygWin has PostGreSQL pre-compiled for it now so that wasn't the >>problem. I got ZPyGreSQLDA compiled but it is not working correctly. I >>am getting this error when it tries to load the product >> >>Traceback (innermost last): >> File "C:\Zopes\swlw001\lib\python\OFS\Application.py", line 528, in >> import_produ >cts >> product=__import__(pname, global_dict, global_dict, silly) >> File "C:\Zopes\swlw001\lib\python\Products\ZPyGreSQLDA\__init__.py", >> line 89, in ? >> import sys, os, Globals, DA >> File "C:\Zopes\swlw001\lib\python\Products\ZPyGreSQLDA\DA.py", line >> 91, in ? >> from db import DB >> File "C:\Zopes\swlw001\lib\python\Products\ZPyGreSQLDA\db.py", line >> 89, in ? >> import _pg, regex, sys, types >>ImportError: No module named _pg >> >>I also compiled it with Phython 2.1 because that is what is in CygWin and >>I just wanted to see if it would work. But even though I compiled the >>ZPyGreSQLDA and placed it in the correct folder I still get this error. >> >>I am going to cross post this into the zope(a)zope.org list also. >> >>SR >> >> >>>Regards, >>>Stephan >> >>> >>>Stephan Richter >>>iuveno AG - Technical Design and Implementation >>>Technical Design and Development >>> >>>_______________________________________________ >>>Proiektor mailing list >>>Proiektor(a)imail.iuveno-net.de >>>http://imail.iuveno-net.de/mailman/listinfo/proiektor >> >>---------------------------------------------------- >>Sherwood Robinson >>Hostmaster >>The Free Lance-Star/Internet Department >>srobinson(a)fredericksburg.com >>http://www.fredericksburg.com >> >>616 Amelia St. >>Fredericksburg, VA 22401 >>540-374-5000 ext. 5657 >> >> >>_______________________________________________ >>Proiektor mailing list >>Proiektor@ima >il.iuveno-net.de >>http://imail.iuveno-net.de/mailman/listinfo/proiektor > >---------------------------------------------------- >Sherwood Robinson >Hostmaster >The Free Lance-Star/Internet Department >srobinson(a)fredericksburg.com >http://www.fredericksburg.com > >616 Amelia St. >Fredericksburg, VA 22401 >540-374-5000 ext. 5657

1 0

setting 'arguments' string dynamically in a ZSQL method
by Chas Wareing 08 Jun '01

08 Jun '01

I've been spending way too much time on this-- I'd like to set the 'arguments' string while calling a ZSQL method instead of hardcoding it on the method- my variable names are dynamic a namespace hack or zsql product patch would be appreciated- I'm using this for a generic/reusable qryInsert object- Chas. <c3w(a)ISP.NET> ISP Networks, Inc.

2 1

Re: [Zope] Netscape Problems
by Tres Seaver 08 Jun '01

08 Jun '01

"Chris Withers" <chrisw(a)nipltd.com> wrote: > I'm getting a bit suspicious about the number of times Netscape and Zope > aren't playing together for me :-S > > Basically, on my desktop machine (WinNT 4, Netscape 4.74) I can't actually > submit to any Zope sites. I click a form button but the browser just sits > there with the N spinning and not doing anything. > > I thought that was just my machine, but now on this laptop (Win2000, > Netscape 4.74) the same thing is happening. I'm also getting the problem wit > hthe browser constantly redirecting in a very short loop. IIRC, this is 'cos > it's trying to get a linked stylesheet where Netscape has a bug, so I > disabled sylesheets in my management options, but I still get exactly the > same problem :-( > > Has anyone else experienced any of the above and does anyone have any > solutions? In my experience, this a a pure client-side bogosity. To verify: try blowing away all the 'nsform*' and 'formpost*' files in your "C:\windows\temp" directory; if the problem clears up, make an effigy of Mark Andreesen, abuse it creatively, and call me in the morning. :) Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

8 12

RE: [Zope] Upgrade from Zope 2.2 to Zope 2.3
by Harris Peter 08 Jun '01

08 Jun '01

> ---------- > From: sean.upton@uniontrib.com[SMTP:sean.upton@uniontrib.com] ... > The "apt-get install zope" from unstable/testing should work just fine, > without being disruptive toward your current install data or installed products... > >Good luck, >Sean Yep, it worked like a charm. (And the new management screens look really nice!) Peter **************************************************************************** This message and any files transmitted with it are confidential. The contents may not be disclosed or used by anyone other than the addressee. If you have received this communication in error, please delete the message and notify JBB (Greater Europe) Plc immediately on 0141-249-6285. The views expressed in this email are not necessarily the views of JBB (Greater Europe) PLC. As it has been transmitted over a public network, JBB (Greater Europe) PLC makes no representation nor accepts any liability for the email's accuracy or completeness unless expressly stated to the contrary. Should you, as the intended recipient, suspect that the message has been intercepted or amended, please notify JBB (Greater Europe) Plc immediately on 0141-249-6285. ****************************************************************************

1 0

Help with LoginManager
by Jeremiah White 08 Jun '01

08 Jun '01

I am a new Zope user and I'm having trouble installing LoginManager. I am running Windows ME. First, I can't even unpack 0.8.8b1, so I used 0.8.6. I then unpacked LoginManager in my ZopeFolder... and then I was lost. I'm sorry this is such a basic question, but I can't seem to find any help for this. Thanks, JeremiahGet more from the Web. FREE MSN Explorer download : http://explorer.msn.com

1 0

Python Essential Reference, Second Edition - Coming off the Printer
by Stephanie.Wall＠newriders.com 08 Jun '01

08 Jun '01

Hi, Some of you may remember me from a posting I made in March about free copies of "The Zope Book." While that book is coming off press very soon (July 20 to be exact and I still have the people I promised those copies to) I thought many of you would like to know that David Beazley's Python book - "Python Essential Reference, Second Edition" is just now coming off the printer. (Many of you are familiar with his first edition.) This new edition has been updated for Python 2.1. I'd like to offer 1 free copy to the first 10 people who email me with their interest and mailing address. All I ask in return is that you post your review of the book on amazon.com and fatbrain.com. Look forward to hearing from you. Cheers, Stephanie Wall Executive Editor New Riders Publishing PS. Some of you may also be interested in two other books that are just now coming off press. They are: -"Advanced Linux Programming" by Mark Mitchell, Alex Samuel and Jeffrey Oldham from CodeSourcery, LLC and -"Berkeley DB" by Sleepycat Software. If you have questions about either of these, let me know. Stephanie Wall Executive Editor New Riders Publishing - VOICES THAT MATTER stephanie.wall(a)newriders.com (317) 581-3707 work (317) 407-4720 cell **Please note the new office phone number.**

1 0

Zope < - > MySQL
by Carl Blesius 08 Jun '01

08 Jun '01

We are having a problem with the MySQL Zope connection... Zope 2.3.0 (binary release, python 1.5.2, solaris-2.6-sparc) Python Version 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1] sunos5 ZMySQLDA-1.1.3-nonbin.tar.gz MySQL-python-0.3.5.tar.gz Distutils-1.0.2.tar.gz Traceback (innermost last): File "/usr/local/www/zope/lib/python/OFS/Application.py", line 530, in import_products product=__import__(pname, global_dict, global_dict, silly) File "lib/python/Products/ZMySQLDA/__init__.py", line 106, in ? import sys, os, Globals, DA File "lib/python/Products/ZMySQLDA/DA.py", line 108, in ? from db import DB File "lib/python/Products/ZMySQLDA/db.py", line 106, in ? import MySQL, regex, sys ImportError: dynamic module does not define init function (initMySQL) Anyone have similar problems?

2 1

one step closer to connecting Zope to MySQL
by Horst Wald 08 Jun '01

08 Jun '01

Hi, thanks to all the help I got, I'm a lot closer to connecting Zope to MySQL now and I think I know where the problem is. I have: - started with Suse Linux 7.0 - installed Zope 2.3.2 - installed MySQL 3.22.32 and Python 1.5.2-something with YAST - downloaded and installed MySQL-python-0.3.5, ZMySQLDA-2.0.6 as stated in the ebook I bought myself - downloaded and installed Distutils-1.0.2 - tried to compile the MySQL-python-0.3.5 - got the error message: Traceback (innermost last): File "/usr/zope/lib/python/OFS/Application.py", line 528, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/zope/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/usr/zope/lib/python/Products/ZMySQLDA/DA.py", line 91, in ? from db import DB File "/usr/zope/lib/python/Products/ZMySQLDA/db.py", line 89, in ? import _mysql ImportError: No module named _mysql I took a look at /usr/zope/lib/python/Products/ZMySQLDA/db.py and it says in line 89: "import _mysql", hard coded. Which explains the error: I found no such file on my computer. So it seems, I still have to install something, right? What is it? I'll have a beer on you all when it works, promise! Horst _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

4 3