- Zope - Zope lists

Dynamic SQL statement construct
by HCSCCS＠prudential.com.my 29 Jul '99

29 Jul '99

As usual, I'm beeen using Zope-1.10.3-src, Zap-1.10, RedHat 5.2 and lately ZPyGresql Database Adaptor. I wonder whether we can dymanicaly construct an SQL statement. Below is the following situation: DTML Method 1 :- ============ Contain 3 same combo box as the first, second and third sort key. Each combo box contains 3 sort keys, Aeg. A, B, C. User will choose the combination of keys they want and submit the page.. DTML Method 2 : ============ Display the information as the sorted manner defined in the earlier page. So how do you guys think? Can Z SQL Method do that? The followings are the possible key combinations: ABC ACB BAC BCA CAB CBA AB AC BA BC CA CB A B C Do we need to BUILD 15 Z SQL Method?? If not, what is the proper way? Please reply to hcsccs(a)prudential.com.my as well. Thanks a lot, Paul Chung Paul Chung Executive IT Department Prudential Assurance Malaysia Berhad

2 1

RE: [Zope] Dynamic SQL statement construct
by Miller, John M. 29 Jul '99

29 Jul '99

You might want to check out Anthony Baxter's data miner product at http://www.interlink.com.au/anthony/. Yeah, okay, it may be a 0.1 release, but there's plenty of good stuff in there to give you some ideas. Ciao-ness, John > -----Original Message----- > From: HCSCCS(a)prudential.com.my [SMTP:HCSCCS@prudential.com.my] > Sent: Thursday, July 29, 1999 3:47 AM > To: zope(a)zope.org > Subject: [Zope] Dynamic SQL statement construct > > As usual, I'm beeen using Zope-1.10.3-src, Zap-1.10, RedHat 5.2 and > lately ZPyGresql Database Adaptor. I wonder whether we can dymanicaly > construct an SQL statement. Below is the following situation: > > DTML Method 1 :- > ============ > Contain 3 same combo box as the first, second and third sort key. Each > > combo box contains 3 sort keys, Aeg. A, B, C. > User will choose the combination of keys they want and submit the > page.. > > DTML Method 2 : > ============ > Display the information as the sorted manner defined in the earlier page. > > > So how do you guys think? Can Z SQL Method do that? The followings are > the possible key combinations: > ABC > ACB > BAC > BCA > CAB > CBA > AB > AC > BA > BC > CA > CB > A > B > C > > Do we need to BUILD 15 Z SQL Method?? If not, what is the proper way? > > Please reply to hcsccs(a)prudential.com.my as well. > > Thanks a lot, > Paul Chung > Paul Chung > Executive > IT Department > Prudential Assurance Malaysia Berhad > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev )

1 0

DocumentTemplates -> static pages
by Jeff Bauer 29 Jul '99

29 Jul '99

Is anyone using DocumentTemplate to create static html pages? I'm using it to create dynamic pages, but it's not obvious (unless I look through the source) how I would write the contents directly to an html file (i.e. without producing quote conversions: <html> to: <html>) I could unquote the output, but that seems like extra work. -Jeff

2 3

RE: [Zope] How do I create a new db connection in Zope 2?
by Rob Page 29 Jul '99

29 Jul '99

> I've just installed Zope 2.* on a winnt machine. I've been > using 1.* with > no problems. My question is, how to I create an ODBC > database connection in > the new version? I see no option in the list of objects to > create. Thanks! One answer is, "Did you install the ODBC DA into Zope 2?" Another answer is, "You DO NOT want to use the ODBC DA until it's been tweaked to support the new transaction management mechanisms in ZODB3 (aka Zope 2)." This should happen before Zope 2 is final. Chris Petrilli here (petrilli(a)digicool.com) is the DA product manager (among the 29 other hats he wears). Expect some clarifying comments/announcements rsn. --Rob

1 0

RE: [Zope] Zope2b1 and Zclass permission ... something missing
by Kevin Dangoor 29 Jul '99

29 Jul '99

