- Zope - Zope lists

Javaapplet replacing ZMI navtree?
by Peter Bengtsson 09 Apr '01

09 Apr '01

Look at this for example. http://www.spigots.com/outline.htm Has anybody successfully tried to replace the nav tree in the ZMI with an applet like this. I can see a great use for it. Especially, if you like me do a lot of work on a slow modem connection. This applet can be loaded in once and then you have it there. Alternativly you load the old navtree by default and if you decide to stay in the ZMI for a while, you click to load in the java applet. Or perhaps somebody's managed to successfully replace it with a good little javascript?? Future directions? Peter

2 1

Re: change permissions in dtml?
by Klaus Herrmann 09 Apr '01

09 Apr '01

ok, forgot this one, found the calls looking into Role.py is there a complete reference doc for all these calls? > I have another problem: How do i change the permissions of a role via > dtml? i have all the methods to get the permission settings, but i > couldn't find on to set them! :-( > > how does this work? -- Klaus Herrmann <klaus.herrmann(a)gmx.net>

1 0

problem with lines properties
by Timothy Wilson 09 Apr '01

09 Apr '01

Hi everyone, I've built a couple ZClasses that utilize a "lines" property that, when an instance of the class is viewed, is rendered as a <ul>. The problem is that when the instance is first viewed, the iteration through the lines property doesn't work correctly and I get a one-item <ul> with all the lines rendered in the same <li>. Strangely, if I visit the ZMI edit screen for the instance and click on "Save Changes" then the instance displays perfectly every time after that. Anybody seen anything like this? -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/

3 6

[Zope]re: Help regarding databse & variable management
by Richard Moon 09 Apr '01

09 Apr '01

You can do this in one ZSQL Method - like this example ... The table tune_name has a unique key on tune_name_id, this value is generated when a row is inserted because there is a sequence defined as follows CREATE SEQUENCE "tune_name_tune_name_id_seq" start 15 increment 1 maxvalue 21474 83647 minvalue 1 cache 1 and tune_name.tune_name_id is defined as "tune_name_id" int4 DEFAULT nextval('tune_name_tune_name_id_seq'::text) NOT NULL, So the ZSQL Method looks like this INSERT INTO tune_name (tune_name, search_name, user_id) VALUES ( <dtml-sqlvar "cap_names(tune_name)" type=string>, <dtml-sqlvar search_name type=string>, <dtml-sqlvar user_id type=int>) <dtml-var sql_delimiter> INSERT INTO tune_x_name (tune_id, tune_name_id, user_id) SELECT <dtml-sqlvar tune_id type=int>, currval('tune_name_tune_name_id_seq'), <dtml-sqlvar user_id type=int> FROM users WHERE <dtml-sqltest user_id type=int> <dtml-var sql_delimiter> The second insert (INTO tune_x_name) gets the current value tune_name_tune_name_id_seq as that is the value of tune_name_id which has been written to the table tune_name. The only way I know to get at this value though is within a SELECT statement so I have made a dummy SELECT on the table 'users' which I am certain will return one, and only one row. When I ported this to MySQL there was no currval function so I coded the same thing as follows (again tune_name.tune_name_id is a unique key value generated when a row is inserted into tune_name - it is defined as tune_name_id int4 NOT NULL AUTO_INCREMENT PRIMARY KEY,) LOCK TABLES tune_name WRITE, tune_x_name WRITE <dtml-var sql_delimiter> INSERT INTO tune_name (tune_name, search_name, user_id) VALUES ( <dtml-sqlvar "cap_names(tune_name)" type=string>, <dtml-sqlvar search_name type=string>, <dtml-sqlvar user_id type=int>) <dtml-var sql_delimiter> INSERT INTO tune_x_name (tune_id, tune_name_id, user_id) SELECT <dtml-sqlvar tune_id type=int>, MAX(tune_name_id), <dtml-sqlvar user_id type=int> FROM tune_name <dtml-var sql_delimiter> UNLOCK TABLES Which I guess would work just as well with PostgreSQL but I haven't tried it. HTH At 17:01 08/04/01, you wrote: >To: zope(a)zope.org >Cc: zope-dev(a)zope.org, zope-checkins(a)zope.org >Subject: [Zope] Help regarding databse & variable management > >Hello, > I have a problem in database connectivity in Zope >with Postgres. If anybody can help me in this regard >please reply asap. > > I want to insert a row into a tabel, get a unique >id from the table and make another entry into another >table.I am able to insert into the forst table and >retrieve the unique ID. But while trying to insert >into the next table, it says no value for the unique >id retireved. > >Expecting a solution. > >Reagrds, > George Richard Moon richard(a)dcs.co.uk

