- Zope - Zope lists

zgadfly and zsql problem
by Luc Tonin 23 Jun '00

23 Jun '00

i m using da zgadfly database and i m still trying to use this type of query SELECT * FROM table_name WHERE field_name LIKE 'test' but it s seems that zgadfly doesn t support da LIKE sql tag! anyone have an ID ???

2 1

Who has compiled _mysql.pyd?
by Juan Carlos Coruña 23 Jun '00

23 Jun '00

I use to develop on linux, but in this moment I need to setup a Zope server on NT with ZmySQLDA 1.2.0. On linux I don't have problems to compile _mysqlmodule.so, but on NT I don't have a compiler nor experience. Anyone has already compiled _mysql.pyd for NT? Can I have a copy of _mysql.pyd?

1 0

Facing problems with date datatype
by Vikas Mahajan 23 Jun '00

23 Jun '00

Hi All, I am facing problem with date datatype. I have installed two versions of zope on diff computer. One is a zope 2.1.2 from a binary release and another is zope 2.1.6 i downlodaed as a source release. I am able to get MySQL database connection for source release and not for the one i downloaded as binary. Now my problem is when i want to insert a datatype in properties of a folder I wporks well with my binary release and not with the one i installed from sourece. My binary release one takes all of the following formats such as Jan. 07, 2000 jan. 07, 2000 2000/01/07 January 07, 2000 but the one which i compiled fro source takes none of them instead throws following error. Zope Error Zope has encountered an error while publishing this resource. Error Type: DateTimeError Error Value: Invalid date: Jan. 07, 2000 and asks me to search for the problem in the following files Traceback (innermost last): File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/suhail/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addProperty) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_addProperty) File /home/suhail/Zope-2.1.6-src/lib/python/OFS/PropertyManager.py, line 290, in manage_addProperty (Object: ElementWithAttributes) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Converters.py, line 157, in field2date File DateTime.py, line 523, in __init__ DateTimeError: (see above) Since I want to use MySQL as my database I need to work in source release i.e 2.1.6 from source. So please kindly help me regarding this matter. All help will be appreciated. Best Regards and Thanx Vikas MoreLinux.com - much of more.

1 0

Facing problems with date datatype
by Vikas Mahajan 23 Jun '00

23 Jun '00

Hi All, I am facing problem with date datatype. I have installed two versions of zope on diff computer. One is a zope 2.1.2 from a binary release and another is zope 2.1.6 i downlodaed as a source release. I am able to get MySQL database connection for source release and not for the one i downloaded as binary. Now my problem is when i want to insert a datatype in properties of a folder I wporks well with my binary release and not with the one i installed from sourece. My binary release one takes all of the following formats such as Jan. 07, 2000 jan. 07, 2000 2000/01/07 January 07, 2000 but the one which i compiled fro source takes none of them instead throws following error. Zope Error Zope has encountered an error while publishing this resource. Error Type: DateTimeError Error Value: Invalid date: Jan. 07, 2000 and asks me to search for the problem in the following files Traceback (innermost last): File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/suhail/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addProperty) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_addProperty) File /home/suhail/Zope-2.1.6-src/lib/python/OFS/PropertyManager.py, line 290, in manage_addProperty (Object: ElementWithAttributes) File /home/suhail/Zope-2.1.6-src/lib/python/ZPublisher/Converters.py, line 157, in field2date File DateTime.py, line 523, in __init__ DateTimeError: (see above) Since I want to use MySQL as my database I need to work in source release i.e 2.1.6 from source. So please kindly help me regarding this matter. All help will be appreciated. Best Regards and Thanx Vikas MoreLinux.com - much of more.

1 0

Is DTML a bastardized form of XML, or valid XML?
by Kevin Howe 23 Jun '00

23 Jun '00

Hi, just wondering if DTML is actually a valid form of XML, or a bastardized version of XML created specifically for ZOPE. I've done a little reasearch on XML, and I it seems like DTML tags such as: <dtml-var "..."> or <dtml-if "..."> ... <dtml-else> ... </dtml-if> aren't really valid XML forms. The following would make more sense: <dtml-var expr="..."/> or <dtml-if expr="..."> ... <dtml-else> ... </dtml-else> ... </dtml-if> Anyone care to enlighten me? Thanks, kh

2 1

Re: [Zope] More reliable Database Adapter for linux
by Rogerio Atem de Carvalho 22 Jun '00

22 Jun '00

> > Maybe the correct question is the most reliable combo >DA+DB. > > Regards. > >How about: Zope+ZODB ? I have a question: Will ZODB have something like OQL? The problem in using ZODB is to do simple queries and link different class object instances in queries (SQL join). It is hard to do simple things in ZODB like aggregate functions (sum, max ...) That's why I use an external RDBMS... regards, Rogerio Atem. ------------------------------------------- E-mail enviado pelo servidor do CEFETCampos

1 0

new product: NISUserFolder
by Jonothan Farr 22 Jun '00

22 Jun '00

I've created a new product similar to etcUserFolder that authenticates against an NIS database. http://www.zope.org/Members/jfarr/Products/NISUserFolder/ This also improves upon the etcUserFolder product by defining a separate role for each user group, allowing more fine-grained control of which users have which permissions. I've submitted a patch to the collector containing these same changes to etcUserFolder. If DC decides not to include them I'll release this as a separate product. Enjoy! --jfarr "Perl is worse than Python because people wanted it worse." Larry Wall, 14 Oct 1998

1 0

Object URLs like Zope with Java servlets / EJBs?
by Hamish Lawson 22 Jun '00

