- Zope - Zope lists

anyone using plone in japan?
by David Bear 08 Aug '03

08 Aug '03

I'm wondering if there are any plone users developing sites in japanese. I need to understand some of the issues of internationalizing with python/zope/cmd/plone -- and how other tools like webdav work with CJK character sets. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"

3 2

Re: [Zope] loading zope within python interpreter
by Michael Long 08 Aug '03

08 Aug '03

Thanks for the reply. I am working with zope 2.7 so if anyone knows of any *gotcha's* I would appreciate it. With this and the link Frode replied with and google I will now continue my journey into the magical world of Zope. Cheers, Mike > IIRC things have changed somehow for zope 2.7, but for zope <= 2.6 you > can do this: > > pw@kermit Zope-2.6.1-src $ export PYTHONPATH=lib/python/ > pw@kermit Zope-2.6.1-src $ python > Python 2.2.3 (#1, Jul 22 2003, 12:28:47) > [GCC 3.2.3 20030422 (Gentoo Linux 1.4 3.2.3-r1, propolice)] on linux2 > Type "help", "copyright", "credits" or "license" for more information. > >>> import Zope > >>> app = Zope.app() # this takes a few seconds > >>> app.objectIds() > ['acl_users', 'Control_Panel', 'standard_html_header', 'standard_html_footer', 'standard_error_message', 'index_html', 'temp_folder', 'browser_id_manager', 'session_data_manager', 'Examples', 'error_log', 'standard_template.pt'] > > -- > > Paul Winkler > http://www.slinkp.com > Look! Up in the sky! It's THE TENSILE AARDVARK! > (random hero from isometric.spaceninja.com) > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > >

2 1

RE: [Zope] SQL Queries, DTML Methods and XML-RPC
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 08 Aug '03

08 Aug '03

Ah, turns out Python Scripts also behave like methods! Never mind :) J.F. -----Original Message----- From: Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca [mailto:Jean-Francois.Doyon@CCRS.NRCan.gc.ca] Sent: Friday, August 08, 2003 4:32 PM To: zope(a)zope.org Subject: [Zope] SQL Queries, DTML Methods and XML-RPC Hello, After some research, I've still not come up with any great solution to this problem (Though I did see a few things on the web, archives, etc ...) I would like to have methods callable through XML-RPC that return the result of SQL queries (Z SQL Methods). So far, the best luck I've had is by using a DTML Method. The big problem is that DTML Method doesn't take positional parameters ... (In hind sight, this is probably is shortfall of DTML Methods ... if they're really "methods", then they should take parameters through aparameter list, much like Python Scripts ... no? ). Anybody know a way around this? One other option I have thought of so far: Since DTML Methods are methods of their folders, I could do the same through a product: create a fodlerish type and extend it with my own methods, which will then be available through XML-RPC. This is more painful to create and manage, not only for the obvious reasons, but because I may have many methods I wants to create for XML-RPC access, and constantly creating new folderish types for that pupose isn't very elegant or sustainable. Also did I not hear there' sissue with calling SQL Methods from product code ? I'll look into that. Does anybody have any better way to do this? Any suggestions would be much appreciated! Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410 _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

1 0

Truncation Reading from ODBC
by Jerry Westrick 08 Aug '03

08 Aug '03

Hello Zopistas: I'm trying to read (and later probably write) large strings to a postgress database. I'm using the egenix ODBC adapter, and the unix ODBC postgress driver. When I read a column with 20,000+ characters I only get the first 8194 characters. Is this: 1) a Zope restriction? 2) a UnixOdbc restriction? 3) a egenix ODBC restriction? 4) an ODBC protocol restiction? Thanks for any of the above answers.... Jerry Westrick

4 5

parameter transfer to a zsql-method (lists, dictionaries etc.)
by Elena Schulz 08 Aug '03

08 Aug '03

