- Zope - Zope lists

RE: zmxodbc
by Jay, Dylan 20 Feb '01

20 Feb '01

First off, I'm sorry if questions about ZmxODBC have gone to the list and I havn't answered them. I don't read Zope(a)zope.org anymore. As for your problem, I'm afraid I really don't know. The problem with ZmsODBC is that there are 4 parts involved in any query. The DB server, the ODBC driver, the mxODBC connector and then finally ZmxODBC. This error seems to be coming from ZmxODBC but I have no idea why. The line referenced seems to be a comment line when I look at the code. If you look at lib\python\Products\ZmxODBCDA\db.py, line 233, what do you see? What database are you trying to use? Does the same error occur when using SQLMethods? > -----Original Message----- > From: Júlio Silva [mailto:jsilva@ruido-visual.pt] > Sent: Wednesday, 21 February 2001 7:40 AM > To: djay(a)innocent.com > Subject: zmxodbc > > > Hi, > > sorry for taking your time but I'm having problems getting > zmxodbc to wor= > k. > The product installation works ok and also ok is the creation > of connecti= > ons > instances. The problem is that when trying to submit a query > I get a Interface Error with the folowing traceback. > > >  > > I saw a post of someone mentioning the same problem but there > wasnt no an= > swer > so sorry If Im repeating a already answered question. > > Thanx a lot for any comments and bes regards, > J=FAlio Dinis Silva >

1 0

zombie handling
by J�lio Dinis Silva 20 Feb '01

20 Feb '01

Hi, has anyone been working on this: http://classic.zope.org:8080/Collector/871/view Best Regards, Julio Dinis Silva _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

Checking sequence-index using dtml-if
by Jeff Hotz 20 Feb '01

20 Feb '01

I only want to operate on the first 3 records returned in the ZSQL_select_images. I thought that a dtml-if test would do it based on the dtml-var sequence-index but I'm not having any luck. Any suggestions on either my logic or the implementation of it? Any help you can offer will be greatly appreciated. Thanks. <dtml-in ZSQL_select_images> <dtml-if expr="'<dtml-var sequence-index>' < 3"> <TR> <TD ALIGN="CENTER"> <img src= "<dtml-var image_path_prop><dtml-var FILENAME>"> <BR> <FONT SIZE="4" COLOR=<dtml-var caption_color_prop>> <B><dtml-var CAPTION></B><BR><BR><BR> </FONT> </TD> </TR> </dtml-if> </dtml-in> jeff(a)hotz.net www.hotz.net

4 3

Zope Directions Roadmap Posted
by Amos Latteier 20 Feb '01

20 Feb '01

Hello Zopistas, I am excited to announce a Zope Directions Roadmap. http://dev.zope.org/Resources/ZopeDirections.html This document summarizes current thinking at Digital Creations about where the Zope platform is going from an architectural point of view. It summarizes informal conversations that we've been having internally for the past couple months. This paper talks about how we'd like to improve Zope to make it easier for Python developers. It puts some existing initiatives (e.g. Presentation Templates, and the Content Management Framework) in context, and discusses potential future projects like moving to a component architecture. I should point out that this document is not a concrete plan so much as a statement of what's on our minds. Zope development will continue to operate openly in the fishbowl (http://dev.zope.org/) We'd love to hear what you have to say. Are we heading in the right direction? Is there something else that we should be doing instead to help developers? Let us know. (Follow up should be on the zope-dev mailing list.) And when we begin new fishbowl projects (look for a component architecture project soon) jump in and help define Zope's future! -Amos -- Amos Latteier mailto:amos@digicool.com Digital Creations http://www.digicool.com

1 0

document_src returning evaluated dtml
by Tim Hicks 20 Feb '01

20 Feb '01

I have asked this question before, but I am still no nearer finding a solution. I am running Zope 2.3.0 on a solaris box (although experience the same thing under 2.2.2 on RH Linux 6.2). I created a zclass which has base classes of 'ZObject, CatalogAwareBase, ZDTMLDocument'. In order to automatically reindex an instance when it is edited, I created my own 'my_editForm' method within the zclass and assigned it to the edit view. This form was made by taking the html source of the standard edit form page, and changing the static parts of the page (that refer to modification time, size, textarea, id, title etc) for various dtml-var inserts. Here is an extract of the form as it is now. <FORM ACTION="my_edit" METHOD="POST"> <TABLE CELLSPACING="2"> <TR> <TH ALIGN="LEFT" VALIGN="TOP">Id</TH> <TD ALIGN="LEFT" VALIGN="TOP"><dtml-var id></TD> </TR> <TR> <TH ALIGN="LEFT" VALIGN="TOP"><EM>Title</EM></TH> <TD ALIGN="LEFT" VALIGN="TOP"> <INPUT TYPE="TEXT" NAME="title" SIZE="40" VALUE="<dtml-var title>"> </TD> </TR> <tr> <th align="left" valign="top"> <em>Size</em> </th> <td align="left" valign="top"> <dtml-var get_size> bytes </td> </tr> <tr> <th align="left" valign="top"> <em>Last modified</em> </th> <td align="left" valign="top"> <dtml-var bobobase_modification_time> </td> </tr> <TR> <TD COLSPAN="2" ALIGN="CENTER"> <TEXTAREA NAME="data:text" WRAP="Off" COLS="<dtml-if dtpref_cols><dtml-var dtpref_cols><dtml-else>80</dtml-if>" ROWS="<dtml-if dtpref_rows><dtml-var dtpref_rows><dtml-else>12</dtml-if>"><dtml-var document_src></TEXTAREA> </TD> </TR> <TR> <TD align=left> <INPUT NAME=SUBMIT TYPE="SUBMIT" VALUE="Change"> </TD> <TD align=left> <INPUT NAME=SUBMIT TYPE="SUBMIT" VALUE="Taller"> <INPUT NAME=SUBMIT TYPE="SUBMIT" VALUE="Shorter"> <INPUT NAME=SUBMIT TYPE="SUBMIT" VALUE="Wider"> <INPUT NAME=SUBMIT TYPE="SUBMIT" VALUE="Narrower"> </TD> </TR> </TABLE> </FORM> As far as I can tell, the edit page seems to work fairly well. I'm pretty sure that the correct 'size' and modification time gets inserted, and the 'id' and 'title' are definitely correct. And, for the most part, the <dtml-var document_src> works as expected as well. However, if there is a <dtml-call "RESPONSE.redirect('http://www.mysite.com')"> in the source of the zclass instance, the redirect gets executed every time I try to simply edit the instance! Even more strangely, if the redirect call is within other bits of dtml logic that evaluate to false (and thus result in the redirect not being called when the instance is viewed), the redirect does not occur when attempting to edit either. In an effort to find a way around this, I have tried several things including; - using <dtml-var "document_src()"> - using <dtml-var "document_src()" html_quote> - using <dtml-var "document_src(REQUEST,RESPONSE)"> - using <dtml-var "document_src(REQUEST,RESPONSE)"> <dtml-call "REQUEST.set('Content-Type', 'text/html')"> - using <dtml-var "PrincipiaSearchSource()"> - using <dtml-call "REQUEST.set('thesource', _['document_src'])"><dtml-var thesource> in each case, the same thing happens [N.B. I'm not totally sure I've got the syntax exactly correct for the last one]. So, I guess my question is, why is the document_src getting evaluated instead of just sent the page as normal text? This works properly when I try to do it with a normal DTML Document; why does my zclass behave differently? Cheers for any help Tim