1 0

<dtml-if expr="absolute_url == PageUrl">
by Stefan Mallepell 09 Apr '01

09 Apr '01

Hi Can anybody tell me why the following code is never get into the "if Bit" of the condition? Even when "absolute_url" and "PageUrl" are really 100% identicly .... How can I make this working? <dtml-let PageUrl="absolute_url"> ... some other staff (in, if and with ...) ... <dtml-if expr="absolute_url == PageUrl"> THAT'S IT .... !!! <dtml-else> // <dtml-var absolute_url> // <dtml-var PageUrl> </dtml-if> <dtml-let> I'm allready 2 days to late with this ... I'm really happy about any help Thanks in advance. Stefan

2 2

Re: [Zope] <dtml-if expr="absolute_url == PageUrl">
by Oliver Bleutgen 09 Apr '01

09 Apr '01

> Hi > Can anybody tell me why the following code is never get into the "if Bit" > of > the condition? Even when "absolute_url" and "PageUrl" are really 100% > identicly .... How can I make this working? > <dtml-let PageUrl="absolute_url"> > ... some other staff (in, if and with ...) > ... <dtml-if expr="absolute_url == PageUrl"> > THAT'S IT .... !!! > <dtml-else> > // <dtml-var absolute_url> > // <dtml-var PageUrl> > </dtml-if> > <dtml-let> > I'm allready 2 days to late with this ... I'm really happy about any help Stefan, <dtml-var absolute_url> is NOT the same as <dtml-var "absolute_url"> The first _calls_ the method absolute_url, the second renders something like <Python Method object at 86d8d40>, which is clearly not equal to the string PageUrl <dtml-if expr="absolute_url() == PageUrl"> should work. cheers, oliver

1 0

change permissions in dtml?
by Klaus Herrmann 09 Apr '01

09 Apr '01

Hi! I have another problem: How do i change the permissions of a role via dtml? i have all the methods to get the permission settings, but i couldn't find on to set them! :-( how does this work? thanks, Klaus -- Klaus Herrmann <klaus.herrmann(a)gmx.net>

1 0

Fwd: RE: [Zope] Apache virtual host combined with Zope
by Sherwood Robinson 09 Apr '01

09 Apr '01

