[Zope] authentication

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

[Zope] authentication II

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

[Zope] next value

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

Re: [Zope] next value

2000-12-07 Thread Olaf Zanger
('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

[Zope] duplicate column name

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

Re: [Zope] duplicate column name

2000-12-07 Thread Olaf Zanger
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] htt

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

[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

[Zope] FieldDocument

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

[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

Re: [Zope] ZNavigator

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

Re: [Zope] ZNavigator

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

[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

[Zope] default values in forms

2000-12-13 Thread Olaf Zanger
k, 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.c

[Zope] SQL Interface Builder?

2000-12-18 Thread Olaf Zanger
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 PROTECTED] mai

[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 dtml-call/in/with method? olaf -- soli-con Engineering Zanger Dipl.-Ing.

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

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 (

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

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 dtml-babel src=uk dst=de test/dtml-babel 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

[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

[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

[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

[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

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

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:

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,

[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

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

[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

[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

[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

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

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

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

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 with

[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

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

[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

[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