- Zope - Zope lists

Re: [Zope] ZSQL method LAST_INSERT_ID() error
by Andrew Williams 13 Mar '01

13 Mar '01

I know I'm coming into this thread a little late, but... I've run across the same problem you described. I figured out that adding a semicolon at the end of my SQL statements was causing the syntax error. IE: SELECT * from t_table WHERE keyfield=<dtml-sqlvar keyfield type=string>; gave me the syntax error. When I removed the semicolon everything worked fine. Of course, you can also set the limit clause to zero, but you might now want to have to to do that. Andrew Williams >From: Paul Zwarts <paul.zwarts(a)oratrix.com> >To: Andy Dustman <andy(a)dustman.net> >CC: paul_s_johnson(a)urscorp.com, zope(a)zope.org >Subject: Re: [Zope] ZSQL method LAST_INSERT_ID() error >Date: Tue, 13 Mar 2001 17:19:32 +0100 > >Hi, >Can this be done to a whole folder of sqlstatements at once? Or is this an >object >specific thing? > >Paz > >Andy Dustman wrote: > > > http://www.zope.org/Members/adustman/Tips/no_limits > > > > On Tue, 13 Mar 2001 paul_s_johnson(a)urscorp.com wrote: > > > > > This ZSQL query: > > > > > > SELECT LAST_INSERT_ID() AS ID > > > > > > Is returning this error: > > > > > > Error, _mysql.OperationalError: (1064, "You have an error in >your SQL > > > syntax near 'LIMIT 1000' at line 1") > > > > > > It apparently automatically adds a LIMIT clause to the end of my SQL >query > > > that MySQL does not like in this context. Is there any way to shut >the > > > limit clause off? Anybody have any ideas for a workaround? > > > > -- > > Andy Dustman PGP: 0xC72F3F1D > > @ .net http://dustman.net/andy > > "Normally with carbonara you use eggs, but I used lobster brains >instead." > > -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster >Battle > > > > _______________________________________________ > > 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 ) > > >_______________________________________________ >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 ) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com

1 0

ZSQL method LAST_INSERT_ID() error
by paul_s_johnson＠urscorp.com 13 Mar '01

13 Mar '01

This ZSQL query: SELECT LAST_INSERT_ID() AS ID Is returning this error: Error, _mysql.OperationalError: (1064, "You have an error in your SQL syntax near 'LIMIT 1000' at line 1") It apparently automatically adds a LIMIT clause to the end of my SQL query that MySQL does not like in this context. Is there any way to shut the limit clause off? Anybody have any ideas for a workaround? P. Johnson

4 4

Simple problem with sql-group
by Zanotti Michele 13 Mar '01

13 Mar '01

Hello, I 'm a Zope newbye. I have a (probably silly) problem with this sql-template (if you have already discussed this problem excuse me): select * from employees <dtml-sqlgroup where> <dtml-sqltest salary op=gt type=float optional> <dtml-and> <dtml-sqltest first op=eq type=string optional> <dtml-and> <dtml-sqltest last op=eq type=string optional> </dtml-sqlgroup> My question is: if I pass the value 10000 to parameter salary (and nothing to others) I expect to obtain the query: select * from employees where (salary > 10000)? But I obtain the query select * from employees where (salary > 10000 and first = '' and last = '' ). Is this result correct and am I wrong? Can you help me? Thanks. Michele

2 1

Records marshalling: trying to including a list within a record
by Rich and Lea98 13 Mar '01

13 Mar '01

Hi, Can anyone give me ideas on solving the following problem... Im trying to pass information in a form using :records. One item in each record is a list I wish to pass as a list and use <dtml-in bob> to display the list contents. I have tried all sorts of variations... <input type="hidden" name="my_record.bob:records:list" value="<dtml-in bob><dtml-var sequence-item></dtml-in>"> and... <input type="hidden" name="my_record.bob:list:records" value="<dtml-in bob><dtml-var sequence-item></dtml-in>"> Anything I try just places the whole of "bob" as one item in a list. eg if bob was ['this ','is ','bob']. The list in the record passed using the form would be ['this is bob']. Thanks for any ideas in advance. Richard

2 1

manage_addclassname and internal ZClasses
by John R. Daily 13 Mar '01

13 Mar '01

