- Zope - Zope lists

Re: [Zope] Maybe non-Zope issue: SQL Server doesn't return table field completely
by Jon Erickson 01 May '02

01 May '02

On Wed, 2002-05-01 at 08:50, Dirk Van.Laanen wrote: > Hello, > > I have a table with a field 'term' which is a text field, thus up to 255 characters. > The table was originally an Access database. For reasons of company policy, > this database has been transported to an SQL Server 6.5 database. The old > Access database, however, still exists, on the same server als SQL Server. > > If I make a Z ODBC database connection to SQL Server, and perform a ZSQL > query on the field 'term', only about 120 characters of the field 'term' are represented. > If I use the Z ODBC database connection to the Access Database (with exactly the same > data), I get the complete field returned after a query. > > Does this ring a bell with anybody? Is it just an issue with SQL Server or does Zope > maybe play a part in it? Do you have physical access to the SQL Server? If so, run one of the SQL Server native utilities to browse the table and verify the integrity of the "term" field. IIRC, for SQL Server 6.5 you could use the "Enterprise Manager" or a utility named "isqlw" to query a database. Most likely the field was somehow truncated during the transfer. Jon

1 0

Maybe non-Zope issue: SQL Server doesn't return table field completely
by Dirk Van.Laanen 01 May '02

01 May '02

Hello, I have a table with a field 'term' which is a text field, thus up to 255 characters. The table was originally an Access database. For reasons of company policy, this database has been transported to an SQL Server 6.5 database. The old Access database, however, still exists, on the same server als SQL Server. If I make a Z ODBC database connection to SQL Server, and perform a ZSQL query on the field 'term', only about 120 characters of the field 'term' are represented. If I use the Z ODBC database connection to the Access Database (with exactly the same data), I get the complete field returned after a query. Does this ring a bell with anybody? Is it just an issue with SQL Server or does Zope maybe play a part in it? Cheers everybody, Dirk

1 0

JPE Compiler
by Thomas Mathes 01 May '02

01 May '02

Hello, I want to use JPE on Windows 2000, but I don't have an a Visual C++ Compiler ? Aren't there any binarys or zip Packages which I can download ?

2 1

PIL installing for usage in Zope
by Dirk Datzert 01 May '02

01 May '02

Hi all, I have a problem PIL with Zope and imaging products Error Type: ImportError Error Value: The _imaging C module is not installed System Linux 2.4.16, Python 2.1.3, Zope 2.5.1, PIL 1.1.3 PIL is in /usr/lib/python2.1/site-packages/PIL _imaging.so is in /usr/lib/python2.1/site-packages/PIL and /usr/lib/python2.1/site-packages/ in /usr/lib/python2.1/site-packages/ is also a PIL.pth with 'PIL' in it. Help anybody can give a hint where to look for the solution. Thanks, Dirk

2 2

Re: [TFW] Re: [Zope] Form Data Needed in Second Form
by Itai Tavor 01 May '02

01 May '02

>At 03:41 PM 5/1/2002 +1000, Itai Tavor wrote: >>>Dan Shafer wrote: >>> >>>I have part of a Zope app written largely as Python scripts linking DTML >>>forms that looks conceptually like this: >>> >>>1. Form A gathers data and then as its action invokes a Python script. >>>2. Python Script 1 creates a new DTML document and updates its contents >>>based on field data in Form 1. >>>3. Python Script 1 then uses RESPONSE.redirect() to open a second DTML >>>form, Form 2. >>>4. Form 2 needs the name of the document Python Script 1 created as well as >>>access to some or all of the data in the fields in Form 1. >>> >>>What is the best/right/only way to accomplish this goal? >>> >>>Seems like it should be straight-forward but I've played with several >>>promising ideas that turned out to be dead ends. I'm getting a bit >>>desperate. >>> >>>All help appreciated! >> >>My preferred solution is to call Form 2 in the context of the new >>document. Your Python Script creates 'doc1' and then redirects to >>'doc1/Form2'. Form 2 then has full access to all the data stored in >>the new document. > >Good idea. But won't this require me to parse the contents of doc1 >rather than simplly grabbing the data from the Form1 POST operation? >I can do that, I suppose, but it seems inelegant somehow. There must >be a more efficient way, no? You're right. I usually use this solution when the submitted data gets stored in properties, which makes it easy to access in the 2nd form. If you somehow incorporate the data into the content of the document, you probably don't want to have to parse the content. In this case I'd try one of two other solutions - if the amount of data is small, you can add it to the URL you redirect to. Something like "Form2?form1data.newid:record=doc1&form1data.someparam:record=somevalue". Then in Form 2 REQUEST['form1data'] should give you a dictionary with your data in it. The other option is not to redirect to Form 2 but to return it from the Python Script (untested, YMMV, this may kill your dog, etc.): # Create and fill new document .... # Collect all the data needed by Form 2 dict = {} dict['new_id'] = new_document_id dict['some_param'] = REQUEST['form']['some_param'] # Render Form 2 return context.Form2(context, REQUEST, form1data=dict) If I was doing this, I'd use the 2nd option. Much cleaner. Hope this helps more than the last suggestion. -- -- Itai Tavor -- "Je sautille, donc je suis." -- itai(a)optusnet.com.au -- - Kermit the Frog -- -- -- -- "If you haven't got your health, you haven't got anything" --

1 0

[zwiki] opening up cvs
by Simon Michael 01 May '02

01 May '02

Hi all, today I am throwing open the doors of Zwiki CVS. If you are familiar with zwiki and able to lend a hand with the product code, I invite you to send me your sourceforge id so I can add you to the list of developers. You will then have write access to the cvs repository as described at https://sourceforge.net/cvs/?group_id=5690 (module "zwiki"). I will continue acting as chief broompusher and de facto dictator for now and will resolve disagreements by decree if appropriate. I'd like to grow this project so that many of us can work actively on it, and this may require experiments and adjustments as we go. To begin with I ask that you act conservatively, discussing significant code & architectural changes on zwiki.org. All other kinds of help - documentation, bug tracking, template design, sponsorship, wiki maintenance & development, packaging, etc. - remain much needed and appreciated. Best regards, -Simon

1 0

color-syntax editor for dtml
by Wendy Langer 01 May '02

01 May '02

Hi everyone, I was just wondering on what people's opinions are on the best applications to use for editing dtml files - I want something with at least a bit of syntax coloring - is there anything designed specifically for dtml? If not, what else would be best to use? Thanks, _________________________________________ Wendy Langer ICQ#: 71726799 More ways to contact me: http://wwp.icq.com/71726799 See more about me: http://web.icq.com/whitepages/about_me?Uin=71726799 _________________________________________

7 6

Re: [Zope] Form Data Needed in Second Form
by Itai Tavor 01 May '02

01 May '02

>Dan Shafer wrote: > >I have part of a Zope app written largely as Python scripts linking DTML >forms that looks conceptually like this: > >1. Form A gathers data and then as its action invokes a Python script. >2. Python Script 1 creates a new DTML document and updates its contents >based on field data in Form 1. >3. Python Script 1 then uses RESPONSE.redirect() to open a second DTML >form, Form 2. >4. Form 2 needs the name of the document Python Script 1 created as well as >access to some or all of the data in the fields in Form 1. > >What is the best/right/only way to accomplish this goal? > >Seems like it should be straight-forward but I've played with several >promising ideas that turned out to be dead ends. I'm getting a bit desperate. > >All help appreciated! My preferred solution is to call Form 2 in the context of the new document. Your Python Script creates 'doc1' and then redirects to 'doc1/Form2'. Form 2 then has full access to all the data stored in the new document. HTH. -- -- Itai Tavor -- "Je sautille, donc je suis." -- itai(a)optusnet.com.au -- - Kermit the Frog -- -- -- -- "If you haven't got your health, you haven't got anything" --

1 0

dynamic dtml-tree
by dman 30 Apr '02

30 Apr '02

I found dtml-tree today, and it provides the exact UI I want to use. I even managed to make it work to display the contents of the current folder. I haven't yet seen any docs that describe how the dtml-tree works. The page that I will generate will be based on data from several SQL databases and consolidated by a Python Script. I need to know the structure of the data that dtml-tree expects and how to handle expansion requests. Any pointers, docs, discussions, or examples are greatly appreciated. -D -- Windows, hmmm, does it come with a GUI interface that works or just pretty blue screens? GnuPG key : http://dman.ddts.net/~dman/public_key.gpg

2 2

zpt wackyness
by Russell Uman 30 Apr '02

30 Apr '02

i have a main page template: index_html i have a number of content templates that i would like to include into my main page. the title property is set for each object: content_1, title = "number one" content_2, title = "number two" content_3, title = "number three" i'm trying to dynamically choose which content object to display based on a request variable. here is what i have in index_html: <HTML tal:define="page request/page | string:content_1"> <span tal:replace="python:container[page].title">title</span> <span tal:replace="structure python:container[page]">body</span> this is what i see if i browse to index_html?page=content_2 number one <ZopePageTemplate instance at 8960bf0> so the title is working! but the body is not. how can i get zope to include the contents of the object? is there a better way to translate a string into an object? if i make a call to tal:replace="container/content_1" i have no problems - i just can't figure out how to do this dynamically... thanks!

2 1