[Zope] MySQL questions

2000-06-16 Thread Rogerio Atem de Carvalho
Hi, I am a Zope Newbie and would like to ask some questions regarding to Zope + MySQL: 1)How can I upload file content to TEXT (plain text) and BLOB (images: jpg, gif) using DTML? 2)How can I create interface fields with multiple lines to edit (insert and update) MySQL text columns? 3)Is th

[Zope] Selection

2000-06-21 Thread Rogerio Atem de Carvalho
Hi, I am using sql to fill a selection, following a How-To. When I try to pass the selection plus some text parameters to a sql method, Zope gives me an error. Aparently, the selectioned value is not being passed as a value to the sql. How can I pass the selectioned value as a parameter? Rega

Re: [Zope] More reliable Database Adapter for linux

2000-06-22 Thread Rogerio Atem de Carvalho
> > Maybe the correct question is the most reliable combo >DA+DB. > > Regards. > >How about: Zope+ZODB ? I have a question: Will ZODB have something like OQL? The problem in using ZODB is to do simple queries and link different class object instances in queries (SQL join). It is hard to do

[Zope] Cache X MySQL

2000-06-26 Thread Rogerio Atem de Carvalho
Dear coleagues, I decided to use Zope as an Interface to maintain and search a touristic information database. All text is stored in MySQL tables and images will be stored outside the database, for cache reasons (I will keep only the path as TEXT columns in MySQL tables). My question is: for

[Zope] LocalFS and Cache Issues

2000-06-28 Thread Rogerio Atem de Carvalho
I am using a combination of Zope to create and maintain a MySQL database. This database is full of images files so I decided to keep them outside MySQL for caching facilities. My question are: 1)image files referenced by LocalFS objects are cached by Zope? and 2)In this situation do I need to

[Zope] Re: ZODB or not ZODB?

2000-06-29 Thread Rogerio Atem de Carvalho
> Jim Fulton writes: > > In theory, you could use ZCatalog to catalog objects in the > > file system or in a RDBMS, providing that you can provide > > paths for them. I don't think anyone's done this yet. There > > are bound to be bumps from wjoever does it first. :) > I use ZCatalog to c

[Zope] Namespace question

2000-06-29 Thread Rogerio Atem de Carvalho
Hi, I working on an structure like this: folder1 | folder11 | folder111 I have some objects in folder111 which I want to pass as parameters to a dtml method in folder1 (two levels above). I tried something like: where par1 and par2 are strings and

[Zope] File referencing and LocalFS

2000-07-03 Thread Rogerio Atem de Carvalho
I am using LocalFS to refer to a directory structure like this: folder1 | folder11 There are image (.jpg) files in both folders. I have two questions about this: 1)Folders names are directly related to string fields in a MySQL database which use spaces between words (eg New York)

[Zope] CachePool + LocalFS

2000-07-09 Thread Rogerio Atem de Carvalho
Hi, I am still looking for a simple caching soluction for external files... Can I use CachePool to cache LocalFS referenced objects? If I can, how can I do that? Regards, Rogerio Atem --- E-mail enviado pelo servidor do CEFETCampos ___

[Zope] Products and 2.2 Final

2000-07-18 Thread Rogerio Atem de Carvalho
Just a simple question: I am using 2.1.6 with LocalFS, CachePool, SQL Input Wizard, MetaPublisher and others... I am thinking now in upgrading to 2.2 final. Is there any product that is not compatible with 2.2 final? regards, Rogerio Atem --- E-mail en

[Zope] LocalFS and Image Files

2000-07-19 Thread Rogerio Atem de Carvalho
Hi, I am using LocalFS to refer to image files (.jpg). I tried localfsObj['imagefile.jpg'] but it doesn't render the image. The same occurs inside Zope management interface, i.e., if I try "view", it shows me a broken link. I am testing it on 2.1.6 Win32, but it will go online in 2.1.7 Linux

[Zope] Static X Dynamic

2000-08-03 Thread Rogerio Atem de Carvalho
Hi, I have a site with 1,000 static HTML pages containing images and text (in portuguese and english). I need: 1) Enable full text search 2) Create a mechanism to automatically generate more pages and put everything together in Zope. 3)Work under Zope versions 2.1.6 and 2.2 I know some alte

[Zope] General Full Text Search Questions

2000-08-08 Thread Rogerio Atem de Carvalho
Hi, I have some general Full text search questions, hope someone can help me: 1)How can I use ZCatalogue to do full text search on static html pages? In Zcatalogue examples I could find search for properties like Title, I would like to have the whole text content of a static html searched.

[Zope] Re: General Full Text Search Questions

2000-08-08 Thread Rogerio Atem de Carvalho
Sorry, I mixed Portuguese and English. Where you read "Zcatalogue" in my previous posting, please read "Zcatalog". Sorry one more time. Regards, Rogerio Atem --- E-mail enviado pelo servidor do CEFETCampos

[Zope] Zope based ERP5 on O'Reilly Book

2007-07-15 Thread Rogerio Atem de Carvalho
The Zope based ERP project ERP5 has on chapter on the O'Reilly book Beautiful Code: Leading Programmers Explain How They Think http://www.amazon.com/Beautiful-Code-Leading-Programmers-Explain/dp/0596510047 The book features well known authors such as Brian Kernighan, Jon Bentley, Charles Petzold,