April 2000 - Zope - Zope lists

Problems with ZODBC and Ms SQL Server 7.0
by Robert Honore 25 Apr '00

25 Apr '00

Anyone ever figured out how to get ZOPE's ODBC DA to work with MS SQL Server? I am using MS SQL Server 7.0, Zope version 2.1.6, Python 1.5.2 Win 386 and ZODBC Version 3.1.0b2. Whenever I attempt to open an ODBC connection to the SQL Server I get the message "Invalid connection string:" followed by the name of the DSN I am trying to use. Can anyone help me along with this or is this the curse for using Microsoft software? Yours sincerely, Robert Honore.

1 0

SiteAccess will kill me ;-)
by Chris Withers 25 Apr '00

25 Apr '00

Right, I have a server, zope.nipltd.com and on that server lives a site, in a folder, BayC. Now, through the magic of Apache: www.bay-c.co.uk --> zope.nipltd.com/BayC Anyway, I have an access rule: <dtml-if "REQUEST.has_key('HTTP_HOST')"> <dtml-in virtual_hosts> <dtml-if "_.string.lower(REQUEST['HTTP_HOST'])==_.string.lower(_['sequence-item'])"> <dtml-call "REQUEST.setURL(path='/')"> </dtml-if> </dtml-in> </dtml-if> and I have a property of the BayC folder, virtual_hosts, set to www.bay-c.co.uk. I have a DTML method, debug, in the BayC folder, of my zope server's root: <HTML> <BODY> <a href="&dtml.url-index_html;">index_html</a><BR> <a href="<dtml-var index_html url>">index_html</a><BR> <a href="<dtml-var "this().absolute_url()">">index_html</a><BR> </BODY> </HTML> now, the above rule should mean that when I go to: http://www.bay-c.co.uk/debug I get urls: http://www.bay-c.co.uk/index_html http://www.bay-c.co.uk/index_html http://www.bay-c.co.uk/ or not? however, what I actually get is: http://www.bay-c.co.uk/BayC/index_html http://www.bay-c.co.uk/BayC/index_html http://www.bay-c.co.uk/BayC Grrrr.... To make matters worse/better, the following code (from Squishdot 0.3.2) works exactly the way (I think;) it should with the above access rule: req=self.REQUEST par=req['PARENTS'] url=req['URL1'] mylist = par[:-1] mystr = '' for p in mylist: if p.meta_type == 'Squishdot Site': p = rfind(url,mystr) if p >= 0: urlstr = url[:p] else: raise "Squishdot site_url could not compute site_url" return urlstr else: mystr = '/' + str(p.id) + mystr raise " Squishdot site_url:could not find site" return "" So the /BayC/'s get stripped out of URLS where <dtml-var site_url> is used. However, in Squishdot 0.3.4, which I would like to use, all the above code is replaced with: return self.absolute_url() Which does not work with the above access rule. More Grrrrr..... I am loosing hair and sleep :( Please help me before I am bald. Chris PS: Zope 2.1.4 SiteAccess 1.0.1

1 0

objects not available
by michael angelo ruberto 25 Apr '00

25 Apr '00

hello, i have created a few objects that i want everybody to be able to use from the drop down (add) box. unfortunately, i am the only person who can use them. what do i need to change to make these objects available to all? -<mike>-

1 0

Calling an external doument into a dtml var tag
by blueeye 25 Apr '00

25 Apr '00

Hi, I am trying...since this miserable tuesday morning, to figure out a way to call an external document from another folder into my current document. For example I call a document within my folder as: <dtml-var site_header> where site_header is within the current folder. Now if I need to call another document from another folder... as: <dtml-var external folder/external document> I tried the <dtml-with> statement and it doesn't work at all. Butch, or anyone out there.... could you please...for the love of Gawwwd...help me out here???? http://zope.menswear.com:8080/QuickStart/menswearmmsb1/home _html I am currently designing as well as zoping this site right here in the heart of Atlanta from the 16th floor!!! (phew!) Help me before I jump Blueyez from Atlanta ___________________________________________________ GO Network Mail Get Your Free, Private E-mail at http://mail.go.com

2 1

ZDiscussions - installing?
by Graham Chiu 25 Apr '00

25 Apr '00

I'm looking for advice on how to use ZDiscussions. I downloaded the .2 archive, unpacked it into my Zope root directory, and then from the Control Panel, imported ZDiscussions.zexp. I don't see a readme as mentioned on http://www.zope.org/Members/MikeP/ZDiscussions I see that I can now add a Confera topic, and a ZDiscussions topic. If I add a Confera topic, then I can add messages etc. If I add a ZDiscussions topic, it seems to give me an empty directory. What then? -- Regards, Graham Chiu gchiu<at>compkarori.co.nz

2 3

Programatically adding folders
by Chris Withers 25 Apr '00

25 Apr '00

Hi, I'm wondering what the correct way to create a folder within a folder in a DTML method is. I tried: <dtml-call "folderObject.manage_addFolder(folderNameVar)"> But wasn't convinced by the results. If you use the form in the management interface, the eventual method that gets called is: folderObject/manage_addProduct/OFSP/manage_addFolder Which would suggest I should use something like: <dtml-with "folderObject.manage_addProduct('OFSP')"> <dtml-call "manage_addFolder(folderNameVar)"> </dtml-with> But I haven't been brave enough to try it. What IS the correct way? More importantly, where are/should things like this be documented? Also, how should I find out what the 'preferred' way of doing something is? cheers, Chris

1 0

Tree-tag, expand_all, and leaves
by Andrew Williams 25 Apr '00

25 Apr '00

I am using the <dtml-tree> tag to view show a hierarchical view of some information in a database. I have leaves= pointing to a dtml document which renders a table based upon the expanded tree. All pretty simple, except if I send an expand_all=1, the actual leaves do not show; only the hierarchy. I have checked the archived mail-lists, and have patched my TreeTag.py, but that doesn't work either. Is this still an issue/bug? Thanks for any help... Andrew __________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

1 0

MessageDialog from DTML?
by Kevin Howe 25 Apr '00

25 Apr '00

Can the MessageDialog method be accessed via DTML without an external method? ex: something like this: <dtml-call "MessageDialog( title ='Success!', message='Your changes have been saved', action ='manage_main') "> kh

1 0

Desperately Seeking Zen...
by Steve Drees 25 Apr '00

25 Apr '00

I tried applying some Zen I stole from http://www.zope.org/Members/jpenny/variable_length_forms but it's just not working. Anybody out there have some extra clue to pass my way? <dtml-in "objectValues(['DTML Document'])"> <dtml-call "manage_changeProperties({ 'rank' : _['rank'+_['sequence-number']], 'artist' : _['artist'+_['sequence-number']], 'song' : _['song'+_['sequence-number']] })"> </dtml-in> --- Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: illegal argument type for built-in operation Traceback follows: Traceback (innermost last): File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: do_edit) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: do_edit) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: do_edit) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/DocumentTemplate/DT_String .py, line 502, in __call__ (Object: do_edit) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: objectValues(['DTML Document'])) File /home/drees/zope/Zope-2.1.2-linux2-x86/lib/python/DocumentTemplate/DT_Util.p y, line 335, in eval (Object: manage_changeProperties({ 'rank' : _['rank'+_['sequence-number']], 'artist' : _['artist'+_['sequence-number']], 'song' : _['song'+_['sequence-number']] })) (Info: manage_changeProperties) File <string>, line 0, in ? TypeError: (see above) -steve ---- drees(a)the-bridge.net http://www.the-bridge.net/~drees "A problem well stated, is a problem half-solved." - C. Kettering

2 1

Re: [Zope] Advice on Discussion-based products
by J. Atwood 25 Apr '00

25 Apr '00

DOH!! Just added the ZCalendar and it needs a permission of "view calendar" It should be working fine now.. http://209.219.93.106/kenya/discussions/test/ (this is what I get for acting all smart and stuff) J > From: Bill Anderson <bill(a)libc.org> > Organization: Linux in Boise Club > Date: Tue, 25 Apr 2000 10:02:08 -0600 > To: "J. Atwood" <jatwood(a)bwanazulia.com> > Subject: Re: [Zope] Advice on Discussion-based products > > http://209.219.93.106/kenya/discussions/test/

1 0