- Zope - Zope lists

sqltest op=like problems
by alex＠quad.com.ar 25 Oct '01

25 Oct '01

I'm trying to perform the following: SELECT * FROM table <dtml-sqlgroup where> <dtml-sqltest terminal op=like type=string optional> <dtml-and> <dtml-sqltest principal op=like type=string optional> <dtml-and> <dtml-sqltest product op=like type=string optional> </dtml-sqlgroup> if I pass only terminal and product I get the following: SELECT * FROM table WHERE terminal like 'foo' AND product like 'bar' but I need it to render like this: SELECT * FROM table WHERE terminal like '%foo%' AND product like '%bar%' so I read the mailing list archives and found out many people is doing a <dmtl-let fieldName="'%' + fieldNamel + '%'"> but this would break my optional attribute.. here's an example result using let on each field and passing only terminal and product as parameters: SELECT * FROM table WHERE terminal like '%foo%' AND principal like '%%' AND product like '%bar%' this is not tolerated since the principal field might be null, and doing a like '%%' would discard those entries. so, shouldn't dtml-test get patched to support at least the following op attributes: op=like_begin ( like '%foo' ) op=like_end ( like 'foo%' ) op=like_any ( like '%foo%' ) or is there any solution for this already? thanks Alex

1 1

RE: [Zope] can't store a date in Access database
by Capesius, Alan 25 Oct '01

25 Oct '01

As a point of reference, you can use reserved words if you enclosed them in brackets [Date]. The one I run into most often is [Desc] Looks like everyone was shortcuting their posts. I was testing with a different field name and substituted "Date" back into my replies for clarity. Live and learn... >>>-----Original Message----- >>>From: Micah Martin [mailto:micah@objectmentor.com] >>>Sent: Thursday, October 25, 2001 1:59 PM >>>To: 'zope(a)zope.org' >>>Subject: Re: [Zope] can't store a date in Access database >>> >>> >>>I appologize for my careless typos. I should have copied >>>and pasted the >>>code. Here is the copied text: >>>insert into TableName(Date) values ('10/25/2001') >>>The quotes were in fact single quotes. >>>Yes the name of the table is really 'TableName', however >>>this was just >>>created to help tackle my problem. The real SQL statement >>>has 20 fields to >>>fill. I wanted to isolate the problem so I made a silly table named >>>'TableName'. >>>You're right that I should not need a key for this test to work. >>>I am sure the SQL is correct because it works fine in Java. >>>Just not in >>>Zope, it yeild the error: >>>Error, sql.error: ('37000', -3502, '[Microsoft][ODBC Microsoft Access >>>Driver] Syntax error in INSERT INTO statement.') >>> >>> Micah >>> >>>From: "Thomas B. Passin" <tpassin@m... >>></group/zope/post?protectID=189154113112099132172218072026249 >>>012177230057026 >>>209121182190>> >>>Date: Thu Oct 25, 2001 4:29 pm >>>Subject: Re: [Zope] can't store a date in Access database >>> >>>[Micah Martin] >>> >>>> Whoops, this was a typo. The code is actually: >>>> >>>> insert into TableName (Date) values ("10/24/2001") >>>> >>>> I'm still looking for a solution to the problem. >>>> >>> >>>Is the name of your table really "TableName"? This seems >>>unusual. You need >>>the actual name of the table. You also probably need to >>>supply the primary >>>key or index column value as well as the date column - >>>definitely if there >>>is a primary key or an index (there ought to be one, but in >>>Access you can >>>get away without a primary key). >>> >>>Finally, you need to use single quotes instead of double >>>quotes around the >>>date value. Double and single quotes are not interchangable >>>in SQL. So if >>>your table is called "fact_table", and its primary key or >>>index column is >>>called "the_key" whose value should be 102 for this row, and >>>if the date >>>field were called "Date", then you would write >>> >>>insert into fact_table (the_key,Date) values (102,'10/24/2001') >>> >>>Access will accept this syntax for a dattime field, as I >>>just verified by >>>checking. >>> >>>If you mean to be changing an existing date value, you need >>>to use an update >>>statement instead. >>> >>>Cheers, >>> >>>Tom P >>> >>> >>> >>>_______________________________________________ >>>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

