Re: [Zope-DB] bulk connection change

2005-04-09 Thread Andreas Jung
--On Samstag, 9. April 2005 11:41 Uhr +0100 garry saddington [EMAIL PROTECTED] wrote: I have many ZSQL queries for which I use Zpsycopg connector on my linux machine. On my Windows machine (laptop) I want to use another connector as Zpsycopg refuses to work and I hate messing with windows -

Re: [Zope-DB] Python Script / ZSQL

2005-05-10 Thread Andreas Jung
--On Dienstag, 10. Mai 2005 18:24 Uhr -0700 Infor Gates [EMAIL PROTECTED] wrote: dtml-call insertZSQL tal:def define=dummy python: context.somemethod(arg1=..., arg2=...) / (which is documented in the Zope Book 2.7 edition - RDBMS chapter) -aj pgpGEM6zFQaUv.pgp Description: PGP signature

Re: [Zope-DB] Using psycopg directly in Zope Python script

2005-07-01 Thread Andreas Jung
--On 1. Juli 2005 23:28:51 +0200 Jørgen Frøjk Kjærsgaard [EMAIL PROTECTED] wrote: Does Zope somehow create a restricted environment where opening a database connection is impossible? Is there a way to bypass that restriction? That's a misuse of PythonScripts. They are not designed to

Re: [Zope-DB] Get the name of the database

2005-11-10 Thread Andreas Jung
--On 10. November 2005 13:59:41 +0100 Jochen Knuth [EMAIL PROTECTED] wrote: Hi, is there a way to get the name of the database from a database connection object? Connection settings are stored specific to implementation of every DA. You have to look the sources of your DA how it stores

Re: [Zope-DB] related to Plone+Zope+MySQL

2005-11-10 Thread Andreas Jung
--On 11. November 2005 14:27:49 +0700 -bhavana - [EMAIL PROTECTED] wrote: Dear all, i have connection with MySQL from Zope and Plone and i create search from Zope and Plone too. But i cant search from the portlet that is in Plone interface to MySQL database. Please help me out of this...

Re: [Zope-DB] Suggestions If Any Please ! ! ! ! !

2005-11-17 Thread Andreas Jung
--On 18. November 2005 12:58:46 +0530 Rajesh [EMAIL PROTECTED] wrote: Hi All, I'm Having problem in Zsql Method ,which return recordset dictionary,containing key--.value pairs, this recordset returns only 1000 records ,Even if my Sql query satisfies more than 1000 records

