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

who can help you as this mailing list isn't the right place for further discussion of such basics. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] Zope_Database_issue

this is the case then Zope should start or at least give a different error. Please note that the errors you are experiencing are not related to Zope, Python or Postgres but unix and you should see if you can get some help from a sys admin in your company. Charlie -- Charlie Clark eGenix.com

Re: [Zope-DB] Zope_Database_issue

that you've installed. It cannot find the Postgres libraries and so cannot connect to the server. Once you've fixed this you ZPsycopgDA should work fine. Andreas has pointed out what you need to do. BTW. I think that you may well be better off with psycopg2 as the library. Charlie -- Charlie Clark

Re: [Zope-DB] Fwd: Zope_Database_issue

7.4.13, egenix 2.0.6 Psycopg 1.1.6 I am really in a mess! Really need your help! Hi Smita, if you can start Zope from the shell: bin/zopetcl fg You should get a Python traceback that says what is stopping the ZPsycopgDA starting. Charlie Clark -- Charlie Clark eGenix.com Professional Python

Re: [Zope-DB] My ORM is better than yours!

. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http

Re: [Zope-DB] Run Wxpython Script in Zope

Am 31.03.2009, 11:27 Uhr, schrieb Chris Withers ch...@simplistix.co.uk: get python running in the browser, which sadly is never going to happen) There is always Grail http://grail.sourceforge.net/ Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

it to the browser. But most importantly - in the Zope world the RDBMS is unlikely ever to be your bottleneck. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

already done this. Thanks and sorry for bothering you directly. Please let me know if not appropriate. While I don't mind the e-mail at all. It's always good to keep discussions like this on list so to that others can join in or benefit. Charlie -- Charlie Clark eGenix.com Professional Python

Re: [Zope-DB] [Zope] Stored Procedures Versus ZSQL Methods

system and it's worth it, especially if you can remove your dependency on ExternalMethods as well. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] Help me.

in Zope and there is a download with code for your to play with. http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/ Good luck! Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http

Re: [Zope-DB] ZMYSQLDA problem: Zope restarts after trying to open Z Mysql connection

is crashing for some reason. You need to enable debugging in zope.conf to get something in your event log but without shell access it might be difficult to trace the problem. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting

Re: [Zope-DB] Automatic capture of user ids for auditing

getting the attention they deserve in the Zope world at the moment. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http

Re: [Zope-DB] ImportError: libmysqlclient_r.so.15

get the same error message in the event.log file: Sounds like a permissions problem: the Zope user might not be allowed to access /usr/local/lib/mysql. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support

Re: [Zope-DB] Automatic capture of user ids for auditing

? for apache and either XUF or PAS for Zope, as both allow you to hold your users outside of Zope. I'm not sure whether you wouldn't still be stuck with the problem of having the connection tied to a one user while wanting to log another. Charlie -- Charlie Clark eGenix.com Professional Python

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

-- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com

Re: [Zope-DB] updating fields in a zsql method programmatically

-- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com

Re: [Zope-DB] updating fields in a zsql method programmatically

, or am I just going down a rat-hole? All form values are in the context.REQUEST.form dictionary which can overwrite to your heart's content. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http

Re: [Zope-DB] Reference DTML-sqlvar in ZPT?

. You might want to look at my presentation (with sample code) which touches on Zope and RDBMS. http://www.egenix.com/library/presentations/EuroPython2007-Zope-and-RDBMS/ Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support

Re: [Zope-DB] Reference DTML-sqlvar in ZPT?

an argument within ZPT without passing it or defining it? Please provide a code snippet. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

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

directly on the DA connection object if they are supported. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com

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

want the kind of direct access to a relation you get with the existing DA's. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http

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

Am 17.02.2007, 13:52 Uhr, schrieb Robert-Reinder Nederhoed [EMAIL PROTECTED]: Dear Nguyen, For as far as I know, mxODBC is free to use in a non-commercial environment. So you can freely use it for your research or graduation project. Once your school adopts your application, they can

[Zope-DB] Re: [egenix-support] DSN

Am 29.01.2007, 12:05 Uhr, schrieb Sven Plage [EMAIL PROTECTED]: Sehr geehrte Damen und Herren, ich habe in Zope eine mxODBC Database Connection angelegt und dort auch einen entsprechenden Database Connection String (DSN=testDB;DATABASE=testDB;UID=root;PWD=) angelegt. Nun möchte ich aus