RE: [Zope] can't store a date in Access database
by Micah Martin 25 Oct '01

25 Oct '01

Thats it! 'Date' is a reserved word. Thanks Laurie, Micah From: "Laurie Nason" <laurien@b... > Date: Thu Oct 25, 2001 7:13 pm Subject: RE: [Zope] can't store a date in Access database I don't know as I haven't used access seriously for a long time, but isn't Date a reserved word? Won't that screw things up? Also - is the SQL statement expecting a ; at the end of it? Again I seem to remember access throwing fits when I tried to type in my own SQL statements and forgot. hth, Laurie

1 0

RE: [Zope] Stand-alone dedicated client for Windows?
by sean.upton＠uniontrib.com 25 Oct '01

25 Oct '01

A few random thoughts... Potentially, Zope has a lot to offer for building fat-client frameworks, but not a lot of support for a fat client MI. Personally, I think Zope as a front-end to ZODB has good potential in a data-center environment serving GUI clients in the web-services future, and that with this in mind, development frameworks ought to exist to make this as easy as possible to jump into (one can hope; perhaps someday when I get some time, I will try to implement something like this). I think part of the problem is that Zope really ends up being a toolkit for most folks - and one used in a variety of different ways - and a GUI toolkit would place restrictions on this and require a lot of work to address working with each and every Zope product. I think the solution for GUIs is really a responsibility/option for the application layer (i.e. Each Zope product), though there could be a set of tools created for generic Zope tasks for developers (only as an IDE); I think Boa Constructor is the most likely candidate for that. If you want higher-level stuff, you really need to code a custom GUI fro your product, or look into using the CMF with document editing software that supports FTP and/or WebDAV; what is most needed in this regard is not a one-size-fits all client, but a bunch of documentation and examples to make it easier to do this on your own. Developing custom GUI applications with Zope using Boa Constructor, wxPython, and XML-RPC could have very interesting possibilities, and perhaps what is needed is drag-and-drop components for doing this in Boa-Constructor that allow data-binding to XML-RPC calls, like the way Borland RAD tools bind RDB datasets to visual components... Python 2.2 will include XML-RPC support (but you would have to extend it with http basic-auth support), so Python 2.2 packaged together with wxPython for Windows in a unified installer would be a nice start for deploying an application using that as a framework; as for me, I just apt-get install, but it would be nice to be able to build GUI apps that could be deployed by having an installation program spawned to install all the prerequisites. Sean -----Original Message----- From: Frederic Faure [mailto:ffaure@bigfoot.com] Sent: Thursday, October 25, 2001 1:00 PM To: zope(a)zope.org Subject: [Zope] Stand-alone dedicated client for Windows? Hello, I browsed through the archives of this list, but it didn't return any hits. I understand two projects are under way called Zope Fat Client and gnope (GNOME Zope client), and I tried Amos Latteier's example Python client last night, which doesn't work: "TypeError: wxWindow_GetParent() takes exactly 1 argument (2 given)"). Besides, it'd be hell deploying Python + wxPython + a Python-based Zope client. After going through tutorials of Frontier/Radio and The Zope Book, it looks like Zope is the open-source alternative to Frontier. Problem is, I think non-techies would work with a Zope-based intranet a lot more if there were a dedicated client for Windows instead of having to use HTML forms. Is there such a thing available? Also, what are alternative DBMS-based content managements systems that I should know about? Thx FF. _______________________________________________ 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

RE: [Zope] Zope Eats Memory
by sean.upton＠uniontrib.com 25 Oct '01

25 Oct '01

