[Zope] authentication
hi everybody, i can run different versions of zope and login as superuser, setup an other user and change superuser account name and password. unfortunately i don't get authenticated when i want to login as user. means i can do no work with content at all in zope. is it normal that when i go to change the user password it shows a different amount of *s there? how does the authentication work? do any files have to be at special places for authentication? do any files need any special permission for this? my system i have it run under wwwrun:nogroup and the directory /opt/zope is root:root /opt/zope/var is wwwrun:nogroup and 755 except of files Z2.log, pcgi.soc, zProcessManager.pid that are root:root i installed zope 2.2.2, 2.2.4, compiled a 2.2.4, used an rpm, always the same problem latest i used an installation description for suse 6.4 ... -- no help did a lot as you see my system is a suse linux 7.0 with the update to kde2.0 -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] authentication II
hi everybody, after a long 10h struggle with installing and running zope i found some interesting things. may anybody be able to explain these to me? i run a suse7.0 system with a suse zope installation on 8080. i changed the access file to a new account name. with this account name i can do everything in zope, add users, add files, copy, paste ... if i add a new user i can not login for adding files ... aren't they made for that? do i understand anything wrong? are they probably only for content access? in previous (non-suse) installations i was allowed to add users to the acl_user with my superuser account but couldn't login to add files with these new accounts. greetings olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] next value
hi there,
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a
new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried nextval('adr_adr_id_seq') but get an error message
any idea?
olaf
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Zanger Nusch
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
Re: [Zope] next value
hi,
thanks for your help
i found the mistake:
i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
for a identifier field adr_id:serial i want to automatically insert a
new number max(adr_id)+1
how can this be done in an insert into sql statement?
i tried nextval('adr_adr_id_seq') but get an error message
i create the database and load it then with the command:
copy adr from stdin using delimiters ','
with this command i also load my serial field. even that i load 14 rows
the currval stays on 1
so the two lines
insert into adr (id) values (setval('adr_adr_id_seq',15));
select currval('adr_adr_id_seq');
get the value to the right level.
olaf
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Zanger Nusch
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
[Zope] duplicate column name
i there, i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse 7.0 linux when i try the line - select adr.id,fac.id from fac, adr in the database connection test field i get an error as follows: -error type: value error -error value: duplicate column name,id it worked for me until now, because i used different names everywhere. on psql it's no problem did i just screw up some settings or is it ZPyGreSQL? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] duplicate column name
I believe Zope (not PostgreSQL) needs different names for columns. Otherwise, how would it choose the name of DTML variables? Try renaming the columns with AS in the ZSQL method. well zope uses the "name" option and a "column" option for the dtml-sqltest. that works quite well, if your variable name is different from your database-column name. thanks anyway olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] duplicate column name
Ivan Cornell schrieb: Olaf Zanger wrote: i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse 7.0 linux when i try the line - select adr.id,fac.id from fac, adr You probably need to alias the columns: select adr.id as adr_id, fac.id as fac_id from fac, adr and then refer to adr_id fac_id from zope. [can't remember why, but think it is due to the way columns are addressed in libpq] thanks, worked out fine, gets a bit tricky though :-) as visible further down it is not needed in "where" and "order by" clauses *ç%?! select fac.id as fac_id, adr.id as adr_id, fac.name as fac_name, adr.id as adr_id, owner_adr_id, from fac,adr where fac.name like '%' and adr.id=owner_adr_id and fac.mod_id=mod.id order by fac.name -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] Zpdf
hi everybody, i just imported some dtml structures into a zpdf_0-0-1 document and figure out that it does ignore the dtml alltogether. is that how it is meant to be? thanks for help -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] FieldDocument
hi there,
FieldDocument.zexp (downloadable from www.zope.org) does everything fine
except of creating the actual input field.
a second error is that
dtml-call "REQUEST.set('field_debug')"
does not work, even if i add a third operand as requested
dtml-call "REQUEST.set('field_debug',_)"
what's the trouble, does anybody use it?
unfortunately i have no clue of python and am therefore lost in space
for debugging
thanks
olaf
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Zanger Nusch
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
[Zope] ZNavigator
hi there, i installed ZNavigator2.00.tgz on zope 2.2.2 if i try to use the examples i can install them i can edit the pages, but if i want to view them a error page "invalid date-time string" appears any idea? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] ZNavigator
Jonas Juselius schrieb: Yes I have an idea... ;-) Due to some changes in Zope2, the ZNavigator broke... Try to get the latest version (2.02) from www.zope.org/Members/jonas/ZNavigator/ and install the examples from that distro instead. thanks for the tip, but didn't help, sorry navbar_dtml shows first icon right, second and third as "_" on click to second i come to Foo, click to first and third "date-string error" i copy /simple_demo/foo/index_html to /simple_demo/bar/index_html and it works unfortunately i can not find any differences between /bar/index_html and /foo/index_html what's up? olaf -jonas- On Fri, Dec 08, 2000 at 07:59:57AM +0100, Olaf Zanger wrote: hi there, i installed ZNavigator2.00.tgz on zope 2.2.2 if i try to use the examples i can install them i can edit the pages, but if i want to view them a error page "invalid date-time string" appears any idea? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com Content-Description: Visitenkarte für Olaf Zanger -- And what is good, Phaedrus, And what is not--- Need we ask anyone to tell us these things? [ PGP public key: http://www.iki.fi/jonas/pubkey.asc ] -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] ZNavigator
well, i installed navigator_demo.zexp and the ZNavigator folder from 2-00 and 2-01 respectively that i downloaded yesturday didn't help, but solution solution: delete navigator_demo/simple_demo/infobar/nonsens and simple_demo works your selection of objekt names, bar entries and the respective differences does unfortunately not really support bugtracking :-( since the complex_demo does not give any positive sign i give up here i would love to understand the complex_demo too, in case you have the correct version feel free to email it to me. thanks for your help and your product anyway olaf Jonas Juselius schrieb: Did you _install_ the code for ZNavigator 2.02 _and_ the examples in that dist? (Remove the old ZNavigator and the examples...). When did you download the ZNavigator from the Zope site? When I fixed the ZNav, I managed to upload a faulty version, which was up for a day or two before I noticed... ;( Unfortunately I didn't change the version numbers when I corrected my mistake. I corrected my mistake a couple of months ago, so if your 2.02 is newer than that it should be OK. It's important for me to know, before I start hacking... The problem is that (if I remember correctly, I have not looked at the code for some time...) the DateTime stuff in Zope changed at some point. I had to change the ZNavigator, so that it now uses Date _strings_ internally, instead of DateTime objects... The problems arise because old NavItems (although you cannot see it), have their date and expire data stored as DateObjects instead of as strings. What you can try to do to fix the problems is to walk through (either by hand or by DTML) your NavItems, open them and _save_ them back without any modification. This should fix the problems. Another thing you can look at is the precision of the date. The date should have a precision of one day, not in seconds... (This was one of the problems the the new DateTime objects, and the easiest way to fix it was to make dates strings and convert strings to DTObjects when date comparison/algebra is needed...) Of course it is possible that there is a bug somewhere, but I and a number of people have been using the current version for months without problems. Let me hear how it went, take care, -jonas- On Fri, Dec 08, 2000 at 10:51:30AM +0100, Olaf Zanger wrote: Jonas Juselius schrieb: Yes I have an idea... ;-) Due to some changes in Zope2, the ZNavigator broke... Try to get the latest version (2.02) from www.zope.org/Members/jonas/ZNavigator/ and install the examples from that distro instead. thanks for the tip, but didn't help, sorry navbar_dtml shows first icon right, second and third as "_" on click to second i come to Foo, click to first and third "date-string error" i copy /simple_demo/foo/index_html to /simple_demo/bar/index_html and it works unfortunately i can not find any differences between /bar/index_html and /foo/index_html what's up? olaf -jonas- On Fri, Dec 08, 2000 at 07:59:57AM +0100, Olaf Zanger wrote: hi there, i installed ZNavigator2.00.tgz on zope 2.2.2 if i try to use the examples i can install them i can edit the pages, but if i want to view them a error page "invalid date-time string" appears any idea? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] Help documents broken
Hi there, i have quite some products imported, they also work properly, but the help document is broken. which Product do i need to install to make them run? thanks in before olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] default values in forms
hi there, i'd like to send default values for an data update with the link to the form like a href="adr_change_frm?f_id=dtml-var idf_name=dtml-var name"c/a unfortunately name may contain spaces. i found out that spaces may be replaced by "+" in the link, but how do i get the "+" into the dtml-var ... statement? thanks for help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] ftp ZSQL Methods
hi there, is it possible to externally edit ZSQL Methods? they show 0 bytes and no rights in my ftp client! thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] ZBabel translation to Postgres
Hi there, i'm using ZPyGreSQL successfully for my database. To keep it simple i don't want to use MySQL for ZBabel. ZBabel though uses some MySQL specific syntax which i am unsuccessfully translating to PostgreSQL syntax: Description "md5Hash" are the same fore entries with different "lang" fields. They are used to translate depending on selected language. SELECT Phrases.* FROM Phrases LEFT JOIN Phrases as b ON Phrases.md5Hash = b.md5Hash AND Phrases.lang b.lang WHERE b.md5Hash is NULL AND Phrases.lang=dtml-sqlvar srcLang type=nb What does the whole thing do anyway? How can you join "Phrases.md5Hash = b.mdf5Hash", while "md5Hash is NULL"? What is different in the LEFT JOIN ... ON ... statement to a normal WHERE clause? My try for translation to PostgreSQL (which I assume is completely ignorant): SELECT Phrases.* FROM Phrases as b WHERE Phrases.md5Hash *= b.md5Hash AND Phrases.lang b.lang AND b.md5Hash is NULL AND Phrases.lang=dtml-sqlvar srcLang type=nb Has anybody ported ZBabel already? Thanks for help Olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [ZOPE] ZBabel translation to Postgres
hi andrew,
thanks for the description. i figured it as far as that:
you need in postgresql (this is tested only from zope with zsql method,
since some other things don't work in the ZBabel Produkt with
postgresql):
sqlGetPhrasesToUpdate:
select distinct Phrases.*
WHERE md5Hash not in
(
select c.md5Hash
from Phrases as c, Phrases as d
where c.md5Hash = d.md5Hash and c.lang d.lang and c.lang='dtml-var
srcLang'
)
and lang 'dtml-var srcLang'
sqlNewPhrase:
insert into Phrases (phrase_id,lang,md5Hash,renderPath,renderText)
values (
nextval('phrases_phrase_id_seq'),
dtml-sqlvar lang type=nb,
dtml-sqlvar md5Hash type=nb,
dtml-sqlvar renderPath type=nb,
dtml-sqlvar renderText type=nb
)
all other sqlFunctions seam to work (out of zope ZSQL method)
i attache the ZBabel.sql for postgres.
the examples are handgenerated so the hashes are fake.
TAKE CARE
until now this just fakes the ability of ZBabel on Postgres on a ZSQL
Method level for testing purposes.
I get errors:
when i first want to view a page with the dtml-babel src=uk dst=de
test/dtml-babel
pg.error
error value: error: attribute 'phrases_phrase_id_seq' not found
probably that helps anybody
olaf
| What does the whole thing do anyway?
Finds all the phrases that don't have a translation for the language
selected. It's hard to find things that don't exist in databases without
nested selects which MySQL did not have at the time.
MySQL was chosen precisely because it is restricted, and is basically the
lowest common denominator when it comes to SQL.
I do recall however, that postgres only implements INNER and OUTER joins
although I don't know the status of the JOIN stuff in postgres at this time.
| Has anybody ported ZBabel already?
Someone was going to send me patches for postgres, but, I never received
them.
I'll happily integrate patches, although, automatically selecting the
right query based on database type will be required so that several releases
aren't required. I don't think that that's a hard thing to achieve.
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
phrases.sql
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
Re: [Zope] ZBabel translation to Postgres
hi Phil, The left join is a notation that says to get all records from the left hand side of the join and only those records where the criteria matches from the right hand side. It is btw a part of most RDBMS engines I've ever used, so it's not that unusual a syntax. You can also do something similar by using unions. thanks a lot for that, do you have any suggestion (principally) how this union would look like thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] ZPattern -- compiling
hi everybody, where is ExtensionClass.h supposed to be, it is called in cPersistence.h does it come with zope, zpattern or python? where do i get the Makefile.pre.in from? can i copy it from MySQLDB-1.2.0? thanks for help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com -- Sent through GMX FreeMail - http://www.gmx.net ___ Zope maillist - [EMAIL PROTECTED] 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] zbabel -- sort order screwed up
hi everybody, i work with zbabel 0-0-3, ZMySQLDA 1-2-0, MySQLdb 0-1-2 and zope 2-2-4 i do sql queries with order by clause with no problem at all, but if i use zbabel translate tab (uses python-sql methods) it sends back an unordered list which screws up my translator view. i change the sql in my python files, but it doesn't use it at all. i stop and start zope, exit netscape, ... ... but still the used sql is obviously the same, whatever i do. is there a cash for sql parts that survives the stop of zope? where might be the error thanks olaf -- Sent through GMX FreeMail - http://www.gmx.net ___ Zope maillist - [EMAIL PROTECTED] 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] filename extension
hi there, some information on zope.org says that in the early future ftp access should be possible not only to dtml-methods, -documents but also to Zsql-methods. to be future proof (and windows software proof) we'd like to have .xxx extensions for all our methods (fac_browse_method.sql that lovely windows understands what programm to start [textpad for sql ...]) unfortuanetly if called like dtml-in expr="fac_browse_method.sql(id=10)" zope gernerates an error. if there is a solution: how? or if not: does anything needs to be changed in the file handling of zope thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] zpattern compiling
hi everybody, after a long weekend i still searching ExtensionClass.h where is it supposed to be, it is called by cPersistence.h when compiling zpatterns does it come with zope, zpattern or python? where do i get the Makefile.pre.in from? can i copy it from MySQLDB-1.2.0? thanks for help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] no result of change in products python methods
hi everybody, my changes in the sql parts of the python files of the zbabel product do not show changed behaviour in the product after restart of zope. what could be the reason? do i have to do anything with python too? setup is Zbabel 0-0-3, ZMySQLDA 1-2-0, MySQLdb 0-1-2 and zope 2-2-4 thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] filename extension
hi there, thanks for the answer, but ... [EMAIL PROTECTED] schrieb: Untested: dtml-in "_['fac_browse_method.sql'](id=10)" Does it work? nope dtml-in "_['adr_select_method.sql'](id=man_adr_id)" Error Type: Bad Request Error Value: ['id'] this (with the renamed file) works though: dtml-in "adr_select_method(id=man_adr_id)" is there any documentation for these tricks? thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] [Newbie] Can Zope ...
hi there Smith Ray schrieb: * Runs on Windows NT/2000 only. (Zope can + many others) yes * Uses MS IIS only (I believe Zope can use IIS + built in web server + others) apache, zserver, iis * Uses MS SQL Server (I believe Zope can + built in DB + others) zope with mysql, postgresql, informix, ... * Allows non technical people to create content plus add users / managers etc without any HTML knowledge or knowledge outside of the package. product: IEMethod wysiwyg even in internet explorer. really great! check it out * Has good security system allowing users to belong to groups which "may" have different content. Also managers have profiles allowing the restriction of content and actions performed. no problem * Has a news module with multiple classes of news. products: ZDocumentStore, ... * Has a basic calendar system. products: EventFolder (very powerfull), EvTracker (very simple) * Has a basic messaging system. * Has a basic knowledge base ... allows free format text to be entered and later searched. "Catalog" * Allows external documents to be loaded associated with a group where keywords can be manually entered. These documents can then be opened or downloaded if users have correct permissions. easy to realize i assume * Basically all content added can be added to specific groups, and if you don't have access that that group you don't have access to that content. right (roles, users, acl-user-folders) There are probably a few things I missed but you get the idea. The cost thrown up in the air was in the order of $AUS20,000 for a 3 year rental, per site (At the moment that is about $US35,000) When you start talking dozens of sites you quickly start looking for alternatives! they must be jokeing My initial thought was Zope, I knew it existed and assumed with a good design and few months work a could produce similar results with a fraction of the costs. Okay, sorry for the long email ... my questions ... Are there any "Intranet" type packages which have similar functionality to what I have quickly described? just go create it, 4 weeks and you know how it goes. If I had to build something like this myself would Zope be the tool of choice? (I'm assuming it would be since I'm on a Zope list!) absolutely How long (rough estimate) would something like this take to develop for a Zope newbie? (Assume say 10 viewable screens and 10-20 maintenance screens with 5-30 fields per screen. I have programming (Cobol, VB, etc), HTML, DB and analysis experience) about 3 months to make it decent olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] ZGDChart
hi there, a great product, just i want to have a form to enter some parameters for the SQL Method call. since zgdchart-product calls the SQL Method i don't know how to pass the parameters. does anybody has an idea? thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] Re: ZGDchart -- passing parameters to SQL Metho
hi there, thanks was a good tip. is all "exampled" in the "index_html" of gdchartdemo. good work. olaf Chui Tey schrieb: Look at the gdchartdemo, there is an example of it. it looks something like dtml-var "chtSales(sales=2500)" Chui - Original Message - From: Olaf Zanger [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 4:52 AM Subject: ZGDchart -- passing parameters to SQL Metho hi there, a great product, just i want to have a form to enter some parameters for the SQL Method call. since zgdchart-product calls the SQL Method i don't know how to pass the parameters. does anybody has an idea? thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] mysql connection string
hi there,
two times trouble
first:
right now my setup uses a connection string "db root" which doesn't seam
to give a lot of savety :-).
at my provider i have a login, but sure no root access to the db.
* how does the connection string look for user name "peter-hauser" and
password "test3-.2"?
* has the user to be set up in "linux" ?
* how is the setup made in "mysql"?
i tried with "grant all privileges on *.* to "peter-hauser"@localhost;"
and "set password for "peter-hauser"=password('test3-.2');"
but wasn't successful.
* has zope to be run by user "peter-hauser"?
second?
to set up a 3-tier application i should know how to connect mysql
through MySQL-python 0.3.0 and ZMySQLDA 2.0.1 to my db-server.
* i can browse from the zope server to the db-server "pit" and otherway
round with the names "pit" and "pitechon", so "hosts" file should be
correct.
* how has the connection string to look like?
i tried "db@pit 'peter-hauser'" but it didn't work?
* has mysql to be started with an special flag to open a port?
* does it work with the ip-number?
thanks for help
olaf
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
[Zope] change parameter by mouseclick
Hi everybody,
Right now we use the following statement to change the language on every
page the user is. very neat made by the NFGnav guys.
a href=dtml-var URL0?ll=defont color=yellowGerman/font/a
unfortuanately if the user is on a page with an url like this
http://sino:8080/ipOperate/reports/fac_base_report.htm?fac_id_only=mod_id_only=inv_id_only=setup_min_date=setup_max_date=month=year=min_date=max_date=nowirr_avg=browse=anzeigen
yes, i'm proud on that one :-)
the statement doesn't work anymore :-) because it doesn't simply change
the
"ll" variable to "de" but also kills quite some other needed variables
(all, actually)
i assume the solution goes with this one, but how can i activate in a
menu without
fucking up my lovely url?
dtml-call "REQUEST.set('ll','de')
thanks for help -- and you guys are great help :-)
hope to give back some know how after this project slows a bit down
olaf
--
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard
[Zope] DNS/access problems
hi there, for presentation purposes i installed zope on suse 7.0 on a laptop with port 8090. i was able to access apache on port 80, i was able to access http://vaio:8090/ipOperate but then, when i clicked to any link i got an error. any idea where to search? thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] ANNOUNCE: please have a look at ZDatabaseTool
hi there, according to what i have seen on the homepage it seems like ZDatabaseTool is the missing link to push zope to a all in one solution. until now we solved most of our stuff with znolkwizard. this is a great product for what it is designed. it has some shortcomes though. ZDatabaseTool would improve our daily work to a great extend. since also we are not sponsored (:-) we can only offer debugging and ideas from a different user aspect. is the product planned to ship under GPL or an corresponding licence? is it possible to get a tarball for testing? thanks for the great thing anyway olaf Andreas Heckel schrieb: We at easyleading.org are pleased to announce a new Zope Product. ZDatabaseTool provides a set of wizards to let you manage databases more comfortable. At the moment PostgreSQL is supported. The code is not yet released but I want you to have a look at the screen shots and the online demo. http://www.zope.org/Members/aeg/ZDatabaseTool -- Andreas Heckel [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] ANNOUNCE: please have a look at ZDatabaseTool
hi there Andreas Heckel schrieb: Olaf Zanger wrote: hi there, tested the printing facility (nicely done by pdf). it crashes * acrobat reader 4.05 on win98 and * the pdf/ps/ghostview part of konqui doesn't like it either, it works though under * acrobat reader 4.0 on suse 7.0 Hi Olaf, thanks for your feedback. Unfortunately I can't reproduce the error. Development is done on Linux and it looks fine. I tested it just two minutes ago on the Win98 box of my girlfriend. Acrobat 4.05a 113001:28 ; IE 4.0 (version 4.72.3110.1) What can I say ... it works :-( So could you please have a look at the about boxes of your browser and Acrobat Reader and report your versions ? acroread 4.05a 113001:28 (the same as yours) ms ie 5.00.2919.6307 also happens with netscape 4.73 de so it might be acrobat reader on my system. sorry -- can't test it more exactly without having it installed BTW: Why I'm not surprised the trouble starts with Win ;-) you are not alone on that -- ah, let's have another flamewar. but, as you know there are people using this on the desktop. probably you could tell me when you release it thanks olaf p.s. the crash: ACROBAT verursachte einen Fehler durch eine ungltige Seite in Modul KERNEL32.DLL bei 016f:bff9db61. Register: EAX=c0030944 CS=016f EIP=bff9db61 EFLGS=00010212 EBX= SS=0177 ESP=008ffe68 EBP=00900104 ECX= DS=0177 ESI= FS=9d17 EDX=00900144 ES=0177 EDI=00615980 GS= Bytes bei CS:EIP: 53 8b 15 e4 9c fc bf 56 89 4d e4 57 89 4d dc 89 Stapelwerte: -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] ANNOUNCE: please have a look at ZDatabaseTool
hi andreas, according to what i have seen on the homepage it seems like ZDatabaseTool is the missing link to push zope to a all in one solution. Thanks for the flowers ;-) that's for free :-) until now we solved most of our stuff with znolkwizard. this is a great product for what it is designed. it has some shortcomes though. I never tested ZNolk ... I found it just 2 minutes ago on the product list. As far as I understand it helps you creating ZSQLMethods and ZDTMLDocuments for searching, inserting, updating and so on. Unlike ZNolk ZDatabaseTool's Wizard creates a ZDatabaseWizard object. So if you give new features to this class all your already existing ZDatabaseWizard instances will take advantage of this new behavior. well, that's missing in znolk :-( So far I only decided definiet to give the code back to the community in one or the other way. that's great to hear is it possible to get a tarball for testing? Not at this time. It's my first product. There is not only one line to comment the code! probably the source is the documentation? or finally somebody helps you out with documentation. Das kann ich euch wirklich nicht antun. (Sorry ... Altavista is unable to translate this line ;-) ah, you mean you can't do that to us? anyway, probably you want to tag it as "alpha/beta/non documented" or so -- that helps novices to keep fingers off :-). anyway, as you said, you want to let it free so probably early freedom helps to raise the child quickly :-) olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope] orphan handling/sequence-size bug?
sorry, got probably lost in space hi there, we take the sequence-size as seq_size for a dtml-in statement from a formular with 'get' (as shown in DTML.html under batch processing) (dtml-in rep.sql size=seq_size start=query_start) if the seq_size is 2 and larger there is no trouble, if it is 1 (seq_size=1query_start=2) 'next-sequence' does not exist in the second batch. therfore it doesn't show a next-batch-link in the second batch. seems to be a problem with the orphan handling thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
[Zope-dev] filename extension
hi there, some information on zope.org says that in the early future ftp access should be possible not only to dtml-methods, -documents but also to Zsql-methods. to be future proof (and windows software proof) we'd like to have .xxx extensions for all our methods (fac_browse_method.sql that lovely windows understands what programm to start [textpad for sql ...]) unfortuanetly if called like dtml-in expr="fac_browse_method.sql(id=10)" zope gernerates an error. if there is a solution: how? or if not: does anything needs to be changed in the file handling of zope thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