Hi, I have problems with the parameter transfer to a zsql-method: With the Test - Tab of the ZMI the following ZSQL-method works fine without passing any parameters (i.e. with the default values) But if I call it with "return db.sql.device_list()", with "db.sql.device_list(['col1','col2'])" or with "db.sql.device_list(columns=['col1','col2'])" from a script I get the given errors. Can anybody enlight my understandig of how to pass parameters (e.g. lists, dictionaries) to zsql-methods especially so that they will work in an dtml-in construct? That would be very helpfull. --Thanks, Elena my ZSQL-Method: <params>columns:list:string=* where:string="" sort_col:string="" sort_reverse:int=0</params> SELECT <dtml-in columns prefix=column> <dtml-var column_item fmt=sql-quote><dtml-unless column_end>, </dtml-unless> </dtml-in> FROM device_list the error details: Error Type: InError Error Value: Strings are not allowed as input to the in tag. Error error_tb: Traceback (innermost last): * Module ZPublisher.Publish, line 98, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Shared.DC.Scripts.Bindings, line 252, in __call__ * Module Shared.DC.Scripts.Bindings, line 283, in _bindAndExec * Module Products.PythonScripts.PythonScript, line 315, in _exec * Module Script (Python), line 9, in test <PythonScript at /tomaxx/db/s/test> Line 9 * Module Shared.DC.ZRDB.DA, line 415, in __call__ * Module DocumentTemplate.DT_String, line 474, in __call__ * Module DocumentTemplate.DT_In, line 636, in renderwob InError: Strings are not allowed as input to the in tag.

2 1

button in ZPT
by Michael Bleijerveld 08 Aug '03

08 Aug '03

Instead of a textlink I want to use a button (form) as a replacement for the following statements. Has anyone suggestions ? <a tal:condition="previous" tal:attributes="href string:${request/URL0}?start:int=${previous/first}" href="previous_url">previous</a> Regards. Michael

2 1

password for website??
by Rex McKanry 08 Aug '03

08 Aug '03

Hi, I'm real new at using Zope and need to find out how to require a user to enter a user name and password for Zope. Kind of like the login in screen I get when I want to connect to Zope and work on a web page. This is the last thing I need for my school project then it's all the paperwork showing the design stuff. Thanks, Rex __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

2 1

SQL Queries, DTML Methods and XML-RPC
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 08 Aug '03

08 Aug '03

Hello, After some research, I've still not come up with any great solution to this problem (Though I did see a few things on the web, archives, etc ...) I would like to have methods callable through XML-RPC that return the result of SQL queries (Z SQL Methods). So far, the best luck I've had is by using a DTML Method. The big problem is that DTML Method doesn't take positional parameters ... (In hind sight, this is probably is shortfall of DTML Methods ... if they're really "methods", then they should take parameters through aparameter list, much like Python Scripts ... no? ). Anybody know a way around this? One other option I have thought of so far: Since DTML Methods are methods of their folders, I could do the same through a product: create a fodlerish type and extend it with my own methods, which will then be available through XML-RPC. This is more painful to create and manage, not only for the obvious reasons, but because I may have many methods I wants to create for XML-RPC access, and constantly creating new folderish types for that pupose isn't very elegant or sustainable. Also did I not hear there' sissue with calling SQL Methods from product code ? I'll look into that. Does anybody have any better way to do this? Any suggestions would be much appreciated! Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410

1 0

Re: sql_quote in dtml-var in zsql-Methods
by Elena Schulz 08 Aug '03

08 Aug '03

Hi Jim, thanks for your answer. Yes, I know about the quoting problem and what dtml-var does. But acording to my findings dtml-var plus sql_quote doesn't do the same thing. I couldn't find that it was doing anything with the quoting. That's why I'm asking. Also the different way dtml-var plus fmt=sql-quote. But I will check again. But another question: what should be done in the following construct: select <dtml-var myCol> from <dtml-sqlvar myTable> Here another kind of quoting would be needed or the following could be done: myCols = "a_table_col from a_table; delete * from a_table; select * " Thats the same problem, isn't it? What would help here? Just a double quoting like: select "<dtml-var myCol>" from <dtml-sqlvar myTable>? -- Elena

2 1

mysql error...
by Chris Bowlby 08 Aug '03

08 Aug '03

Hi All, Got an issue with a search feature that was configured by a client of mine, when they choose to search using a keyword, they get this error: Site Error An error was encountered while publishing this resource. _mysql_exceptions.NotSupportedError Sorry, a site error occurred. Traceback (innermost last): File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 106, in publish File /usr/local/www/Zope/lib/python/Zope/__init__.py, line 182, in abort File /usr/local/www/Zope/lib/python/ZODB/Transaction.py, line 107, in abort File /usr/local/www/Zope/lib/python/Shared/DC/ZRDB/TM.py, line 60, in abort File /usr/local/www/Zope/lib/python/Products/ZMySQLDA/db.py, line 328, in _abort NotSupportedError: (1196, "Warning: Some non-transactional changed tables couldn't be rolled back") I'm not much of a Zope user/admin, so someone might need to be really specific about what this error actually means, it seems to be that a table might be missing from the mysql datatbase, but I need some confirmation on that, also if that is the case, where would I get the schema for this table..

3 2