Re: [Zope-DB] modifications on a query

Am 26.01.2007, 08:37 Uhr, schrieb Graziella Toutoungis [EMAIL PROTECTED]: 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 and he can

[Zope-DB] Re: Zope hungs: mxODBC + Progress ODBC on Windows

Am 22.01.2007, 11:54 Uhr, schrieb Pawel Lewicki [EMAIL PROTECTED]: Charlie Clark napisał(a): Am 22.01.2007, 11:24 Uhr, schrieb Pawel Lewicki [EMAIL PROTECTED]: Hi, I'm using a configuration from the subject. It's quite an old Zope 2.7 instance without prospects of upgrade because

[Zope-DB] Re: Zope hungs: mxODBC + Progress ODBC on Windows

Am 22.01.2007, 13:00 Uhr, schrieb Pawel Lewicki [EMAIL PROTECTED]: I know what's causing timeouts I can't help it now. It would still be useful to others: is it a database, network or driver issue. Increasing connection number doesn't help. I don't blame mxODBC as it is a great

Re: RE : [Zope-DB] How lunch SQL request from python script ?

Am 19.01.2007, 13:27 Uhr, schrieb Maciej Wisniowski [EMAIL PROTECTED]: Please, stay on the list First, isn't Charlie Clark solution good for you? It seems to be reasonable. Thanks! ;-) I have try to use external method but without success... (I have read some post as you suggested

Re: [Zope-DB]found reason: sql query works in database connector but not in ZSQL method

Am 19.01.2007, 17:50 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: it in deed seems not to work. however I do not understand why. If you use callproc() we could probably help you. This is now academical as I resolved to not to use stored procedures that return a record set (tough its a

Re: [Zope-DB] How lunch SQL request from python script ?

Am 18.01.2007, 11:52 Uhr, schrieb CERETTO Thierry [EMAIL PROTECTED]: select distinct c.id_risque, c.libelle_risque, c.id_fiche, c.id_portee, c.url_info from (mots a join amotrisque b on a.id_mot = b.id_mot ) join risques c on b.id_risque = c.id_risque where a.mot_MAJ like

Re: [Zope-DB]found reason: sql query works in database connector but not in ZSQL method

Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: I think I found the reason, for my problems with stored procedures. it seems that on can not call a stored MySQL 5.0x procedure from zope that returns a data set. If you use the mxODBC Zope DA callproc() method then you

Re: [Zope-DB] sql query works in database connector but not in ZSQL method

Am 17.01.2007, 15:42 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: Hi there, I try the following statement: CALL selectVertexProperties(1, @error2) when I execute this directly in the test window of the database connection, it works fine. when i execute the same line in the test window of a

Re: [Zope-DB] sql query works in database connector but not in ZSQL method

Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: If tried that, but somehow I did not get it rigth: questions: - - the first parameter is an integer, how do I force that? int(para) ? - - the second parameter is an out parameter, how do I specify that ? You don't, I

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

Am 10.01.2007, 13:00 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: I understand that there is a way to handle transaction control in the ZMySQL methods. However I find no documentation at all on how to use it. This is incorrect. ZSQL methods are called within Zope transactions so you

Re: [Zope-DB] Basic tsql example using MxODBC Zope DA adaptor?

Am 04.01.2007, 18:47 Uhr, schrieb [EMAIL PROTECTED] [EMAIL PROTECTED]: Hello Everyone, I am relatively new to Zope/Plone, as well as the MxODBC Zope DA adaptor. I am wondering if someone could point me to a basic example that would illustrate how to use the MxODBC Zope DA adaptor outside

Re: [Zope-DB] How do I use my archetypes-generated form to insert data into a mysql table?

for item in request.form.keys(): validate(item) if no_errors: context.SQL.someZSQLMethod(dictionary_of_items) return context.thank_you_page() else: return context.error_page() Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source

Re: [Zope-DB] Pitfall: mxODBCZopeDA and test runner in 2.9+

Am 16.10.2006, 15:10 Uhr, schrieb Chris Withers [EMAIL PROTECTED]: Charlie Clark wrote: Technically you should actually use $INSTANCE_HOME/modules at least for Never heard of 'modules' before, where did you read about this? My bad - I'm sure I saw it on one of the more recent Zope versions

Re: [Zope-DB] Error in Shared.ZRDB.Connection.__setstate__ in 2.9.4

is exc_info=True to grasp as a concept? Don't shoot the messenger! I've hardly touched the logging module so I'll plead ignorance (as well as stupidity ;-). But for 2.10 it is a big error if zLog is officially being deprecated. I'll submit a bug. Charlie -- Charlie Clark eGenix.com Professional

Re: [Zope-DB] Error in Shared.ZRDB.Connection.__setstate__ in 2.9.4

... Oops, I submitted a duplicate bug (I did try looking beforehand) which has been rejected as already fixed - it certainly isn't in the 2.10 which can be downloaded. Will this automatically get the change which _has_ been made to trunk? Charlie -- Charlie Clark eGenix.com Professional

Re: [Zope-DB] Pitfall: mxODBCZopeDA and test runner in 2.9+

SOFTWARE_HOME rather than INSTANCE_HOME which should protect. Charlie -- Charlie Clark eGenix.com Tel: +49-211-600-3657 GSM: +49-178-782-6226 Professional Python Services directly from the Source ___ Zope-DB mailing list Zope-DB@zope.org http

Re: [Zope-DB] free database adapters ,...

. Charlie -- Charlie Clark eGenix.com Tel: +49-211-600-3657 GSM: +49-178-782-6226 Professional Python Services directly from the Source ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Getting a cursor?

Am 27.09.2006, 23:44 Uhr, schrieb Paul Winkler [EMAIL PROTECTED]: Any suggestions? p.s. I'll be asking egenix too, we'll see if they reply to help requests without a purchased license... but then, if I can't get this to work there's no point in purchasing one :-] Why shouldn't we answer

