- Zope - Zope lists

Problems with mysql and sql methode
by Jens Grewen 20 Oct '00

20 Oct '00

Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT --------------------------------- MPID int(30) MEID int(30) PYID int(30) --------------------------------- PAYMENT --------------------------------- PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) --------------------------------- the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen

1 0

ZMySQL and MySQLdb Versions
by Ragnar Beer 20 Oct '00

20 Oct '00

Howdy! When I go to the download section on zope.org looking for a way to connect Zope and MySQL I can find the following: - Zope MySQL Database Adapter, 2000/07/20 by mordred (ZMySQLDA-1.2.0.tar.gz) - ZMySQLDA, 2000/07/20 by MikeP (ZMySQLDA-1.1.3-nonbin.tar.gz) - An Interface for MySQL, 2000/07/20 by adustman (MySQLdb-0.1.2.tar.gz) Now how should anybody new to Zope know what to use? Especially when ZMySQLDA goes up to at least version 2.0.0 (I tried to look it up but couldn't connect to starship.python.net) and MySQLdb at least to version 0.2.1. I'm still using ZMySQLDA 1.1.3 with MySQLdb 0.1.3 which can't be found in the download section. Confusing, isn't it? What could we possibly do about it? Ragnar

2 1

Re: [Zope-dev] Problems with offline MS IE 5
by Jens Grewen 20 Oct '00

20 Oct '00

I was fighting with the same problem and I thought it depends on my proxy setting. But now I thing it depends on the Browser version because I installed IE5.5 and the problem was gone. (ocularly same settings). ----- Original Message ----- From: "Ross Boylan" <RossBoylan(a)stanfordalumni.org> To: <zope-dev(a)zope.org> Sent: Friday, October 20, 2000 8:09 AM Subject: [Zope-dev] Problems with offline MS IE 5 > I recently tried doing some Zope development on a laptop and ran into a > problem: when I updated a product the updates did not "take." In > particular, when I edited the text in a .dtml file and restarted Zope, I > still saw the old text when I got to the appropriate point (the file was > wrapped in an HTMLFile() and used for creating a new instance of one of the > products in the package). > > I think I checked all of the following: > * the file was getting updated > * all instances of explorer were shut down > * MSIE options set to "Check for newer version of stored page on every > visit to the page" > > A notable peculiarity was that whenever I tried to access my local zope, I > would get a "you are offline, do you wish to go online" message (I even > used localhost as the machine name!). I would say yes, it would say it > couldn't connect and ask if I wanted to try again. I said yes, but then I > ran into the problems described above. > > Zope 2.2.2 on MS W2K with MS IE 5.0. > > Does this ring any bells with anyone? Is it an IE problem? a Zope > problem? an interaction? > > > _______________________________________________ > 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 ) >

1 0

ZDiscussions for Zope 2.2.2
by Cary O'Brien 20 Oct '00

20 Oct '00

Sorry about being such a winer yesterday. I needed a confera bulletin board for work (internal) with attachments, so I hacked ZDiscussions to work with Zope2.2.2. I needed to: 1) Get FileObject.py from Confera 2) add __allow_access_to_unprotected_subobjects__ in a few places. 3) Fix a check for "Cancel" 4) fix the size of __ac_permissions__ I uploaded it to www.zope.org (never done that before, it is pretty nice!). I left the RCS files in place in case anyone wants to critique my um-er work. http://www.zope.org/Members/cobrien/ZDiscussions_zope22 You may be happier with ZUBB or Squishdot. -- cary

2 1

Determining permissions in a Product
by Aaron Straup Cope 20 Oct '00

20 Oct '00

Hi, Is there a clever way of determining/debugging the required permissions and/or roles for a given Product? I know that it's pretty straightforward if the product is released as a capital-P Product, but I am less sure about looking through a .exp file. I am trying to get FlexFAQ2 set up with the minimum set of permissions. If I understand the docs correctly, I have enabled the right flags but still I get prompted for a username/password when I try to add an item. Obviously, I would like to solve this problem I would be very interested to hear about more general approaches to problem solving products. Thanks,

3 3

How do I format date/time in dtml from a ISO-8601 SQL timestamp field? field?
by J Kinsley 20 Oct '00

20 Oct '00

I am probably missing something simple here, however I can not get this to work properly.... Given mtime = YYYY-MM-DD HH:MM:SS-ZZ as returned from PostgreSQL, how do I get the following to work without errors? <dtml-in "sqlquery(...)"> .... <dtml-var mtime fmt="%a %d %b %Y %H:%M:S %Z"> .... </dtml-in query> This returns: Errot Type: ValueError Error Value: unsupported format character 'a' (0x61) If i drop the %a from the fmt string as follows: <dtml-in "sqlquery(...)"> .... <dtml-var mtime fmt="%d %b %Y %H:%M:S %Z"> .... </dtml-in query> I get the following Zope Error: Error Type: Type Error Error Value: illegal argument type for built-in operation Mtime was initially declared as a string in the ZSQL Method arguments list, and changing it to date had no effect. I have searched the documentation and all examples I have found that use strftime formatting indicate that this should work. I have successfully been able to change the format using the to_char(mtime) PostgreSQL function, but then order by mtime does not work properly and besides, I would like to make the format style customizable from within Zope instead of on the SQL server. Thanks in advance for any suggestions.... Regards, Jarrod Kinsley

2 1

dtml-sqlvar quote
by Mark Twiddy 20 Oct '00

20 Oct '00

Hi all How can i pass a string to a sql method that won't be quoted. i.e so i can do somthing like this ..... group by foo,blah order by <dtml-sqlvar spam> thanks mark

3 3

Newsletter in Zope
by Stephan Goeldi 20 Oct '00

20 Oct '00

I am looking for a way to enable a Newsletter in Zope. I want the visitors to subscribe to the newsletter. Then they receive a mail to verify the subscription. Later I can write and send a Newsletter to all subscripted visitors. Is there already a solution in Zope for that? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

submit buttons
by Mark Twiddy 20 Oct '00

20 Oct '00

Hi all I can remember reading but can't remember where or how ,another way to submit forms . somthing like <form> <input type=submit name=spam value=blah> some action here </form> does anyone have an example thanks again Mark

2 1

Why doesn't this method work?
by Graham Chiu 20 Oct '00

20 Oct '00

I'm still struggling with Tiny Tables. Why does this flag an error?? <dtml-call "REQUEST.set('table','thenameofmytinytable')"> <dtml-call "REQUEST.set('tableData',_.chr(34)+'Mydata'+_.chr(34) + '\n')"> <dtml-call "table.manage_editData(tableData)"> Error Type: AttributeError Error Value: 'string' object has no attribute 'manage_editData' -- Graham Chiu

2 2