Re: [Zope-DB] [ZODB-Dev] How to extract users info from ZODB?

2012-01-25 Thread Charlie Clark
is not stored in the ZODB as, except in rare cases such as RelStorage, the majority of data of a Zope server will be stored in the ZODB. Finally, I must point out that Zope 2.6 is a very old and no longer supported release. Charlie Clark -- Charlie Clark eGenix.com Professional Python Services directly

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

2010-11-24 Thread Charlie Clark
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

2010-11-22 Thread Charlie Clark
running on RHEL in which case I would hope you there will be some kind of Red Hat curated packages. Other than that I think you're stuck but you might try asking on initd.org Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting

Re: [Zope-DB] Zope_Database_issue

2010-11-19 Thread Charlie Clark
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] Fwd: Zope_Database_issue

2010-11-19 Thread Charlie Clark
in unix to help you. I'm no unix whizz myself but installing Zope 2, psycopg2 and ZPsycopgDA is pretty straightforward if you follow the instructions. Charlie -- Charlie Clark eGenix.com Professional Python Services directly from the Source Python/Zope Consulting and Support ...http

Re: [Zope-DB] Zope_Database_issue

2010-11-18 Thread Charlie Clark
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

2010-11-17 Thread Charlie Clark
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!

2010-08-25 Thread Charlie Clark
. 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

2009-03-31 Thread Charlie Clark
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

2009-02-18 Thread Charlie Clark
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

2009-02-18 Thread Charlie Clark
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

2009-02-18 Thread Charlie Clark
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.

2008-03-11 Thread Charlie Clark
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

2007-12-04 Thread Charlie Clark
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

2007-11-07 Thread Charlie Clark
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

2007-11-07 Thread Charlie Clark
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

2007-11-06 Thread Charlie Clark
? 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

2007-09-08 Thread Charlie Clark
-- 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

2007-08-27 Thread Charlie Clark
-- 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

2007-08-27 Thread Charlie Clark
, 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?

2007-07-30 Thread Charlie Clark
. 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?

2007-07-30 Thread Charlie Clark
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?

2007-06-16 Thread Charlie Clark
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?

2007-03-26 Thread Charlie Clark
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] form-controllerPythonScript-ZSQL

2007-03-07 Thread Charlie Clark
Am 07.03.2007, 10:35 Uhr, schrieb javi lopez [EMAIL PROTECTED]: Hello everyone: i´m doing a form where i get email and one ask. when I check that email is valid, I do Controller Python Script where i want to create: Why do you need a DB connection per user? You can't do this in a

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

2007-02-17 Thread Charlie Clark
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

2007-01-29 Thread Charlie Clark
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

2007-01-26 Thread Charlie Clark
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

Re: RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Charlie Clark
Am 26.01.2007, 14:17 Uhr, schrieb Graziella Toutoungis [EMAIL PROTECTED]: curs.execute(DROP TABLE test_fetch) #curs.execute(createQuery) i will integrate in zope this code to create a form in order to give the users the capability to manage my database. any suggestions? Yes, you

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

2007-01-22 Thread Charlie Clark
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

2007-01-22 Thread Charlie Clark
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 ?

2007-01-19 Thread Charlie Clark
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

2007-01-19 Thread Charlie Clark
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 ?

2007-01-18 Thread Charlie Clark
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

2007-01-18 Thread Charlie Clark
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

2007-01-17 Thread Charlie Clark
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

2007-01-17 Thread Charlie Clark
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

2007-01-10 Thread Charlie Clark
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?

2007-01-07 Thread Charlie Clark
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?

2006-10-16 Thread Charlie Clark
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+

2006-10-16 Thread Charlie Clark
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

2006-10-16 Thread Charlie Clark
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

2006-10-16 Thread Charlie Clark
... 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+

2006-10-12 Thread Charlie Clark
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 ,...

2006-10-02 Thread Charlie Clark
. 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?

2006-09-28 Thread Charlie Clark
Am 28.09.2006, 00:26 Uhr, schrieb Paul Winkler [EMAIL PROTECTED]: I'll be writing product code, and am currently just experimenting via zopectl debug, so I have full access to everything. But I still can't see how to get a cursor or anything else that will let me retrieve multiple record sets

Re: [Zope-DB] Getting a cursor?

2006-09-28 Thread Charlie Clark
Am 28.09.2006, 18:33 Uhr, schrieb Paul Winkler [EMAIL PROTECTED]: Yes! Thank you very much. Somehow I failed to notice that the connection had a connection attribute. Not surprising really. Most people are quite happy with ZopeDA's the way they are and so we only very rarely get questions

Re: [Zope-DB] Getting a cursor?

2006-09-27 Thread Charlie Clark
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

2006-08-11 Thread Charlie Clark
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

2006-06-07 Thread Charlie Clark
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

2006-04-06 Thread Charlie Clark
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

2006-04-06 Thread Charlie Clark
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

2006-04-05 Thread Charlie Clark
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

2006-03-22 Thread Charlie Clark
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

2006-03-21 Thread Charlie Clark
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

2006-02-28 Thread Charlie Clark
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

2006-02-28 Thread Charlie Clark
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?

2006-02-09 Thread Charlie Clark
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

2006-02-02 Thread Charlie Clark
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

2006-01-23 Thread Charlie Clark
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

2006-01-23 Thread Charlie Clark
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

2006-01-23 Thread Charlie Clark
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] dealing with dropped database connections

2006-01-18 Thread Charlie Clark
martin f krafft wrote: Hi, a client of mine complains about dropped database connections (SybaseDA), which wreak havoc. For instance, if the network goes down for a while, the DA is left in an irrecoverable state. Short of a regular wget to the manage interface to restart the DA, what can be

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

2006-01-17 Thread Charlie Clark
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

2006-01-10 Thread Charlie Clark
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

2006-01-10 Thread Charlie Clark
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

2006-01-09 Thread Charlie Clark
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?

2005-12-06 Thread Charlie Clark
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?

2005-12-05 Thread Charlie Clark
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?

2005-12-02 Thread Charlie Clark
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?

2005-11-29 Thread Charlie Clark
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

2005-11-22 Thread Charlie Clark
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

2005-05-02 Thread Charlie Clark
? 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

2005-04-28 Thread Charlie Clark
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

2005-04-08 Thread Charlie Clark
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

2005-04-08 Thread Charlie Clark
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