Re: [Zope-DB] Working with ZPsycopgDA (or any DA) - commiting

Am 11.08.2006, 16:56 Uhr, schrieb [EMAIL PROTECTED]: Hi I'm working with a Postgresql database which I have to insert a lot of data to... I'm using the ZPsycopgDA database adapter, and ZSQL methods. I have noticed that though I am calling the zsql method no data gets really commited to the

Re: [Zope-DB] ZPsycopgDA connection failing

On 2006-06-07 at 16:17:13 [+0200], Davis Mr MR [EMAIL PROTECTED] wrote: Hi, My connection to Postgres keeps failing every couple of hours. I did read that there was a problem with some versions of this. I'm using 2.0b6 at the moment. Does anyone have a version number that I can try that

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

On 2006-04-06 at 16:34:01 [+0200], Jamie O'Keefe [EMAIL PROTECTED] wrote: On 4/6/06, Charlie Clark [EMAIL PROTECTED] wrote: This still should not be causing this problem. Jamie, you should be talking to the DBA or looking at the DB side of things. Well it is a volunteer operation, so

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

range of problems. I prefer it over MySQL but I am not convinced that switching to PostgreSQL will solve your problems and, of course, will involve all the work of migration. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting

Re: [Zope-DB] ZSQL + MySQL + sqltest + list

variable. catID = [int(i) for i in catIDs] Cleaner and quicker than playing the dtml-sqltest. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] my query:I am having one database, I want to retrieve the data as and when loged on

for that What an incredibly rude e-mail! The answer is: read some documentation and also learn how to write to e-mails! -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] TAL and empty sql-list

On 2006-03-21 at 15:21:29 [+0100], Jimmy small [EMAIL PROTECTED] wrote: sorry for the double post -- A python script would be your best bet. You would be able to use that in other areas of your site in that case. At least as long as TALES doesn't support this directly. In a PythonScript you

Re: [Zope-DB] News Item properties

