[Zope] orphan handling/sequence-size bug?

2001-01-31 Thread Olaf Zanger

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



Re: [Zope] ANNOUNCE: please have a look at ZDatabaseTool

2001-01-29 Thread Olaf Zanger

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

2001-01-29 Thread Olaf Zanger

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

2001-01-29 Thread Olaf Zanger

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] DNS/access problems

2001-01-25 Thread Olaf Zanger

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



[Zope] change parameter by mouseclick

2001-01-16 Thread Olaf Zanger

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] mysql connection string

2001-01-15 Thread Olaf Zanger

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] Re: ZGDchart -- passing parameters to SQL Metho

2001-01-11 Thread Olaf Zanger

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] ZGDChart

2001-01-10 Thread Olaf Zanger

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-dev] filename extension

2001-01-08 Thread Olaf Zanger

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] filename extension

2001-01-08 Thread Olaf Zanger

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

2001-01-08 Thread Olaf Zanger

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

2001-01-08 Thread Olaf Zanger

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

2001-01-08 Thread Olaf Zanger

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 ...

2001-01-08 Thread Olaf Zanger

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] ZPattern -- compiling

2001-01-06 Thread Olaf Zanger

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

2001-01-06 Thread Olaf Zanger

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] ZBabel translation to Postgres

2001-01-04 Thread Olaf Zanger

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

2001-01-04 Thread Olaf Zanger

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

2001-01-04 Thread Olaf Zanger

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] ftp ZSQL Methods

2000-12-19 Thread Olaf Zanger

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] default values in forms

2000-12-13 Thread Olaf Zanger

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] Help documents broken

2000-12-12 Thread Olaf Zanger

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



Re: [Zope] ZNavigator

2000-12-08 Thread Olaf Zanger



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

2000-12-08 Thread Olaf Zanger

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



Re: [Zope] next value

2000-12-07 Thread Olaf Zanger

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

2000-12-07 Thread Olaf Zanger

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

2000-12-07 Thread Olaf Zanger

 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

2000-12-07 Thread Olaf Zanger



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

2000-12-07 Thread Olaf Zanger

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

2000-12-07 Thread Olaf Zanger

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

2000-12-07 Thread Olaf Zanger

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] next value

2000-12-06 Thread Olaf Zanger

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



[Zope] authentication II

2000-11-30 Thread Olaf Zanger

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] authentication

2000-11-28 Thread Olaf Zanger

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