Re: [Zope-DB] help appreciated [Virus checked]
[EMAIL PROTECTED] wrote at 2006-1-12 15:03 +0100: >After creating about 20 ZSQL Methods and polishing them out, > >I tried some changes in "opt/Zope-2.8/lib/python/Shared/DC/ZRDB" which >worked fine. >But then these Objects all appreared like this: >Abrechnung (This object from the ZSQLMethods product is broken!) The import of the corresponding class failed -- almost surely because your change broke something... -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Fwd: Re: [Zope-DB] database connection]
Martin Krallinger wrote at 2006-1-10 16:57 +0100: >thanks for the info. I am actually using zope 2.7 but still I >encountered this problem. I think the poster wrote: "fixed in Zope > 2.7". Maybe, you try 2.8.5 or 2.9? -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system
For the record, removing the trailing underscore worked. Damn FSDump! Thanks for the help. Michele Simionato ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system
On 1/13/06, Andreas Jung <[EMAIL PROTECTED]> wrote: > > Because it must be "max_rows: 1000". > > -aj You mean without the tralining underscore in the dtml-comment? So I should change title: arguments: connection_id:rcare_connection max_rows:1000 max_cache:1000 cache_time:86400 class_name: class_file: instead of title: arguments: connection_id:rcare_connection max_rows_:1000 max_cache_:1000 cache_time_:86400 class_name_: class_file_: ? The dtml-comments where generated by FSDump so I assumed they were correct. Michele Simionato ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system
--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 somewhere: grepping a bit I discovered that there is a ``max_rows = 1000`` statement in Shared/DC/ZRDB/DA.py, but changing this had no effect, so it must be set somewhere else. Because it must be "max_rows: 1000". -aj pgpaYBu7G5H17.pgp Description: PGP signature ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system
I am using Zope 2.8.4/Plone 2.1.1/ZPsycopgDA 1.20 on a Debian box. I have a few SQLMethods which has been put on the filesystem using FSDump 0.9 and are read by a Plone site with a DirectoryView. A typical one is the following: $ cat distinct_client_names.zsql title: arguments: connection_id:rcare_connection max_rows_:1000 max_cache_:1000 cache_time_:86400 class_name_: class_file_: select distinct client from rhp_clientcode 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 somewhere: grepping a bit I discovered that there is a ``max_rows = 1000`` statement in Shared/DC/ZRDB/DA.py, but changing this had no effect, so it must be set somewhere else. If I define a new SQLMethod in the ZMI (i.e. not in the file system) and I set the max_rows limit there, everything works fine. So, how do I change the max_rows and cach_time limits for the SQLMethods on the file system? Michele Simionato ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Re: Antwort: Re: 1. help appreciated [Virus checked]
Hv u try using the ZSearchInterface calling your ZSQL method (below). Try it. It will solve your problem except the layout is not good looking. Hiowever, you may to modify it to pass arguments to your ZSQL method. Look for: (Previous results) ; and (Next results) Chan YH[EMAIL PROTECTED] wrote: Yes, you are right. Any other solution is welcome.My ZSQLMethos is:selectdate_format(CONCAT(datej,'-',datem,'-00'),'%m.%Y') as "Abr._Monat", cardno as Kartennummer,concat(pid_org,"-",bst) as ORG,CONV(customer,10,10) as ID,IFNULL(date_format(birthday,'%d.%m.%Y'), '&nsbp;') as Geburtstag,plz,date_format(CONCAT(LEFT(euro_start,4),'-',RIGHT(euro_start,2),'-00'),'%m.%Y') as EURO_Start,statusfrom AlterOrtEuro cardno like and need the arguments above.works well for the first page. But, at the bottom we have the (Next 20results) and there in the link,is no refenence to".. manage_test?Kartennummer=50%25&von_Monat=&von_Jahr=&bis_Monat=&bis_Jahr=&SUBMIT=Submit+Query"as there is in the current page.Naturally, when the next page is displayed, ( ...manage_test?query_start=26&query='' )the (bold) parameters from the first page are ignored and a new page isdisplayed as if no arguments were relevant.Why is 'query=''' empty ?How would you do it ?mit freundlichen Gr��en/best regardsWolfgang Schrecker"Partiality to the subjective view leads to an emphasis on the spritual,while pa rtiality to the objective leads to an emphasis on the material"aus: Daisaku Ikeda: Wisdom of the Lotos-Sutra Vol. V p. 7* * * * * * * * L E G A LD I S C L A I M E R * * * * * * * *This e-mail is destined for the above mentioned recipient. In case youreceived this e-mail by accident, we would appreciate it if you couldcontact the sender and delete all copies stored on your computer.Please be aware that the security and confidentiality of electronic datatransmitted by e-mail is not completely guaranteed and that data may beseen,copied, downloaded or changed by third persons during transmission.Atos Origin accepts no liability for the security and confidentiality ofdata and documents sent by e-mail. Please make sure that all importantmessages will be confirmed in writing by means of a telefax or a letter.* * * * * * * * L E G A LD I S C L A I M E R * * * * * * * * Yahoo! Photos Showcase holiday pictures in hardcover Photo Books. You design it and well bind it!___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
