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 the >> '(Next 20 results)' I get the following error: > >This is a standard error in ZSQL's test pages and is due to the fact that >the >query parameters are not included in the link for the next 20 results.> > >Charlie > Hi The problem can be found where the page template defines the link to the next 20 pages, look: previous 20 results next 20 results Do you see the code '?start:int', you should add there the parameters needed for your ZSQL or take the easy path of change the batch size to a big number like 65000. You can do these using this lines: batch python:modules['ZTUtils'].Batch(results, size=65000, start=start); instead of: batch python:modules['ZTUtils'].Batch(results, size=20, start=start); I hope this can be of any help... Bye Jose Rivera Merla ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] User Authentication
Thank you all for your answers. I will follow Charlie's advice and post the question to the XUF list (http://sourceforge.net/mailarchive/forum.php?forum_id=190) Laurentiu - Original Message - From: Charlie Clark To: zope-db@zope.org Sent: Monday, January 09, 2006 8:48 AM Subject: Re: [Zope-DB] User Authentication It sounds like you 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 ClarkeGenix.com ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Fwd: Re: [Zope-DB] database connection]
thanks for the info. I am actually using zope 2.7 but still I encountered this problem. I am not quite sure what you mean with modifying the dtml to pass arguments in this case. The z sql method I use has actually the following parameters: ref_id pub_type title pub_name pub_auth_list pub_volume pub_year pub_page url keywords using the sql statement: SELECT * FROM bib_table WHERE ref_id ~ '' AND pub_type ~ '' AND title ~ '' AND pub_name ~ '' AND pub_auth_list ~ '' AND pub_volume ~ '' AND pub_year ~ '' AND pub_page ~ '' AND url ~ '' AND keywords ~ '' When I generate the z search interface using the dtml method option I still get the error, when I use it as an Page Templates it workes. Does anybody know why? I am not an Zope expert, so it seems somehow strange and I did not find any information related to this on the web thx Martin --- Begin Message --- On 2006-01-10 at 13:06:30 [+0100], Martin Krallinger <[EMAIL PROTECTED]> wrote: > Thanks Charlie, > > so, how could I solve this problem in my case? Please keep replies like this on the mailing list. Well, you can fix the DTML of the page in question so that the parameters are carried or simply 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://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ 2005-10-17: Released mxODBC.Zope.DA 1.0.9http://zope.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! --- End Message --- ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] database connection
On 2006-01-10 at 13:06:30 [+0100], Martin Krallinger <[EMAIL PROTECTED]> wrote: > Thanks Charlie, > > so, how could I solve this problem in my case? Please keep replies like this on the mailing list. Well, you can fix the DTML of the page in question so that the parameters are carried or simply 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://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ 2005-10-17: Released mxODBC.Zope.DA 1.0.9http://zope.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
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 the > '(Next 20 results)' I get the following error: This is a standard error in ZSQL's test pages and is due to the fact that the query parameters are not included in the link for the next 20 results. Charlie ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] database connection
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 the '(Next 20 results)' I get the following error: Site Error An error was encountered while publishing this resource. Resource not found Sorry, the requested resource does not exist. Check the URL and try again. Resource: http://jura:9673/RefDB/Psycopg_database_connection/NONE Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the error log. If the error persists please contact the site maintainer. Thank you for your patience. '' what should I do? I think it is strange that it shows the first 20 results withour problems but does not work when I try to display the next 20 results. Any suggestions? thx, Martin ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db