On 2006-02-27 at 17:31:09 [+0100], [EMAIL PROTECTED] wrote: Ciao, sto cercando di visualizzare su un page template zope (che tra l'altro e' l'home page index_html) l'ultima news inserita via plone. Ciao, scrive al'inglese per favore. Charlie Clark -- Charlie Clark eGenix.com

Re: [Zope-DB] News Item properties

is for questions about Zope and relational databases and the ZODB. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com

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

On Thu, 09 Feb 2006 08:03:49 +0100, Andreas Jung [EMAIL PROTECTED] wrote: And btw. _learn_ how to post. Sending a three line posting as a 44 KB large mail containing html and lots of images is only _disgusting_. If you do expect help from community then stick to their basic rules. The

Re: [Zope-DB] external ZODB from Zope interface

On Thu, 02 Feb 2006 16:25:09 +0100, gyro funch [EMAIL PROTECTED] wrote: Thanks for the very useful reference. However, I don't see anything in there about accessing a ZODB. I may have missed something, but I don't see a suitable ZODB adapter that I can add in the Zope interface (similar to

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

On Mon, 23 Jan 2006 10:24:04 +0100, Chris Withers [EMAIL PROTECTED] wrote: Charlie Clark wrote: Hi Chris, are you using Zope 2.8.5 or Zope 2.9.0 or are they the same thing? 2.8.5. I find the fact that you ask if 2.8.5 and 2.9.0 are the same thing quite scary... You shouldn't worry too

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

On Mon, 23 Jan 2006 11:53:41 +0100, Chris Withers [EMAIL PROTECTED] wrote: Charlie Clark wrote: You shouldn't worry too much! I'd just installed the FreeBSD port for 2.9.0 which was actually 2.8.5! Haha... okay, that just makes me even more scared of FreeBSD... Oh, it shouldn't

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

On Fri, 20 Jan 2006 08:27:25 +0100, Chris Withers [EMAIL PROTECTED] wrote: DeprecationWarning: __init__.py of Products.mxODBCZopeDA has a long deprecated 'methods' attribute. 'methods' will be ignored by install_product in Zope 2.10. Please use registerClass instead. DeprecationWarning)

Re: [Zope-DB] I need urgent help !!!

with others for a single sign-on but you need to provide more information about the system you wish to integrate with. If you search zope.org for UserFolder then you will see some of the solutions available. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from

Re: [Zope-DB] database connection

On 2006-01-10 at 12:50:41 [+0100], Martin Krallinger [EMAIL PROTECTED] wrote: Hi all, I am using zope to connect to my postgres database using psycopg. Everything works fine, I can connect to the db and do queries, the first 20 results are displayed correctly, but when I want to display

Re: [Zope-DB] database connection

write a report page with your own batching mechanism to pass the parameters through. I think this has been fixed in versions of Zope 2.7 Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http

Re: [Zope-DB] User Authentication

are using XUF so you might want to direct your question there. XUF is configured to present you with the login page if you give the wrong details. You should check the error log for full details. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

On 2005-12-06 at 10:48:29 [+0100], Chris Withers [EMAIL PROTECTED] wrote: Charlie Clark wrote: I wonder how the two methods compare efficiency-wise? Yes, well, we're talking about MySQL specifically ;-) Well, with reference to Zope we shouldn't be... Huh? the original poster

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

On 2005-12-05 at 08:42:09 [+0100], Chris Withers [EMAIL PROTECTED] wrote: Charlie Clark wrote: SELECT count(attribute) FROM relatiin WHERE condition Ah, okay, now I gotcha... only returns 1 result so it's independent of LIMIT and result sets. I wonder how the two methods compare

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

On 2005-12-02 at 10:33:34 [+0100], Chris Withers [EMAIL PROTECTED] wrote: Charlie Clark wrote: That doesn't work if you use offsets and limits to only return part of a result set... SELECT count(attribute) FROM relatiin WHERE condition Ah, okay, now I gotcha... only returns 1

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

the archives for that. But that is wrong. If you want to count the number of records, use count() Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter

Re: [Zope-DB] insert failing without raising exception: postgresql, psycopg

series. In addition you might want to try using our mxODBCZopeDA to see if the error is with the DA/driver or in Zope itself. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com

Re: [Zope-DB] dumb INSERT Question

? Does it have something to do with the int data type? I am comparing it vs. a working INSERT, and everything looks the same. TIA!!! I'm going crazy looking at for errors! UserID != userId variables in Python are case sensitive. Charlie -- Charlie Clark eGenix.com Professional Python

RE: [Zope-DB] ZPTs and database accesses

calls the ZSQL method and passes the parameters. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC

Re: [Zope-DB] Null characters booleans

On 2005-04-08 at 10:44:59 [+0200], Andrew Veitch [EMAIL PROTECTED] wrote: We'd be willing to provide patches for both these issues if there's interest and agreement it's a sensible way to go. The most sensible thing is if the DA does not have to do the quoting at all and that this is either

Re: [Zope-DB] Creating a hyperlink using results from query

Martin, read up on doing this with PageTemplates. You need to use the TALES keyword attributes Something similar to block tal:repeat=result myQuery a tal:attributes=href result/link tal:content=result/value/a /block is what you want. Charlie -- Charlie Clark eGenix.com Professional Python