--- Michel Pelletier <michel(a)digicool.com> wrote: > > > > -----Original Message----- > > From: Kevin Dangoor [mailto:kid@kendermedia.com] > > Sent: Wednesday, July 28, 1999 10:05 PM > > To: Bill Anderson > > Cc: zope(a)zope.org > > Subject: Re: [Zope] Zope2b1 and Zclass permission > ... > > something missing > > > > I wrote: > http://www.zope.org/pipermail/zope/1999-July/007365.html > > about the same problem.. > > > From CHANGES.txt: [instructions on using new permission objects deleted] The new permission scheme makes sense, and I think it is nice and consistent... But, there are a couple things that I'm not sure are working as they should. 1) Am I correct in assuming that if something is listed as an "inherited permission", then that should be available in the Define Permissions tab for use? eg. "Access contents information" is an inherited permission. I should be able to select "Access contents information" from the drop down for the "Access contents information" permission mapping, right? For some reason that's not listed though... 2) Interestingly enough, ZClasses within ZClasses seem to behave more as I would expect them to (listing the permissions I would expect them to). However, I find that I get a "waaa" error sometimes when I try to change the permissions. Traceback (innermost last): File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 256, in publish_module File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 161, in publish File C:\Program Files\Byproducts\lib\python\ZPublisher\mapply.py, line 154, in mapply (Object: manage_setPermissionMapping) File C:\Program Files\Byproducts\lib\python\ZPublisher\Publish.py, line 98, in call_object (Object: manage_setPermissionMapping) File C:\Program Files\Byproducts\lib\python\AccessControl\PermissionMapping.py, line 136, in manage_setPermissionMapping (Object: KMItem) (Info: (['Add Database Methods', 'Add Documents, Images, and Files', 'Add External Methods', 'Add Folders', 'Add Item', 'Add MailHost objects', 'Add Manufacturer', 'Add Products', 'Add User Folders', 'Add Versions', 'Add ZCatalogs', 'Add Zope Drafts', 'Approve draft changes', 'Change DTML Documents', 'Change DTML Methods', 'Change Database Methods', 'Change External Methods', 'Change Images and Files', 'Change Versions', 'Change configuration', 'Change proxy roles', 'Delete objects', 'FTP access', 'Join/leave Versions', 'Manage ZCatalog Entries', 'Manage users', 'Save/discard Version changes', 'Search ZCatalog', 'Use Database Methods', 'Use mailhost services', 'View', 'View management screens'], 'Access contents information', 0)) Kevin _____________________________________________________________ Do You Yahoo!? Free instant messaging and more at http://messenger.yahoo.com

1 0

How do I create a new db connection in Zope 2?
by Rafael Alvarado 29 Jul '99

29 Jul '99

I've just installed Zope 2.* on a winnt machine. I've been using 1.* with no problems. My question is, how to I create an ODBC database connection in the new version? I see no option in the list of objects to create. Thanks! rca2t

1 0

RE: [Zope] How do you increment a variable?
by Kevin Dangoor 29 Jul '99

29 Jul '99

--- Tony McDonald <tony.mcdonald(a)ncl.ac.uk> wrote: > This does work, I then tried to extend it with > <dtml-with "_(counter=1)"> > <dtml-var counter> > <dtml-in "_.range(0,10)"> > <dtml-let counter="counter+1"> > <dtml-var counter> > </dtml-let> > </dtml-in> > </dtml-with> > > and got 1 2 2 2 2 2 2 2 2 2 2. > Is that because the <dtml-in> tag sets up another > name space? Actually, I believe this is because dtml-let is setting up another namespace. Your original "uglier" version works, though: <dtml-var standard_html_header> <dtml-call "REQUEST.set('counter', 1)"> <p><dtml-var counter></p> <dtml-in "_.range(0,10)"> <dtml-call "REQUEST.set('counter', counter+1)"> <p><dtml-var counter></p> </dtml-in> <dtml-var standard_html_footer> Kevin _____________________________________________________________ Do You Yahoo!? Free instant messaging and more at http://messenger.yahoo.com

1 0

RE: [Zope] How do you increment a variable?
by Michel Pelletier 29 Jul '99

29 Jul '99

> -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Thursday, July 29, 1999 10:38 AM > To: Donald Holten > Cc: Zope List > Subject: Re: [Zope] How do you increment a variable? > > > Cheers Donald, > I'm trying to not use properties of the form, as I want this to be > used by a lot of people, and I believe that everytime there is a > changeProperty call, a transaction is raised and the Zope database > grows a little more. > > Anyone know if that is the correct interpretation? Yep. -Michel > > tone. > ------ > Dr Tony McDonald, FMCC, Networked Learning Environments Project > http://nle.ncl.ac.uk/ > The Medical School, Newcastle University Tel: +44 191 222 5888 > Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2 > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: [Zope] How do you increment a variable?
by Michel Pelletier 29 Jul '99

29 Jul '99

> -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Thursday, July 29, 1999 10:40 AM > To: Michel Pelletier; Zope List > Cc: Zope List > Subject: RE: [Zope] How do you increment a variable? > > > > This does work, I then tried to extend it with > <dtml-with "_(counter=1)"> > <dtml-var counter> > <dtml-in "_.range(0,10)"> > <dtml-let counter="counter+1"> > <dtml-var counter> > </dtml-let> > </dtml-in> > </dtml-with> > > and got 1 2 2 2 2 2 2 2 2 2 2. > Is that because the <dtml-in> tag sets up another name space? Yep. Do the 'in' inside the 'let'. -Michel > ------ > Dr Tony McDonald, FMCC, Networked Learning Environments Project > http://nle.ncl.ac.uk/ > The Medical School, Newcastle University Tel: +44 191 222 5888 > Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2 >

1 0

Re: [Zope] How do you increment a variable?
by Donald Holten 29 Jul '99

29 Jul '99

Yeah. That's what Michel told me, too. Unfortunately, I don't think I had a choice in the matter... Donner

1 0