Are you using REQUEST.set() a lot? I am (my presentation code, unfortunately, uses these quite aggressively). I have dtml that wraps other DTML "core" presentation widgets, and I use <dtml-var "REQUEST.set('foo', '')"> a lot. Does anyone know if there is another, more graceful, way to pass parameters from a wrapping dtml method to a dtml method it calls? Also, slightly related, as I eventually plan to migrate this particular site to ZPT: are there any issues with reference leaks with tal:define similar to REUQEST.set() calls? Sean -----Original Message----- From: Chris Gray [mailto:cpgray@library.uwaterloo.ca] Sent: Thursday, October 25, 2001 11:14 AM To: Peter Bengtsson Cc: zope(a)zope.org Subject: Re: [Zope] Zope Eats Memory Aside from ZEO, I'm using only the Debian packages for Zope 2.3.3 and ZMySQLDA. Chris On Thu, 25 Oct 2001, Peter Bengtsson wrote: > Are you using the Photo product? The "old" one. > I've got a product based on the Photo product, and I'm starting to suspect > that there is something wrong there that eats memory. > Just checking. > > At 11:41 2001-10-25 -0400, you wrote: > >I've been running Zope (with ZEO) on a Debian GNU/Linux box. Just today > >everything slowed to a crawl and it turned out that one python process was > >taking up 75% of system memory. Stopping and restarting Zope cured the > >problem. I'm doing some caching of DTML pages and MySQL queries. > > > >Any idea why Zope would start doing this? Are there any preventative > >measures? > > > >Thanks, > >Chris > > > > > > > > > >_______________________________________________ > >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 ) > > > _______________________________________________ > 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 ) > _______________________________________________ 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 )

5 6

Stand-alone dedicated client for Windows?
by Frederic Faure 25 Oct '01

25 Oct '01

Hello, I browsed through the archives of this list, but it didn't return any hits. I understand two projects are under way called Zope Fat Client and gnope (GNOME Zope client), and I tried Amos Latteier's example Python client last night, which doesn't work: "TypeError: wxWindow_GetParent() takes exactly 1 argument (2 given)"). Besides, it'd be hell deploying Python + wxPython + a Python-based Zope client. After going through tutorials of Frontier/Radio and The Zope Book, it looks like Zope is the open-source alternative to Frontier. Problem is, I think non-techies would work with a Zope-based intranet a lot more if there were a dedicated client for Windows instead of having to use HTML forms. Is there such a thing available? Also, what are alternative DBMS-based content managements systems that I should know about? Thx FF.

1 0

RE: [Zope] Loginmanager Installation Problem(despirate for help)
by Stuart Nicholson 25 Oct '01

25 Oct '01

I believe you need to update the ZPatterns Product as well. I'm using LoginManager successfully under Win32 Zope 2.4.1 but it requires the latest versions of both LoginManager and the ZPatterns product to resolve all the issues. You mention you've applied some patches, just for Login Manager? Or for http://cvs.eby-sarna.com/ZProducts/ZPatterns/ also? Hope that helps? Stuart Nicholson Software Engineer wirelessdata - making data fly DDI (09) 306 3935 FAX (09) 379 7360 -----Original Message----- From: Hamzat kamal [mailto:hamzatk@dnetsystems.net] Sent: Thursday, 25 October 2001 8:48 p.m. To: zope(a)zope.org Subject: [Zope] Loginmanager Installation Problem(despirate for help) Hi, I am running zope 2.4.0 -win32 x86. on win 98. I unzipped the LoginManager0.8.8b1 into my zope root directory then shutdown the zope server and put it on again. When I then checked the list of the objects in the zope management screen, it was not their but it was in the product directory in the control panel. So, when I double clicked it (control_panel\product\) this is what was displayed ; Import Traceback Traceback (most recent call last): File "C:\Program Files\WebSite\lib\python\OFS\Application.py", line 552, in import_product product=__import__(pname, global_dict, global_dict, silly) File "C:\Program Files\WebSite\lib\python\Products\LoginManager\__init__.py", line 1, in ? import LoginManager, LoginMethods, UserSources File "C:\Program Files\WebSite\lib\python\Products\LoginManager\LoginManager.py", line 8, in ? from Products.ZPatterns.Specialists import Specialist File "C:\Program Files\WebSite\lib\python\Products\ZPatterns\__init__.py", line 1, in ? import Rack, Specialists, Customizers, AttributeProviders, SheetProviders File "C:\Program Files\WebSite\lib\python\Products\ZPatterns\Rack.py", line 1, in ? from DataManagers import DataManager File "C:\Program Files\WebSite\lib\python\Products\ZPatterns\DataManagers.py", line 6, in ? from AttributeProviders import AttributeProvider File "C:\Program Files\WebSite\lib\python\Products\ZPatterns\AttributeProviders.py", line 7, in ? from Expressions import * File "C:\Program Files\WebSite\lib\python\Products\ZPatterns\Expressions.py", line 38, in ? from DocumentTemplate.DT_Util import Eval, expr_globals, TemplateDict, \ ImportError: cannot import name expr_globals After this, I have tried some patches CVS repository from http://www.eby-sarma.com but this could not solve my problem. Kindly advise on what to do to overcome this problem. Thanks. kamal _______________________________________________ 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 ) ---------------------------------------------------------------------- The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Wirelessdata Ltd is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ----------------------------------------------------------------------