I'm writing an internal ZClass, and I'm having problems with the manage_addclassname function. I modelled it on the classname_add DTML method created by default, and I can't claim that I fully understand what I'm writing, unfortunately. Most of the ZClass documentation, especially with regards to the manage_add* methods, pertains to external Python code. Here's a slimmed-down version of my manage_addFooClass(): --- foo = container.FooClass.createInObjectManager(id, context.REQUEST) foo.manage_changeProperties( { 'title' : 'some title' } ) return foo --- This is invoked by a test script like: --- foo = container.manage_addProduct['Foo'].manage_addFooClass(id) return foo.getId() --- The rub: the new title 'some title' is applied to the container of the new object, not the object itself. According to the documentation I can find on createInObjectManager(), the new object is supposed to be returned, and the other functionality I formerly had in this method seems to back that up. What's going on? Also, does anyone know of any internal ZClasses I can install that are as full-featured as external ones? Also, for subclasses, is it sufficient to define the manage_add* methods alongside the factories for those subclasses? It seems to work, but I've not gotten very far with my testing. Thanks. -- -- John R. Daily jdaily(a)progeny.com Systems Programmer Progeny Linux Systems Master of the ephemeral epiphany

1 0

DTML method --> PythonScript
by Timothy Wilson 13 Mar '01

13 Mar '01

Hi everyone, I recently asked what the following DTML Method would look like as a PythonScript. Unfortunately, the answer given doesn't work. I've including the traceback below, and would appreciate any further ideas anyone has. Original SchoolMenuClass_add DTML Method: <HTML> <HEAD><TITLE>Add SchoolMenuClass</TITLE></HEAD> <BODY BGCOLOR="#FFFFFF" LINK="#000099" VLINK="#555555"> <dtml-with "SchoolMenuClass.createInObjectManager(REQUEST['id'], REQUEST)"> <dtml-call "propertysheets.Basic.manage_editProperties(REQUEST)"> <dtml-call reindex_object> </dtml-with> <dtml-if DestinationURL> <dtml-call "RESPONSE.redirect(DestinationURL+'/manage_workspace')"> <dtml-else> <dtml-call "RESPONSE.redirect(URL2+'/manage_workspace')"> </dtml-if> </body></html> The PythonScript that was suggested (with REQUEST and RESPONSE passed in the parameter list): REQUEST = context.REQUEST RESPONSE = REQUEST.RESPONSE schoolmenu = SchoolMenuClass.createInObjectManager(REQUEST['id'], REQUEST) schoolmenu.propertysheets.Basic.manage_editProperties(REQUEST) schoolmenu.reindex_object() if REQUEST.has_key(DestinationURL): return RESPONSE.redirect(DestinationURL+'/manage_workspace') return RESPONSE.redirect(URL2+'/manage_workspace') The resulting traceback:  -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/ W. St. Paul, MN | | http://slashdot.org/ wilson(a)visi.com | <dtml-var pithy_quote> | http://linux.com/

2 1

RE: [Zope] pythonScript huh?
by Farrell, Troy 13 Mar '01

13 Mar '01

Tom, You can find the api docs under the helpsys system. -Zope Help -API Reference .. .. PythonScript Also, a few notes from experience: 'self' has become 'context' If you define a function, it is only useful inside that PythonScript. You can only import a few modules, per the help page. Troy -----Original Message----- From: Max Møller Rasmussen [mailto:maxm@normik.dk] Sent: Tuesday, March 13, 2001 7:30 AM To: 'tom smith'; Zope listserv Subject: RE: [Zope] pythonScript huh? From: tom smith [mailto:tom@othermedia.com] >I've used PythonMethods and ExternalMethods, but how do I use PythonScripts? >There doesn't seem to be a pythonScript product on the zope site (if you >search for 'pythonscript" you get heaps of stuff though). > Is it a 2.3 thing? Yes Regards Max M _______________________________________________ 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: [Zope] .html extensions
by Farrell, Troy 13 Mar '01

13 Mar '01

When I have a need for an extension (ie serving files for download), I tend to do this for a log file: /path/to/logfile?ext=.log IE4 and IE5 will try to guess mime types and if they fail, they look at the extension. The reason for the above notation is to make the object usable in Python, but to help IE figure out what I mean. Troy. I'd like to take this opportunity to thank everyone on the list who helps me with Zope and my many difficulties. Not many mailing lists are this helpful. -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Tuesday, March 13, 2001 8:10 AM To: Philippe J Cc: zope(a)zope.org Subject: Re: [Zope] .html extensions Hi Philippe, the only reason for .html endings would be for editors to guess the filetype from it. To link to /index.html is kind of silly even for "regular" web-servers (like apache). One goal of zope was to get "nice" URLs ;) Regards Tino Philippe J wrote: > > I simply solved the problem by placing a dtml method called "index.html" in > root, and with "<dtml-var index_html>" in it. With the magic of acquisition, > I have now an index.html file everywhere. > > Philippe > > ----- Original Message ----- > From: "Chris Cioffi" <zope(a)stopthesanity.org> > To: <zope(a)zope.org> > Sent: Monday, March 12, 2001 6:10 PM > Subject: [Zope] .html extensions > > > Hi all, > > > > way back I saw a reference on how to make it look like Zope objects end in > > '.html'. This can be important for getting into search engines. I've got > > Apache proxying back to Zope, so I thought that mod_rewrite would be my > > friend, however Zope still generates URLs w/o the .html. > > > > Any help would be great. Thanks. > > > > Chris > > > > > > _______________________________________________ > > 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 ) > > > > _______________________________________________ > 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 ) _______________________________________________ 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: [Zope] Problem refreshing a python product
by Farrell, Troy 13 Mar '01

