--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 -
--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
--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
--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
--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...
--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
--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
--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
--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.
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
---
- Andreas JungZOPYX Ltd. Co KG-
- E-mail: [EMAIL PROTECTED] Web: www.zopyx.com, www.zopyx.de -
---
pgpt9j8A3STBo.pgp
Description: PGP signature
--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
--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
--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
--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
--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
--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
--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.
-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
--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
--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
--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
--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
--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
--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
--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
--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
--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
--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
--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
--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?
--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
--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
===
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
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.
--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
--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
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
--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
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
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
-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
-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
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
-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
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
-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
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
-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:
-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
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
51 matches
Mail list logo