1 0

Re: [Zope] can't store a date in Access database
by Micah Martin 25 Oct '01

25 Oct '01

I appologize for my careless typos. I should have copied and pasted the code. Here is the copied text: insert into TableName(Date) values ('10/25/2001') The quotes were in fact single quotes. Yes the name of the table is really 'TableName', however this was just created to help tackle my problem. The real SQL statement has 20 fields to fill. I wanted to isolate the problem so I made a silly table named 'TableName'. You're right that I should not need a key for this test to work. I am sure the SQL is correct because it works fine in Java. Just not in Zope, it yeild the error: Error, sql.error: ('37000', -3502, '[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.') Micah From: "Thomas B. Passin" <tpassin@m... </group/zope/post?protectID=189154113112099132172218072026249012177230057026 209121182190>> Date: Thu Oct 25, 2001 4:29 pm Subject: Re: [Zope] can't store a date in Access database [Micah Martin] > Whoops, this was a typo. The code is actually: > > insert into TableName (Date) values ("10/24/2001") > > I'm still looking for a solution to the problem. > Is the name of your table really "TableName"? This seems unusual. You need the actual name of the table. You also probably need to supply the primary key or index column value as well as the date column - definitely if there is a primary key or an index (there ought to be one, but in Access you can get away without a primary key). Finally, you need to use single quotes instead of double quotes around the date value. Double and single quotes are not interchangable in SQL. So if your table is called "fact_table", and its primary key or index column is called "the_key" whose value should be 102 for this row, and if the date field were called "Date", then you would write insert into fact_table (the_key,Date) values (102,'10/24/2001') Access will accept this syntax for a dattime field, as I just verified by checking. If you mean to be changing an existing date value, you need to use an update statement instead. Cheers, Tom P

2 1

Running multiple versions of Zope?
by earth_to_zope＠space.com 25 Oct '01

25 Oct '01

Is it possible/good-idea to run 2 different versions of Zope on the same server (using 2 different ports)? I have a Zope-1.10 application running on a RedHat 7.1 server installation (using ZHTTPserver listening to port 9673). It installed it's own Python (1.5.1, I think). The RedHat 7.1 installed 1.5.2. Can I install the current version of Zope and have it listen on a different port (and *I assume* using the system's 1.5.2 Python)? Also, where does Python v2.x fit into Zope? I'd like to start the process of rebuilding this old 1.10 application (that was dropped in my lap) using the current version of Zope and possibly (as someone suggested earlier) using MySQL instead of ZTables for the database info. Thanks for any replies. Darren earth_to_zope(a)space.com ___________________________________________________________________ Join the Space Program: Get FREE E-mail at http://www.space.com.

3 2

Re: [Zope] Zope Eats Memory
by Peter Bengtsson 25 Oct '01

25 Oct '01

Are you using the Photo product? The "old" one. I've got a product based on the Photo product, and I'm starting to suspect that there is something wrong there that eats memory. Just checking. At 11:41 2001-10-25 -0400, you wrote: >I've been running Zope (with ZEO) on a Debian GNU/Linux box. Just today >everything slowed to a crawl and it turned out that one python process was >taking up 75% of system memory. Stopping and restarting Zope cured the >problem. I'm doing some caching of DTML pages and MySQL queries. > >Any idea why Zope would start doing this? Are there any preventative >measures? > >Thanks, >Chris > > > > >_______________________________________________ >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 )

3 2