[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) () if the seq_size is 2 and larger there is no trouble, if it is 1 (&seq_size=1&query_start=2) 'next-sequence' d

[Zope] compress data.fs

2001-01-31 Thread Olaf Zanger
hi there, my data.fs grew to formidable 42MB, since we'd deleted quite some stuff we'd like to compress it (get rid of the undo data for old stuff) how to do that? thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-

[Zope] set variable for a user/cookie?

2001-01-31 Thread Olaf Zanger
hi there, NFGNav uses a variable to switch languages. it changes the variable in the submit string. since i use this string for other purpose i need a different solution. how do i set a var for a user for the complete session? would cookies solve my problem? where do i find know-how to set a c

Re: [Zope] [OT perhaps] ZMySQLDA

2001-01-30 Thread Olaf Zanger
mysql is case sencitive olaf Lee Reilly CS1997 schrieb: > > Hi, > > I wonder if someone could comment on what they think my problem with the > following may be. > > I have the ZMySQL DA installed, which works fine (I think). > > Testing my database in UNIX I created a table and populated it

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

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

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

[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 Engine

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

[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"?

[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 > > > > Chui > > - Original Message

[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

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

Re: [Zope] filename extension

2001-01-08 Thread Olaf Zanger
hi there, thanks for the answer, but ... [EMAIL PROTECTED] schrieb: > > Untested: > > > > Does it work? nope Error Type: Bad Request Error Value: ['id'] this (with the renamed file) works though: is there any documentation for these tricks? thanks olaf -- soli-con Engineering Zange

[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 than

[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

[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 love

[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

[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

[Zope] translator / zbabel

2001-01-05 Thread Olaf Zanger
hi there, i'm searching for a i18n product, on translator i seam to miss "xmlio". since there is no install.txt provided i wonder how i have to use the makefile? i got zbabel now working with mysql, but it seams to put any babel-taged area each view-time again in the database the construct i

Re: [ZOPE] ZBabel translation to Postgres

2001-01-05 Thread Olaf Zanger
hi Andrew and others, > I get errors: > when i first want to view a page with the > test > > pg.error > error value: error: attribute 'phrases_phrase_id_seq' not found i changed the column name of the id from "phrase_id" to "id" and get still the same error message as above. so i figured that

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 als

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 ( sel

[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" fie

Re: [Zope] ftp ZSQL Methods

2000-12-20 Thread Olaf Zanger
ering 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:

[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

[Zope] passing parameters in a call/in/with

2000-12-18 Thread Olaf Zanger
hi there, with the znolk product i get data by "select * ..." out of my database. some fields are id's and i would like to get data out of an other table basing on this id. how can i pass the id through a ? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Ol

[Zope] SQL Interface Builder?

2000-12-18 Thread Olaf Zanger
ance to use the ftp thing with a kio_slave programm from kde? so, has anybody a solution to offer. olaf p.s. i find zope great. -- 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

[Zope] default values in forms

2000-12-13 Thread Olaf Zanger
-- 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

[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

Re: [Zope] ZNavigator

2000-12-08 Thread Olaf Zanger
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,

Re: [Zope] ZNavigator

2000-12-08 Thread Olaf Zanger
fferences 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 ca

[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 Za

[Zope] FieldDocument

2000-12-07 Thread Olaf Zanger
ython 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:

[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

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

Re: [Zope] duplicate column name

2000-12-07 Thread Olaf Zanger
hat 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:[EMA

[Zope] duplicate column name

2000-12-07 Thread Olaf Zanger
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: +

Re: [Zope] next value

2000-12-07 Thread Olaf Zanger
wo 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: +4

[Zope] next value

2000-12-06 Thread Olaf Zanger
ssage 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-57

[Zope] authentication II

2000-11-30 Thread Olaf Zanger
o 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] mai

[Zope] authentication

2000-11-28 Thread Olaf Zanger
e 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: