[Zope-dev] request.locale

2007-09-06 Thread Laurence Rowe
Quite a lot of zope3 code (zc.datetimewidget for instance) expects to be able to access request.locale. ZPublisher does not provide this and to get around the limitation you must manually set request.locale in your view using Products.CMFDefault.formlib.form.getLocale. This seems brittle. I

[Zope] Help raise Open Source visibility in the government area

2007-09-06 Thread Godefroid Chapelle
Hi, ( If you have already received this email and have voted, thank you ! ) ( If you have not voted, and wanted to, this is a nice reminder. ) ( If you do not wish to vote, sorry for the noise. ) Please take 10 minutes to help raise open source profile in the government area by voting for the

Re: [Zope] Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread Josh Burvill
Providing your database has the upper() function, or replace with similar select ... dtml-sqlgroup where dtml-if firstname upper(firstname) like upper(dtml-sqlvar firstname type=string) /dtml-if dtml-or dtml-if lastname upper(lastname) like upper(dtml-sqlvar lastname

[Zope] VERY unusual zope traceback

2007-09-06 Thread robert rottermann
After my computer was iddling during the nigth I got the following traceback. look at the rather genereous number of expected parameters. how can somethings like this happen? Memory corruption? restarting zope fixed it. robert Site Error An error was encountered while publishing this resource.

Re: [Zope] genealogy product?

2007-09-06 Thread Jaroslav Lukesh
Hi, I does not know that product, but zope DB is tree DB. Here are few products which you should use to cross between trees (like unix symlink). One folder = one person. SO programming of that web application is not as hard, you should do it in plain DTML and javascript. Plus you should use

[Zope] genealogy product?

2007-09-06 Thread Mihamina (R12y) Rakotomandimby
Hi, Would you know any genealogy product for Zope? Is zope a tool for managing a big (20 members) of genealogy oriented group, which has over 150,000,000 entries in the genealogy tree? It is now managed with about 20 servers and SQL databases but Zope might be a solution, isn't it?

Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread garry saddington
On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: is there an easy way to make the following ZSQL query case-insensitive? select * from clients dtml-sqlgroup where dtml-sqltest firstname op=like type=string optional dtml-or dtml-sqltest lastname op=like type=string optional

Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread onsombal
thanks -- it now works like a charm Garry Saddington wrote: On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: is there an easy way to make the following ZSQL query case-insensitive? select * from clients dtml-sqlgroup where dtml-sqltest firstname op=like type=string

Re: [Zope-DB] case insensitive ZSQL queries

2007-09-06 Thread Maciej Wisniowski
thanks -- it now works like a charm AFAIR 'ilike' in postgres doesn't properly support i18n characters, so be carefull with that. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db