November 1999 - Zope

ZSQL Create Table
by rgines＠purina.com 20 Nov '99

20 Nov '99

I've been trying to create tables through ZSQL Methods and have been getting some strange results. From the few posts that I have seen in the archives it looks like there have been some behavioral changes from Zope 1.x to 2.x that effect the ZSQ addMethod. For example, from the ZSQL add form method if you use Create table testtwo (col_c varchar, col_d varchar) as the 'Query' you get a responce to the effect that this is not a query ... which I would agree with, but I'm not in the habit of arguing with my computers. If you try to run the Method a second time you get the error Error, exceptions.NameError: cannot create TESTTWO, exists Using the template from 'Sample of DTML Scripting and Gadfly' at classic.zope.org:8080/Documentation/HowTo/SampleGadfly/index_html I try to execute ...  ... The error I get is Error Type: AttributeError Error Value: manage_addZSQLMethod With a traceback of Traceback (innermost last): File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\PROGRA~1\GYNZER~1\lib\python\Zope\__init__.py, line 201, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 165, in publish File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\OFS\DTMLMethod.py, line 145, in __call__ (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_Util.py, line 321, in eval (Object: Sample.manage_addZSQLMethod('create_table','','zopadelic','','create table zopista (col_a integer, col_b integer)')) File <string>, line 0, in ? File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_Util.py, line 125, in careful_getattr AttributeError: (see above) I looked at the SQL.py file and the attributes seem to be passing correctly, but I'm still a python newbie ... although ramping up quickly. Any assistance would be apprecited. Thanks.

2 1

creating trees
by geoff nordli 20 Nov '99

20 Nov '99

I posted into the zope-dev list, but I think it was the wrong list for this. I am using squishdot. I currently have this code to display all the articles, and comments. <dtml-tree branches=postingValues> <A HREF="<dtml-var tree-item-url>"><dtml-var title></A> </dtml-tree> This works well, but I would like to be able to get a listing of the subjects as the top branch, and then the articles that are associated with the subjects as leafs. I think that would be real cool. thanks, geoff nordli

1 0

Re: [Zope] Strange Image Behavior
by rgines＠purina.com 19 Nov '99

19 Nov '99

>It is your browser cache. Manually flush it (go to options, press the >appropriate flush buttons). Restarting is not enough. >Browsers are very aggressive in cacheing images, especially Netscape. Duh!!!. I was so busy looking at the trees (images) that I didn't see the forest (browser) ..... Thanks for the freeing my from my stupid user trick.

1 0

Strange Image Behavior
by rgines＠purina.com 19 Nov '99

19 Nov '99

This is really strange. If someone can help me sort out if this is a bug of a stupid user trick I would appreciate it. There's the deal Created a directory called 'Images' Created 'Logo' as an Image. Imported 'PictureA' >From the root, edited Index_html to pull up 'Logo'. Images pulled properly, but looks crappy. Go back to Images. Upload 'PictureB' to 'Logo' Reloaded root Index_html ... hmmm 'PictureA' shows up ...huh? Recheck 'Logo', looks okay. 'View' from within 'Logo', 'PictureB' looks great. Mabey another resource called 'Logo'? Yep. ... in another path ... shouldn't get picked up on, but for testing renamed to 'LogoOld' Retested root Index_html .... 'PictureA' still shows up. Recheck code in Index_html ... change 'Logo' call to <dtml-with Images> <dtml-var Logo> </dtml-with> Retest Index-html. 'PictureA' still shows up. Go back to 'Images' Rename Logo to LogoOld Create a new Logo with 'PictureB' 'View' picture from within new Logo. Looks good. Retest index_html ... 'PictureA' still showing up. Pick up computer pieces off floow after knocking table leg out from under PC. ... rebuild computer before resuming tests on said computer .... hmmm... same problem. Assume browser chache is causing the problem. Stop/restart browser, retest main page. Hello 'PictureA' Take deep breath. In images, create 'Logo2' with 'PictureB'. Test .. okay Change root Index_html to call Logo2. HEY IT WORKS!!!!! Changed back to Logo. STILL wrong picture in Index_html. Nuked Logo and LogoOld. Index_html should not work ... good it didn't. Recreated Logo from scratch. View test works great Retried Index_html STILL WRONG PICTURE!!!! Just tossed computer from 32nd floor, I'm sure it wont take long for the cable to th

4 3

Re: [Zope] Calendar product
by rgines＠purina.com 19 Nov '99

19 Nov '99

>> I found on the Zope-announce list the following reference to a product >> called beeCal http://www.zope.de/software/beeCal/index_eng_html >Yep, it's the BeeHive product I noticed a while back - and back then, as >well as now, while the code is available, as well as documnetation >(surprising) the site doesn't seem to be using its own product, or have a >demo to see how it works. I looked at the BeeHive product and it didn't doo at all what I expected or was looking for. >Seriously, don't the people who write these Products actually use them, or >want people to see how they work? I have been able to get the Calendar product that you are talking about to display a calendar, move back and forth between dates and be able to put text within all of the day blocks. What I have not been able to do is customize the calendar entries based on the specific blocks date or been able to create a usable link listed within the blocks. It looks like the valid methods are there, but I can not get any valid responses from them. I have tried to look at the code, but I am enough of a newbie with python/Zope that it has taken me more time than I can spend (if clients would only pay you to play!!!!!). if you find out anything more than I have, please share it with the rest of us. >Harry

4 3

Re: [Zope] ZOracleDA - python - dumps core [Q]
by Roman Milner 19 Nov '99

19 Nov '99

>>>>> "BM" == Bruno Mattarollo <brunomadv(a)ciudad.com.ar> writes: BM> I compiled DCOracle that came in the ZOracleDA 2.1.0 to BM> But I am noticing a strange behavior. From time to time BM> (several times a day -aprox 10 to 15), randomly -or at least I BM> couldn't see a pattern- I get a "Resource Unavailable" and BM> clicking anywhere else works. And I get a core file in the BM> Zope root directory. Doing a file core I get the following. BM> core: ELF 32-bit MSB core file SPARC Version 1, from 'python' We see the same thing except our Zope server is on a Linux box. It seems like we have been able to work around it by running zserver and apache at the same time. We start z2.py with the -p flag. It would be nice to have a reall answer though. ^Roman

2 1

Pre-ANN: ZI18N
by Tres Seaver 19 Nov '99

19 Nov '99

I have put a very simple internationalization product, ZI18N, on my zope.org page: http://www.zope.org/Members/tseaver/ZI18N/ This product is a quick start at "themable" or "skin-based" internationalization. it contains a single ZClass: ZI18N_Document (ObjectManager, DTML_Document) which serves as a container/sheaf of translations for a single "logical" document. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

ZSQL 'Like'
by JB 19 Nov '99

19 Nov '99

I'm new to Zope and I'm trying to put togther a ZSQL search method. I want to take the input from the user form and create a LIKE clause rather than an = clause. This means I need to tack a percent sign onto the input. If the user enters 'Jim' I need the SQL method to create, WHERE firstname LIKE 'Jim%'. Whats the best way to do this in Zope? thanks jb

2 1

ANNOUNCE: Zope SybaseDA v2.0.0b1 released
by Chris Petrilli 19 Nov '99

19 Nov '99

I'm proud to announce that we have finally taken the wraps off the total ground-up rewrite of the SybaseDA. This is a beta, but it's gone thru some testing already. You can find it on the Zope website at: http://www.zope.org/Products/DA/SybaseDA/ Please read the CHANGES.txt and understand all the differences, as it might break much of your code that depends on strangeness in the previous release. The CHANGES.txt is below: Zope Sybase DA Changes The DC Sybase DA provides access to Sybase Databases from Zope. Zope Sybase DA 2.00b1 Features Added The Zope Sybase DA provides the features of previous sybase database adapters and: - Fully multi-threaded - Support for Zope sub-transactions - Trailing spaces are stripped from strings on retrieval - The user interface for adding and editing database connections now uses separate fields for server, user, password, and database information. It is no longer necessary to use an arcane connection string. - Connections now have a "Transactional" option to control whether transactions are used. (Sybase consumes resources for transactions even when select statements are used, so pure-read requests should use non-transactional connections.) - Long integer fixed-decimal numbers are supported. Numeric columns with zero scale and precision greater than nine are retrieved as Python long integers. Notes on data type conversions: - Sybase Money types and numeric types for which scale is non-zero are retrieved as Python floats. This could lead to a loss of precision. - Image and text columns are truncated at 64K. Futures The following features are under consideration for the future: - Full support for Sybase text and image columns. Currently, text and image columns are truncated at 64K. - Drop-in Sybase stored procedures. - Perhaps provide dedicated data types for numeric (ie fixed decimal) and monetary data. -- | Christopher Petrilli Digital Creations | petrilli(a)digicool.com http://www.digicool.com

1 0

Calendar product
by technews＠egsx.com 19 Nov '99

19 Nov '99

Hi, Does have examples on how to use the calendar product? The README included is not enough. It does not explain what is a template and how to make one. Are there other products out there similar to it?? TIA Adonis

2 4