Re: [Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system

2006-01-13 Thread Andreas Jung
--On 13. Januar 2006 11:12:22 +0100 Michele Simionato [EMAIL PROTECTED] wrote: I have discovered that the values in the dtml-comment are not honored: so if I change max_rows_ to a different value nothing happens. Zope always retrieve up to 1000 rows, which is the default value fixed

Re: [Zope-DB] How I can connect MySQL database?

2006-02-08 Thread Andreas Jung
--On 9. Februar 2006 10:01:45 +0800 G E R R I T [EMAIL PROTECTED] wrote: How I can connect MySQL database from my zope web project? e.q.: create login form with information save on MySQL database. Insert, update and delete information on MySQL database. Use query on project. Did you

Re: [Zope-DB] How I can connect MySQL database?

2006-02-08 Thread Andreas Jung
--On 9. Februar 2006 10:01:45 +0800 G E R R I T [EMAIL PROTECTED] wrote: How I can connect MySQL database from my zope web project? e.q.: create login form with information save on MySQL database. Insert, update and delete information on MySQL database. Use query on project. And btw.

Re: [Zope-DB] strange date problem: 2015-11-23 08:10

2006-02-14 Thread Andreas Jung
You might check your system clock first. -aj --On 14. Februar 2006 09:17:17 +0100 Marc Petitmermet [EMAIL PROTECTED] wrote: dear list members i have a strange date problem: when creating zope objects, like a zope file or folder, the date is always set to 2015-11-23 08:10. this is

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Andreas Jung
--- - Andreas JungZOPYX Ltd. Co KG- - E-mail: [EMAIL PROTECTED] Web: www.zopyx.com, www.zopyx.de - --- pgpt9j8A3STBo.pgp Description: PGP signature

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Andreas Jung
--On 6. April 2006 21:51:05 +0200 Charlie Clark [EMAIL PROTECTED] wrote: On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: Hi Dieter, We switched to Postgres, MySQL is used only for legacy components. Isn't postgres linux only? We use FreeBSD. PostgreSQL was

Re: [Zope-DB] Help request from a non-developer

2006-04-14 Thread Andreas Jung
--On 14. April 2006 18:19:38 +0200 Christophe Appell [EMAIL PROTECTED] wrote: On 4/14/06, Andreas Jung [EMAIL PROTECTED] wrote: Can you give me an idea of the level of effort to accomplish this partial data abstraction ? This depends really on your individual use case. Sometimes you have

Re: [Zope-DB] Database connection in a file system product

2006-04-27 Thread Andreas Jung
--On 27. April 2006 10:54:23 +0200 Jonas Nielsen [EMAIL PROTECTED] wrote: Is it possible to store a database connection (i.e. a Z MySQL Database Connection) in a file system product ? How ? What is the sense? You can not store persistent objects. You might store a reference to the object

Re: [Zope-DB] Unicode - ISO 8859-1 conversion

2006-06-02 Thread Andreas Jung
--On 2. Juni 2006 12:08:09 +0200 Jonas Nielsen [EMAIL PROTECTED] wrote: I have a MySQL database with text in ISO 8859-1. However Plone displays strings in UTF-8. I am looking for a function to convert between ISO 8859-1 and unicode. (I am /not/ looking for a way to change how the strings are

Re: [Zope-DB] zope-db@zope.org

2006-08-19 Thread Andreas Jung
--On 18. August 2006 15:20:09 -0700 Rick Wagner [EMAIL PROTECTED] wrote: On Aug 18, 2006, at 2:47 PM, Roberto Benitez wrote: Does anyone know where i can get a working database adapter for zope 2.8/2.9? You may want to specify the type of database you need to access. ..and read the

Re: [Zope-DB] ZOPE and find in files feature

2006-08-20 Thread Andreas Jung
--On 20. August 2006 05:51:18 -0400 Harry Spier [EMAIL PROTECTED] wrote: Dear list members, I am a Python programmer but not familiar with ZOPE. I am building a website with a MYSQL database of text documents (several thousand). I need to construct a feature similar to a find in files

Re: [Zope-DB] Some help about introductory Zope concepts.

2006-09-06 Thread Andreas Jung
--On 6. September 2006 08:42:40 +0200 Jose Carlos Balderas Alberico [EMAIL PROTECTED] wrote: Hi, I have a few beginner's questions regarding Zope. I need your help to help me clarify some concepts that remain unclear for me still. Sorry, but this list is for Zope database issues only.

Re: [Zope-DB] Sybase Adapter error :: alternatives?

2006-12-27 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On 27. Dezember 2006 11:28:25 -0300 Pablo Avalos [EMAIL PROTECTED] wrote: Hi guys Sadly I'm stuck here at work with some Sybase DB, and I need to get some info to the intranet plone-site.. I've found the SybDAv2 but it's dead old and

Re: [Zope-DB] modifications on a query

2007-01-25 Thread Andreas Jung
--On 26. Januar 2007 07:37:25 + Graziella Toutoungis [EMAIL PROTECTED] wrote: Hello, I use zope2.9.4 with postgresql8.1, in my database i have some tables are the result of a query on other tables. exe: table1 is the result of table2 with table3 My user can connect to the database

Re: [Zope-DB] Please help me about driver adapter

2007-02-17 Thread Andreas Jung
--On 17. Februar 2007 19:35:22 +0700 Nguyen Viet Minh Quang [EMAIL PROTECTED] wrote: If you know about pymssql, please help me. This module is not widely used. It you don't want to stick with the mainstream stuff you have to fight and struggle. The best practice solution is mxODBC. -aj

Re: [Zope-DB] zmysql filesystem database connection

2007-03-19 Thread Andreas Jung
--On 19. März 2007 10:09:06 +0100 javi lopez [EMAIL PROTECTED] wrote: hello everyone how to do a filesystem database connection?? I need it for my product, how to create it?? You asked already on the Zope list and got some answers. -aj pgpshkdQdZuJy.pgp Description: PGP signature

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-03-25 Thread Andreas Jung
--On 25. März 2007 23:54:14 +0200 Maciej Wisniowski [EMAIL PROTECTED] wrote: In the Zope 2 worlds we have dedicated database adapters for different databases. Fortunately the Python world made us a wonderful present called SQLAlchemy that abstracts the different databases. In the Zope world

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-03-26 Thread Andreas Jung
--On 26. März 2007 22:21:02 +0200 Dieter Maurer [EMAIL PROTECTED] wrote: Andreas Jung wrote at 2007-3-25 17:49 +0200: In the Zope 2 worlds we have dedicated database adapters for different databases. Fortunately the Python world made us a wonderful present called SQLAlchemy that abstracts

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-03-26 Thread Andreas Jung
--On 26. März 2007 22:49:21 +0200 Maciej Wisniowski [EMAIL PROTECTED] wrote: My posting says *nothing* about deprecating something. So __please__ stop reading between the lines when there is nothing - except whitespaces. But you said about *replacing* all different zope DAs. So I think it

Re: [Zope-DB] General Recommendations for a MySQL Connection

2007-04-23 Thread Andreas Jung
--On 23. April 2007 11:46:58 -0400 [EMAIL PROTECTED] wrote: Hi all, I could use a recommendation on connecting to MySQL databases. I'll keep it short and say that we have a few apps now that connect to MySQL and that have taking a 'wrong turn' in development. I think fulfilling these

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-04-30 Thread Andreas Jung
--On 26. März 2007 22:49:21 +0200 Maciej Wisniowski [EMAIL PROTECTED] wrote: My posting says *nothing* about deprecating something. So __please__ stop reading between the lines when there is nothing - except whitespaces. But you said about *replacing* all different zope DAs. So I think it

Re: [Zope-DB] Connecting FileMaker with Zope

2007-05-03 Thread Andreas Jung
--On 3. Mai 2007 10:44:36 +0100 David Daniel Estévez Durey [EMAIL PROTECTED] wrote: Hello, I am trying to connect my FileMaker database with Zope, so I need a Zope Database Adapter for FileMaker. I haven't founded any in the Zope site, in exception of mxODBC Zope DA, but this bridge isn't

Re: Fwd: [Zope-DB] Connecting FileMaker with Zope

2007-05-03 Thread Andreas Jung
--On 3. Mai 2007 11:14:10 +0100 David Daniel Estévez Durey [EMAIL PROTECTED] wrote: Thank you very much for answering. I'm reading the documentation of SQLAlchemy project, but I'm realizing that FileMaker isn't supported: http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported

Re: [Zope-DB] FileMaker with Zope

2007-05-22 Thread Andreas Jung
--On 22. Mai 2007 13:54:14 +0100 David Daniel Estévez Durey [EMAIL PROTECTED] wrote: Hello, I'm trying to connect FileMaker with Zope through ODBC, but I'm not sure if I could do this for free, without buying any driver or software. Can anyone explain to me how to do it or if it isn't

Re: [Zope-DB] FileMaker with Zope

2007-05-23 Thread Andreas Jung
--On 23. Mai 2007 10:50:40 +0100 David Daniel Estévez Durey [EMAIL PROTECTED] wrote: Hello Andreas! First of all, thank you very much for answering. Yes! of course I took all advices into account, and then someone told me that I could make an ODBC connection. Have you tried SQLAlchemy?

Re: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-13 Thread Andreas Jung
--On 13. Juni 2007 21:11:08 -0400 Ken Winter [EMAIL PROTECTED] wrote: I have a question (stated in three different ways) about the following ZSQL method: 1. Will it *always* return the person_id of the person that it just inserted? You have to answer this question your self. It depends on

RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

2007-06-14 Thread Andreas Jung
--On 14. Juni 2007 10:41:46 -0400 Ken Winter [EMAIL PROTECTED] wrote: -Original Message- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 12:54 AM To: Ken Winter; 'Zope-DB List' Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction

[Zope-DB] [ANN] SQLAlchemyDA 0.3.0 released - a generic database adapter for Zope 2

2007-06-16 Thread Andreas Jung
=== SQLAlchemyDA is licensed under the Zope Public License 2.1. See LICENSE.txt. This release has been funded by Renovis, SF, USA. Andreas Jung -- ZOPYX Ltd. Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-16 Thread Andreas Jung
First, Jaroslav is right. One time you're passing a string and next your passing a list. Make your choice how the API should looks like. Second..it would be *really* helpful to see the full traceback instead of just *Keyerror*. It's somewhat boring to ask every time for it :-) -aj --On 16.

Re: [Zope-DB] Connecting Zope 3 to Oracle 10g

2007-07-15 Thread Andreas Jung
--On 16. Juli 2007 12:31:50 +1000 Catriona Johnson [EMAIL PROTECTED] wrote: Hello I am a novice Zope 3 user and would like some help in the best method to connect to an existing Oracle instance using Zope 3. The reason I want to do this is to take advantage of Oracle's spatial data types

Re: [Zope-DB] Reading Oracle BLOBS from Zope

2007-09-08 Thread Andreas Jung
--On 7. September 2007 15:08:48 -0400 Kenneth A. Englund [EMAIL PROTECTED] wrote: I want to read an Oracle BLOB and display it. I have seen several examples on the internet, but none of them seem to work. I am on the following platform: Zope Version (Zope 2.6.1 (source release, python

Re: [Zope-DB] compiling dco2.c with Oracle 10g using mingw on Windows XP - interesting errror

2007-12-05 Thread Andreas Jung
You might consider using cx_oracle as an alternative to DCO2. cx_oracle could be integrated with Zope as an DA using SQLAlchemyDA (although untested). DCO2 is pretty old and seems to be unmaintained. -aj --On 5. Dezember 2007 18:32:14 -0600 Maan M. Hamze [EMAIL PROTECTED] wrote: I

Re: [Zope-DB] Help me.

2008-03-11 Thread Andreas Jung
--On 11. März 2008 22:13:29 +0700 Cu Vinh Loc [EMAIL PROTECTED] wrote: Dear friends, I am using plone for deploying the website, but I have some problems such as: - Using relational (internal) database Gadfly database: I do not know where the database is stored in the Zope. Please

Re: [Zope-DB] Zope - Oracle Database Connection

2008-11-30 Thread Andreas Jung
If you are on Windows, you might consider using something based on ODBC (mxODBC (commercial but considered good) or some free variant (check zope.org)). If you are on Unix, you might consider installing cxoracle (for the Python bindings to Oracle) + SQLAlchemy as ORM (re-using cxoracle). If you

[Zope-DB] [Fwd: Re: Zope - Oracle Database Connection]

2008-11-30 Thread Andreas Jung
Andreas i am using zope for windows , i have downloaded DAOracle from zope site and installed the same . but i'm getting the same error Please help me Regards Nachs Andreas Jung wrote: If you are on Windows, you might consider using something based on ODBC (mxODBC (commercial but considered

Re: [Zope-DB] Question Concerning Z SQL Method and Class Bindings

2010-05-25 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark Phillips wrote: Peter, I don't think I phrased my question very well. Also, I am coming from a Java background, so I am thinking about result sets, which may not be applicable to Python. If I have a Z SQL Method query that returns

Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

2010-08-24 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would assume that you can use DTML-IN for looping and generating multiple SQL statements of the same kind. You have to ensure that the statements having a proper delimiter (there was something in DTML?! DTML-SQLDELIMITER?...no idea, you need to

Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

2010-08-25 Thread Andreas Jung
2010/8/25 Jaroslav Lukesh luk...@seznam.cz - Puvodní zpráva - Od: Andreas Jung li...@zopyx.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would assume that you can use DTML-IN for looping and generating multiple SQL statements of the same kind. You have to ensure

Re: [Zope-DB] Migrating zope from Windows to Linux

2010-10-27 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joel Fitzgerald wrote: Hi all, we currently have a document management system running on a zope platform on a Windows 2003 server. We would like to investigate migrating this to a Linux OS. Is this something that is achievable? Is there any

Re: [Zope-DB] Zope_Database_issue

2010-11-16 Thread Andreas Jung
Try using Products.SQLAlchemyDA instead. -aj 2010/11/16 smita kamdar smita.kamda...@gmail.com Hi, I am a beginner in zope with no prior experience. I am supposed to setup a development environment with zope, postgres, python, openflow, egenix psycopg. I have installed all of them

Re: [Zope-DB] Zope_Database_issue

2010-11-17 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 smita kamdar wrote: *ImportError: libpq.so.3: cannot open shared object file: No such file or directory* This error message is self-speaking - either the Postgres library is not present or at a different place. Adjust your LD_LIBRARY_PATH as

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Andreas Jung
also while installing Psycopg I gave the same path of Postgres library. Now what else I need to do? Thanks a lot!! -- Forwarded message -- From: *Andreas Jung* li...@zopyx.com mailto:li...@zopyx.com Date: Thu, Nov 18, 2010 at 1:14 PM Subject: Re: [Zope-DB

Re: [Zope-DB] Fwd: Zope_Database_issue

2010-11-19 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you are resistent reading advices. We adviced you to use psycopg2 instead of psycopg1 psycopg2 is a *mandatory* requirements for using ZPsycopgDA. So please follow our recommendations instead of trying the wrong things. - From my experience:

Re: [Zope-DB] Zope-db[Zope_Openflow_installation]

2010-11-26 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OpenFlow has nothing to do with zope-db. Please ask on the z...@zope.org mailing list. Apart from that Openflow is dead. - -aj smita kamdar wrote: HI, I am supposed to install Openflow-0.0.1 on LINUX box. I installed it following the below

Re: [Zope-DB] questions

2013-04-11 Thread Andreas Jung
Zope used the related Python-DB API compatible driver with some integration and boilerplate code in order to integrate the Zope transaction mechanism with the transaction mechanism of the database (rollback vs. commit). There are additional (optional) integration layers working on top of