13 Mar '01

Thanks for all the advice. I found the problem with the -D flag. Line 10 in __init__.py was: contructors = ( Should have been: constructors = ( Oops. Thanks for all the suggestions. I'm sure they'll come in handy in the future :) By the way, line 30 in ZProductManager.py didn't exist, though the product said that was the problem. Those blasted constructors can be really useful sometimes :) Thanks again, Troy -----Original Message----- From: Phillip Crumpler [mailto:phillip@crumpler.com.au] Sent: Tuesday, March 13, 2001 7:45 AM To: Jim Washington; troy.farrell(a)wilcom.com Subject: RE: [Zope] Problem refreshing a python product It may be the formatting of the email, but could line 30 possibly begin in column 6? It might point to the line being indented one space too many... cheers Phillip ps: Sorry if this sounds like a 'are you sure it's plugged in' kind of answer, but it is better to get one of those answers when you don't need it that vice-versa =) > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Jim > Washington > Sent: Wednesday, 14 March 2001 12:19 AM > To: Farrell, Troy > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] Problem refreshing a python product > > > Hi, Troy > > Assuming the traceback below is what you are getting now, I would look > somewhere around line 30 in ZProductManager.py. But that's just a > guess. Are you running Zope in debug mode? (Look for -D in > /home/zope/Zope-2.3.1b1-src/start). Code problems with Products usually > show up on the terminal where you start zope, if you are in debug mode. > > -- Jim Washington > > "Farrell, Troy" wrote: > > > > Ok. Did that and deleted the pyc's. Now the Product isn't > showing up on > > the product page. If I undelete it, it keeps the same traceback. > > > > Debug: > > Zope version: Zope 2.3.1b1 (source release, python 1.5.2, linux2) > > Python version: 1.5.2 (#0, Apr 3 2000, 14:46:48) [GCC 2.95.2 20000313 > > (Debian GNU/Linux)] > > System Platform: linux2 > > Process ID: 7707 (4101) > > Running for: 3 min 23 sec > > > > Traceback: > > Traceback (innermost last): > > File "/home/zope/Zope-2.3.1b1-src/lib/python/OFS/Application.py", line > > 537, in import_products > > product=__import__(pname, global_dict, global_dict, silly) > > File > "/home/zope/zope/lib/python/Products/ZProductManager/__init__.py", > > line 2, in ? > > from ZProductManager import ZProductManager > > File > > > "/home/zope/zope/lib/python/Products/ZProductManager/ZProductManager.py", > > line 30 > > if REQUEST is not None: > > ^ > > SyntaxError: invalid syntax > > > > I moved the product out of the zope directory structure and > restarted. It > > was gone. Good. I brought it back in and restarted and it > isn't showing up. > > That sounds like a problem in my __init__.py file. It is below > if you don't > > mind looking it over: > > > > from ZProductManager import ZProductManager > > > > def initialize(context): > > """Initalize the ZProductManager product. > > This causes it to appear on the product list > > in the Zope installation.""" > > context.registerClass( > > ZProductManager, > > contructors = ( > > ZProductManager.manage_addZProductManagerForm, # The first method > > # is called when > > someone > > # adds the product > > ZProductManager.manage_addZProductManager > > > > ) > > ) > > > > If it helps, I'll send ZProductManager.py as well.

1 0

WebDAV + Dreamweaver
by Carl Blesius 13 Mar '01

13 Mar '01

I just got a response from dreamweaver support concerning the WebDAV problems with Zope!! they put the download to update dreamweaver WebDAV on this page http://www.macromedia.com/support/dreamweaver/ Next step is to get dreamweaver to open Zope files (files without extentions). I have already sent a request to dreamweaver (it would probably help if someone else did the same). Has anybody made progress with this in the meantime? I need a WYSIWYG editor and everyone at my university is already familiar with dreamweaver. Tips/Tricks? Greetings from Heidelberg Germany, Carl

6 6