22 Jun '00

Are there any Zopistas with experience also of Java servlets/EJBs? >From my reading so far I get the impression that servlets/EJBs roughly correspond to Zope's products. What I'm not sure is whether any Java app servers have Zope's concept of having URL paths to object instances, or whether they only provide URLs to the servlets/EJBs themselves, with passed parameters being used instead to specify a particular instance? Hamish Lawson ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

1 0

Fwd: Re: [Zope-dev] ZEO on NT? update
by julio dinis 22 Jun '00

22 Jun '00

>From: "julio dinis" <juliodinis(a)hotmail.com> >To: zope-dev(a)zope.org >Subject: Re: [Zope-dev] ZEO on NT? update >Date: Thu, 22 Jun 2000 14:05:07 PDT > >Ok. :-) > >Continuing with the ZODB.POSException.Conflit... > >Now I know the problem with Zeo on NT is with the ClientStorage >and not with the ServerStorage. >You ask why? Because Ive tested different setup to come to this >conclusion. > > >ZSS - Zeo Storage Server >ZCS - Zeo Client Storage > >1- First setup: > >Machine 1: Running ZSS on NT >Machine 2: Runninc ZCS on NT >Machine 3: Running ZCS on NT > >Conclusion: with this setup clients ARE NOT able to view/write changes >to objects changed by other clients. > >2- Second Setup: > >Machine 1: Running ZSS on Linux >Machine 2: Runninc ZCS on NT >Machine 3: Running ZCS on NT > >Conclusion: with this setup clients ARE NOT able to view/write changes >to objects changed by other clients. > >3- third Setup: > >Machine 1: Running ZSS on NT >Machine 2: Runninc ZCS on Linux >Machine 3: Running ZCS on Linux > >Conclusion: with this setup clients ARE able to view/write changes >to objects changed by other clients. > >4- Fourth Setup: > >Machine 1: Running ZSS on NT >Machine 2: Runninc ZCS on Linux >Machine 3: Running ZCS on Linux >Machine 4: Running ZCS on NT >Machine 5: Running ZCS on NT > >Conclusion: with this setup ALL LINUX clients ARE able to view/write >changes to objects changed by other clients. All NT clients ARE NOT able to >view/write objects changed by other clients. > >NT clients can view/write objects that have never been changed. But >cant viewchanges/change objects changed by other clients. However >linux clients can viewchanges/change objects changed by other NT and Linux >clients. > >So my conclusion is that there is a problem with Zeo Clients on NT. >And I guess is related with the invalidator, the NT clients cant >see changes others do to objects, or something is just a guess. >I'm using cPickle.pyd which is cPickle.so on Linux. Maybe there >is a diference with this shared object from Linux to Nt. > >I'm using the win32 version of Zope2.2.0b1, and ZEO-0.2. > >Ok, ./dig_resume > >Julio Dinis Silva > > > >>From: "julio dinis" <juliodinis(a)hotmail.com> >>To: zope-dev(a)zope.org >>Subject: [Zope-dev] ZEO on NT? update >>Date: Thu, 22 Jun 2000 09:37:31 PDT >> >>Hi, >> >>I can see now that the problem is not per Data.fs but per object. >>The problem isnt that 2nd Client to run cant write do Data.fs, I found >>that its a per object conflict and not Data.fs, both clients can >>write to the ZSS but once client B writes to object X, Client A will >>never see the changes neither change the object X, but is capable of >>changing other objects. >> >>Objects changed buy Client B become "locked" for client A and viceversa. >> >>Anyone testing ZEO? >>Best Regards, >>Júlio Dinis Silva >>________________________________________________________________________ >>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >> >> >>_______________________________________________ >>Zope-Dev maillist - Zope-Dev(a)zope.org >>http://lists.zope.org/mailman/listinfo/zope-dev >>** No cross posts or HTML encoding! ** >>(Related lists - http://lists.zope.org/mailman/listinfo/zope-announce >>http://lists.zope.org/mailman/listinfo/zope ) >> > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > >_______________________________________________ >Zope-Dev maillist - Zope-Dev(a)zope.org >http://lists.zope.org/mailman/listinfo/zope-dev >** No cross posts or HTML encoding! ** >(Related lists - http://lists.zope.org/mailman/listinfo/zope-announce >http://lists.zope.org/mailman/listinfo/zope ) > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

RE: [Zope] Select Box Problem
by caseman＠mad.scientist.com 22 Jun '00

22 Jun '00

>The entire form is in a <dtml-in> that has a customerid value. I would like >to have the current customer show up in this box. How would I tell the >select box to select the current custoemer as default? I had a similar issue on a form I created. There are basically two ways to make this work. One is server-side the other using JavaScript. I chose the former for mine. I simply just inserted the chosen selection as the first item in the list then followed it with the query data. Assuming when the form is rendered there is a REQUEST variable customerid as your example it would look something like this: <select name=customerId> <dtml-in sql_getCustomerName> <option value=<dtml-var customerId>><dtml-var firstName> <dtml-var lastName> </dtml-in> <dtml-in "sql_getCustomers(omit=customerId)"> <option value=<dtml-var customerId>><dtml-var firstName> <dtml-var lastName> </dtml-in> </select> This should do it. The first query (sql_getCustomerName) will return one record of the customer info by customerId. This returns the current customer's name for the list. The second query (sql_getCustomers) returns every customer except the one specified by omit. The omit argument could be made optional to return all in other instances. Hope that helps, Casey Duncan

1 0