Batchpeocessing with multiple selection
Hello, I am using Zope sine last couple of months. I have been using zope from source version Zope-2.1.6-src. My operating system is Turbolinux6.0 and my database is MySql. I have to make an search on a column having multiple selection i.e take for example I have a column for city in one of my tables which also contains many other columns. Now i make a search on multiple city along with the state in which that city belongs. The search is working fine I get all the data i want, But my problem is that i wan to display only 10 rows on the page.For this i am using batch processing. But it is giving me errors Such as key error [city],[state] and gives the url of my page where i m using batchprocessing. Can someone help me out how to overcome the problem this problem as this is very urgent for me. I think the varibles are not geting passed again when i click on next sequence. Thanx in anticipation of a reply and warm regards to all. Hope I am able to explain what my probelm is ? Vikas Mahajan
+----[ vikas ]--------------------------------------------- | the varibles are not geting passed again when i click on next sequence. You have to pass the variables, to the page that *does the query* The query is run every time, just different results are displayed. If this is a problem, check out the advanced properties for your query and cache the query for a few minutes. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
vikas wrote:
display only 10 rows on the page.For this i am using batch processing. But it is giving me errors Such as key error [city],[state] and gives the url of my page where i m using batchprocessing. Can someone help me out how to overcome the problem this problem as this is very urgent for me. I think the varibles are not geting passed again when i click on next sequence.
For an example, create a Z Search Interface going against your ZSQL method, them enhance it. As was pointed out, this runs the query again but since you can cache the results, the database is not necessarily hit again. -Craig -- Craig Allen - Managing Partner - Mutual Alchemy Web Architecture - http://alchemy.nu
participants (3)
-
Andrew Kenneth Milton -
Craig Allen -
vikas