Woops! forgot to reply to all on this one >Date: Mon, 09 Apr 2001 09:25:32 -0400 >To: <patrick(a)spice.eahd.or.ug> >From: Sherwood Robinson <srobinson(a)fredericksburg.com> >Subject: RE: [Zope] Apache virtual host combined with Zope > >Here is how I would handle this with proxypass: >In Virtualhost for hostone: > >ProxyPass / http://my.ip.he.re:8080/hostone/ >ProxyPassReverse / http://my.ip.he.re:8080/hostone/ >ProxyPass /misc_ http://my.ip.he.re:8080//misc_ >ProxyPass /p_ http://my.ip.he.re:8080//p_ > >in Virtualhost for hosttwo >ProxyPass / http://my.ip.he.re:8080/hosttwo/ >ProxyPassReverse / http://my.ip.he.re:8080/hosttwo/ >ProxyPass /misc_ http://my.ip.he.re:8080//misc_ >ProxyPass /p_ http://my.ip.he.re:8080//p_ > > >Now in zope manage goto your hostone folder and add the siteroot like this > > Base: www.hostone.com >Path: / > >In Zope manage goto your hosttwo folder and add the siteroot >Base: www.hosttwo.com >path: / > >Should do the trick... just remember if you want to manage anything in the >root folder of your zope install you will need to use >http://my.ip.here:8080/manage > >Hope this helps > > >At 01:18 PM 4/7/2001 +0300, you wrote: >>A related question; what if I want two virtual hosts... >>www.hostone.com and >>www.hosttwo.org >> >>And in my zope installation I want to have this sort of folder >>organisation: >> >>root| >> |->hostone >> |->hosttwo >> >>and I want zope to serve www.hostone.com from hostone and www.hosttwo.org >>from hosttwo. >> >>I tried a proxy pass for >> www.hostone.com to http://my.ip.he.re:8080/ >>and another for >> www.hosttwo.org to http://my.ip.he.re:8080/ >>and two site roots in my zope installation; >> In hostone: >> baseurl=http://www.hostone.com >> path=/ >> In hosttwo >> baseurl=http://www.hosttwo.org >> path=/ >>The problem is that when I did that, I could not get to any management >>screen; in short my zope just died and I had to reinstall; How should I >>have gone about this? >> >>Thanks. >> >>On Fri, 6 Apr 2001, Oleg Broytmann wrote: >> >> > On Fri, 6 Apr 2001, Timothy Wilson wrote: >> > > On Fri, 6 Apr 2001, Oleg Broytmann wrote: >> > > > Ah, so your problem is different from what I though. I thought you >> want to >> > > > serve some dirs from Apache, and some from Zope. >> > > >> > > Oleg, >> > > >> > > What you're talking about *is* what I want to do. But i haven't been >> able to >> > > figure out for sure what I need to do. Let me give you an example... >> > > >> > > On Debian, my root for html document is /var/www. I can use a >> virtual host >> > > entry in my apache config and ProxyPass to direct all requests for >> spam.org >> > > to spam.org:8080. No problem there. Let's say, however, that I have a >> > > /var/www/eggs directory that I would like served by apache. Can >> ProxyPass do >> > > that by itself. >> > > >> > > In other words, >> > > >> > > www.spam.org should come from Zope at spam.org:8080 >> > > www.spam.org/eggs should come from Apache (/var/www/eggs) >> > > >> > > Do I need a Rewrite rule? >> > >> > No. Use <Location> inside your <VirtualServer>: >> > >> > <Location /egg> >> > ProxyPass ... >> > </Location> >> > >> > Thus some parts of the virtual server will be served from as usual, and >> > some (started with /egg) will be served by different rules. >> > >> > Oleg. >> > ---- >> > Oleg Broytmann http://www.zope.org/Members/phd/ phd(a)phd.pp.ru >> > Programmers don't die, they just GOSUB without RETURN. >> > >> > >> > _______________________________________________ >> > 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 ) > >---------------------------------------------------- >Sherwood Robinson >Hostmaster >The Free Lance-Star/Internet Department >srobinson(a)fredericksburg.com >http://www.fredericksburg.com > >616 Amelia St. >Fredericksburg, VA 22401 >540-374-5000 ext. 5657

1 0

Querying ZCatalog with indexes "in OR"
by Ruberl Michele 09 Apr '01

09 Apr '01

Hi everybody, I have a ZCatalog with a lot of indexes on boolean fields. If I query it from DTML, it returns correctly the results of a query like the SQL "SELECT xxxx WHERE (A=0 AND B=0 AND C=1)" I'd like to query it from DTML, obtaining the results as from the SQL query "SELECT xxxx WHERE (A=0 OR B=0 OR C=1)" How can I get that? Or where can I find infos about that? Mik

2 1

Re: [Zope] Uploading to LocalFS object
by paul_s_johnson＠urscorp.com 09 Apr '01

09 Apr '01

Thanks Dieter. That did the trick. I have a folder named "file" and I believe it was latching on to that instead of the form variable named "file". > > <dtml-call "REQUEST.set('file',file)"> >This is redundant, but should not be harmful. > > <dtml-with "LocalFS_objekt_id"> > > <dtml-call "manage_upload(file, id='',action='manage_workspace')"> > > </dtml-with> > > ... > > Produces the following error... > > ============================ > > Error Type: AttributeError > > Error Value: filename > > =========================== >Strange. > >Maybe, you fetch an unexpected "file" from somewhere that >does not have a "filename" attribute. >Replace "file" by "REQUEST.form['file']" in the "manage_upload". > > >If it does not help, we need (at least) the last part >of the traceback. > > >Dieter > >_______________________________________________ >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