1 0

Re: [Zope] newbie: extending the Image class?
by Dieter Maurer 20 Feb '01

20 Feb '01

Chris Cioffi writes: > i'd like to find out how to extend the Image class in Zope to include a few > more properties. Any pointers to documentation would be appreciated. There is a HowTo on "zope.org" on how to build product, something like "Product developpers guide". Be careful to get the latest one. I have seen a post (-> searchable mailing list archive) with the URL for the various product documentation URL's. Dieter

1 0

Re: [Zope] dtml problem
by Dieter Maurer 20 Feb '01

20 Feb '01

Klaus Herrmann writes: > > <dtml-call "_.getitem(doc_id, 0).manage_edit > Error Type: AttributeError > Error Value: 'string' object has no attribute 'manage_edit' I guess that "doc_id" contains the name of a property (of type 'string'). Dieter

1 0

Re: [Zope] performance problem
by Dieter Maurer 20 Feb '01

20 Feb '01

Torsten Gallmeister writes: > Is there a way to disable caching for products/attributes/objects ? I think this > would be nice for some sites which have not too much requests but a large amount > of data. You know, you can control the cache parameters? Control Panel -> Database Management -> Cache Parameters Dieter

3 2

Product release: ExtFile/ExtImage 1.1.0.beta1
by Gregor Heine 20 Feb '01

20 Feb '01

ExtFile/ExtImage Product 1.1.0.beta1 has just been released. Get it at http://www.zope.org/Members/MacGregor/ExtFile The new Version comes with many, many internal changes and some new features which will (hopefully) make ExtFile/ExtImage even more reliable: - You can set a 'level of undo' which determines in wich cases the external file is overwritten/deleted or renamed to '.undo'. - 'id collision bug' fixed, which caused unreferenced files in the repository, when an id of a new object already existed (thanks to Fred Yanowski). Instead of in the __init__ method, the file data is now passed to the object after it has been successfully added, via manage_file_upload. - 'wrong file size bug' fixed, which caused a wrong file size and resolution of the image and preview, after a new file was uploaded followed by an undo of this transaction. The filesize and resolution attributes have been replaced by corresponding methods which determine the respective value directtly from the file(e.g. width(), height(), prev_size(), ...) - Objects can be assigned an alternative id (instead of the filename) by the optional 'id' field in the manage_add method of ExtFile and ExtImage. - Uploaded preview images can be resized during upload (like the generated previews). - Images can be dynamically resized (thanks to Arno Gross): the index_html method now has two additional parameters ('width' and 'height') which cause the image to be resized on the fly. - Documentation updated. Because the product was rewritten in big parts this release is a beta version which might still have some bugs. I haven't had too much time for testing, so please report me any bug you find. I hope I will be ableto publish the next stable release within the next two or three weeks.

1 0

Help with multiple SQL statements in Interbase?
by Jason.Jones＠awl.com 20 Feb '01

20 Feb '01

I have an Interbase 6.0 database on Win32 and I'm using the 0.9.2 version of the gvidb, but I'm running into problems with Z SQL queries like the following: insert into users (username,pword,email,lastname,firstname,chrome) values(<dtml-sqlvar username type="string">, <dtml-sqlvar expr="mkpword(password)" type="string">, <dtml-sqlvar email type="string">,<dtml-sqlvar lastname type="string">, <dtml-sqlvar firstname type="string">, <dtml-sqlvar chrome type="string">) <dtml-var sql_delimiter> insert into users_roles (UID, ROLEID) values(gen_id(UID_GEN,0), <dtml-sqlvar user_role type="string">) The SQL looks right and the first part of the query (before the delimiter) is executed and committed. The second part (which adds a user's role) never gets submitted. Is there a problem with sending multiple SQL statements to interbase in the same method? If so, is there a workaround, these need to go in the same transaction to insure that gen_id gives me the correct value. Thanks, Jason Jones jason.jones(a)awl.com

1 0