- Zope - Zope lists

Zope is not getting MySQL SELECT results ...
by Gerald Gutierrez 23 Jan '01

23 Jan '01

Hi all. I have set up, in a clean Zope installation, a MySQL database adapter. My connection string is "test test test", indicating a user test with password test connection to the test database. The adapter indicates that it can connect to the database, and I can send queries to the database. CREATE TABLE, INSERT, UPDATE, and other queries work just fine through the "test" tab of the adapter management interface, but it does not seem to be able return any data through a SELECT query. This does not work in the "test" table nor in a SQL method. Using a query, such as "select * from test", it always replies with: -------------------------------------------- There was no data matching this My Query query. SQL used: select * from test -------------------------------------------- I know the queries are reaching the database, because if I give it a bogus command, it gives me an error, and if I give it a command that affects the data, I can see that reflected in the database itself with MySQL's "mysql" client. So what is a problem here? As another test, I tried out the MySQL-python module; it works just fine. I'm using Python 2.0, Zope 2.3b2, ZMySQLDA 1.2.0, MySQL-python 0.3.0. Thanks for any help. Gerald.

1 0

PythonScript bug?
by Tim Moore 23 Jan '01

23 Jan '01

I have a small python script method which works fine unless I bind the Namspace to a variable (even if I don't actually use the variable), which causes a MemoryError that appears to be due to deep (infinite?) recursion in the __render_with_namespace__ method (Bindings.py, line 355). Zope 2.3b2 -- Tim Moore

1 0

Re: [Zope] Upload file and :int with :required and
by Dieter Maurer 23 Jan '01

23 Jan '01

Hi Diego, Diego Rodrigo Neufert writes: > When I use <dtml-unless "attach_file.filename"> > > I got a NameError.... This must be "NameError 'attach_file'", right? > Do you know a solution to this? because when I dont specify anything in a > field zope just dont know about it... Apparently, browsers behave differently. My Netscape 4.7 interpretes an empty file control as successful and sends the corresponding name/value pair (with empty value). To handle both behaviours, you can use: <dtml-unless "REQUEST.form.has_key('attach_file') and attach_file.filename">  </dtml-unless> Dieter

1 0

Re: [Zope] LocalFS and PathHandler
by Dieter Maurer 23 Jan '01

23 Jan '01

Ulrich Wisser writes: > How can a get a directory listining with LocalFS > for path "/sub1/sub2/sub3/"? I know I need something > like "lfs['sub1']['sub2']['sub3'].fileids". But > what if there are more (or less) elements in path_to_handle? The easiest answer to these types of questions are recursive functions. You may use a "dtml-in", too. Like that: <dtml-call "REQUEST.set(curr__,lfs)"> <dtml-in path_to_handle> <dtml-call "REQUEST.set(curr__,curr__[_['sequence-item']])"> </dtml-in> <dtml-var "curr__.fileids"> Dieter

3 3

RE: [Zope] Zope 2.3.0b2 bug #2
by Dieter Maurer 23 Jan '01

23 Jan '01

Oleg Broytmann writes: > Hm, will you fix my browser, too? I am using Netscape for Linux, don't > know how well it plays with Unicode. I suppose it plays bad :( We use Netscape (4.5, 4.7; Linux, Windows) with "charset=utf-8" and it handles it well. Dieter

3 3

Property sheet feature request
by Tim Moore 23 Jan '01

23 Jan '01

It would be nice to be able to reorder properties in a sheet, maybe using something like the "First" button in the views screen. I'd submit a patch myself, but I'm still figuring all this out so it would hopefully be quicker for someone else more familiar with the code to add that. thanks! -- Tim Moore

1 0

Fw: [Zope] ZClasses & date properties
by Andy McKay 23 Jan '01

23 Jan '01

> Empty date fields are not allowed, this has been a feature for a while. I > set mine to 1970/01/01 for the hell of it. > -- > Andy McKay. > > > ----- Original Message ----- > From: "Tim Moore" <tmoore(a)tembel.org> > To: <zope(a)zope.org> > Sent: Tuesday, January 23, 2001 11:24 AM > Subject: [Zope] ZClasses & date properties > > > > OK, now that I've settled my title property conundrum by just calling > > the property "name" instead :-\ I go to add a "date" property to my > > ZClass and find that it doesn't like that either. Specifically, it > > won't let me add a property of type date with no value, giving me an > > "Invalid Date-Time String" error. I take it that empty date fields > > aren't allowed then...is this intended or a bug? Still using 2.3b1. > > -- > > Tim Moore > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://lists.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://lists.zope.org/mailman/listinfo/zope-announce > > http://lists.zope.org/mailman/listinfo/zope-dev ) > > >

1 0

Re: ZClasses and "title" property
by Aaron Louie 23 Jan '01

23 Jan '01

I think the problem goes deeper than that. Zope 2.3x no longer allows the setting or creation of any property called "title" for new ZClasses. Period (At least, not in the same way it used to). Try it for yourself. If you follow the steps in the "ZClass Properties" How-to (http://www.zope.org/Members/lstaffor/zProperties) you'll find that Zope 2.3x gives a "The id 'title' is invalid--it is already in use" error when you try to create a property called "title". Fine, you say, it's already there by default, right? Finish out the How-To, setting all the proper permissions, modifying the addForm and the constructor to accomodate your other properties. Then try creating an instance of your new class and setting the 'title' property through the addForm. The title will not be set when you hit 'Add'. The field will remain empty... Of course, the How-To above worked just fine in 2.2.5. Doesn't work anymore. There is no longer any default place to set the title in a new ZClass and the title property cannot be set thru DTML. (Haven't tried it in Python yet) Is this a bug or am I missing something? ajl >> I guessed it was something like this, so this leads me to two followup >> questions. >> >> 1) I'd be happy to use the built-in title property assuming that it >> won't cause some kind of problem. I just don't know how I can set >> that in instance objects since it doesn't appear on the property >> sheet. Can I modify the addForm and add methods for the class to >> set it there? Do I need to make a custom view? What approach do >> most people take in this situation, using the built-in title or >> choosing a different name for a title-like property? >> > I use Title (note the upper-casity), and then I add a Python Mehtod (or in > 2.3 a Python Script) called 'title' that simply does: > return self.Title >(or in a P.S.: > return context.Title > should do it >)

2 1

Trivial challenge ?
by Olivier Deckmyn 23 Jan '01

23 Jan '01

Hi all, I have a problem that looks simple (if not trivial) : I would like to "render" a DTML Document using a DTML Method. The DTMLDoc is "mydoc", has a title (="My Document") and a content (="I am the doc content") The DTMLMethod is "render" and its code is : """ I am rendering the <dtml-var title_or_id> page ! """ And, at last, I have a index_html like this : """ <dtml-with mydoc> <dtml-var render> </dtml-with> """ (All the items are in the same folder , whose id=test and no title) When viewing http://localhost:8080/test/ the result I expect is : I am rendering the My Document page ! OK ? But I got : I am rendering the test page ! THE <DTML-WITH> DID NOTHING !!!!!! What makes me become crasy is that http://localhost:8080/test/mydoc/render works as expected !!! : I am rendering the My Document page ! Can anyone explain me this ? And by the way give a solution to my problem ??? Of course I cannot use the http://localhost:8080/test/mydoc/render notation. Thanx for reading that far. Olivier.

5 7

RE: [Zope] Python Products and ZODB Transactions
by Toby Dickenson 23 Jan '01

23 Jan '01

If your method changes data then it will always get saved. The only way is to make sure your method never modifies a persistent object. > -----Original Message----- > From: Stephan Richter [mailto:srichter@cbu.edu] > Sent: 23 January 2001 11:11 > To: tdickenson(a)geminidataloggers.com > Subject: Re: [Zope] Python Products and ZODB Transactions > > > > >Use the tranalyzer to see which objects are being commited. > They think > >they are being modified, even if you dont think they should be. > > Okay, I found the methods and they are sometimes changed. But now, it > should NEVER save the transaction. Is there a way to do that? > > Regards, > Stephan > -- > Stephan Richter > CBU - Physics and Chemistry Student > Web2k - Web Design/Development & Technical Project Management >

2 1