Re: [Zope] Problem using dtml-in in ZSQL method

2008-12-12 Thread Françoise CONIL
Trying : select * from mytable did not work, it generates a ProgrammingError - Module Shared.DC.ZRDB.DA, line 374, in __call__ - Module Products.ZMySQLDA.db, line 273, in query ProgrammingError: (1064, "You have an error in your SQL syntax. Check the manual that corresponds to yo

Re: [Zope] Problem using dtml-in in ZSQL method

2008-12-12 Thread Andrew Milton
+---[ Fran?oise CONIL ]-- | Trying : | | select * from mytable select * from mytable WHERE ^ Missed a where statement... | Thanks for your reply No problem. -- Andrew Milton a...@theinternet.com.au

Re: [Zope] Problem using dtml-in in ZSQL method

2008-12-12 Thread Françoise CONIL
You're right but even with a WHERE statement I get the same programming error, I have to use the dtml-sqlgroup statement Françoise 2008/12/12 Andrew Milton > +---[ Fran?oise CONIL ]-- > | Trying : > | > | select * from mytable column=id> > > > select * from myta

[Zope] single zsql on multiple tables or multiple zsql s

2008-12-12 Thread indrajit926 indra
Hi All, In my project iam using zsqls. Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance. using one zsql to fetch values from different tables ,can increase performance ?(instead of using multiple zsqls on multiple tables).

[Zope] The proxy server received an invalid response from an upstream server.

2008-12-12 Thread rugbert
My client's zope has two back ends, /manage and /tools. tools is the one with the more user friendly interface and manage is the utilitarian one. When users goto /tools tho, and click the "assets" folder the site times outs with this: [code] Proxy Error The proxy server received an invalid resp

Re: [Zope] The proxy server received an invalid response from an upstream server.

2008-12-12 Thread Peter Bengtsson
Doesn't that just mean that Apache is proxy passing to a Zope that doesn't respond? 2008/12/12 rugbert : > > My client's zope has two back ends, /manage and /tools. tools is the one with > the more user friendly interface and manage is the utilitarian one. > > When users goto /tools tho, and click

[Zope] Unknown directive for xmlrpc

2008-12-12 Thread Bertus Van der Linden
zope.configuration.xmlconfig.ZopeXMLConfigurationError: File "/home/nolbert/miqra/mbm-dev-buildout2/parts/instance/etc/site.zcml", line 15.2-15.23 ZopeXMLConfigurationError: File "/home/nolbert/miqra/mbm-dev-buildout2/products/worldcookery/configure.zcml", line 8.2-8.31 ZopeXMLConfiguration