- Zope - Zope lists

Re: [Zope] ZPyGresDA
by Bak ＠ kedai 07 Mar '01

07 Mar '01

try looking at zope.org/Products/all_products failing which, try PoPy/ZPoPyDA or pycopg poPy is actively maintained. pycopg is the new da on the block -----Original Message----- From: HENRY Katell <Katell.HENRY(a)enst-bretagne.fr> To: zope(a)zope.org <zope(a)zope.org> Date: Wednesday, March 07, 2001 7:04 PM Subject: [Zope] ZPyGresDA >Hi, I would like to know if someone knows the web site from which I could >download the ZPyGresDA ??? > >Thanks > >Katell > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://lists.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: [Zope] Getting client browser type
by Etienne Labuschagne 07 Mar '01

07 Mar '01

Unfortunately I need to have some JavaScrapt (intentional sp) in my website. Just about every browser have it's own implementation of this language so one ends up writing a script for every browser (YUK!). I don't want to check this in JavaScript and use ifs to decide what code to use as a lot of code is then downloaded to the client that his browser never use. My idea is to have scripts for every browser (where they differ) and just send the correct script to the client. So, the decision which script to send must be made by Zope. I can use JavaScript itself to check what the browser is, but when I know, how do I tell Zope that? Unfortunately I cannot do without JavaScript. Regards Etienne -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Tuesday, March 06, 2001 6:17 PM To: Etienne Labuschagne Cc: Zope user list (E-mail) Subject: Re: [Zope] Getting client browser type Hi Etienne, Etienne Labuschagne wrote: > > Hi there > > I have thought of that, but doesn't those change with every new release of a > specific browser? I guess one will just have to keep up to date with the > browser type strings for every new browser launched :( > > Thanks anyway > Etienne For statistical reasons it is good enough ;) But dont always believe what you 're getting :-) The question is - what are you about to do with the data? Please dont this information for such sites that tell you: "Go away and get this ... specific browser!" Did you ask why almost all browsers nowadays call themself "Mozilla" ? ;) Regards Tino

1 0

Test
by BZ 07 Mar '01

07 Mar '01

test

1 0

Add a Document from an existing File
by Steffen Bergmann 07 Mar '01

07 Mar '01

Does anybody know how to add an DTML Document with uploading the contents from a local File on the filesystem. I need to do this in DTML Code (or Python?) and not in the managementscreen. The Code: <dtml-call "manage_addDTMLDocument('id','title','datei.html')"> only adds a Document with the contents 'datei.html'. Is there any other option to do something like this? Steffen

2 1

<dtml-in item> iteration on INSERT method
by Paz 07 Mar '01

07 Mar '01

Hi all, I've used the <dtml-in item> iteration many times with dbms tables and ZSQL methods, but always in context of an UPDATE table SET where clause. This works because the iteration is selective to a certain value that is set from the html page at POST or the form. What I WANT to do now is INSERT into table using the same item construction, when a checkbox in a multiple record form is checked. I can see in the REQUEST.form that only certain values are present, but I cannot be selective of this in the ZSQL method to add the records. Here is what I have for the ZSQL method: <dtml-in item> insert into lpref (uid, linkid, hiearchy) values ( <dtml-sqlvar uid type=string>, <dtml-sqlvar linkid type=int>, 0 ) <dtml-var sql_delimiter> </dtml-in> What happens is that ALL items on the form go into the DB because the item construction does not care if the checkbox is checked or not. What I'd like is a WHERE clause tacked to the end, but this doesnt seem to work. Dont think and INSERT INTO table WHERE is valid.... but will have to dig the MySQL refs. Another thing I could do is query the checkbox value inside the iteration, but it doesnt work because I think that Item wraps itself in a way that I cant address it properly. Such as: <dtml-in item> <dtml-if "favLink"> insert into lpref (uid, linkid, hiearchy) values ( <dtml-sqlvar uid type=string>, <dtml-sqlvar linkid type=int>, 0 ) </dtml-if> <dtml-var sql_delimiter> </dtml-in> But I get an attribute error.... Can anyone offer me a suggestion? Thanks as always, Paz

1 0

SQLTEST is case insensitive?
by The Doctor What 07 Mar '01

07 Mar '01

I have the following ZSQL method: SELECT "URL"."ID", "val_Protocol"."Protocol", "URL", "URL"."Name", "URL"."Description", "URL"."Created" FROM "URL", "val_Protocol" <dtml-sqlgroup where> <dtml-sqltest ID type=int optional> <dtml-and> "val_Protocol"."ID" = "URL"."val_ProtocolID" </dtml-sqlgroup> When I set ID equal to 1 (to test) I get this back: Error, psycopg.ProgrammingError: ERROR: Attribute 'id' not found SELECT "URL"."ID", "val_Protocol"."Protocol", "URL", "URL"."Name", "URL"."Description", "URL"."Created" FROM "URL", "val_Protocol" where (ID = 1 and "val_Protocol"."ID" = "URL"."val_ProtocolID" ) The problem is two fold: 1) ID = 1 should be "ID" = 1 so that PostgreSQL will treat it as a case sensitive string. 2) ID = 1 should really be "URL"."ID", but I can't figure out how to pass that through sqltest! Any help is appreciated.... I have tried this with a zpopyda and zope-psycopgda, neither worked. And, no, using 'as' to rename the select to lowercase _does not_ work. Ciao! -- "Clothes make the man. Naked people have little or no influence on society." -- Mark Twain The Doctor What: Not that 'who' guy http://docwhat.gerf.org/ docwhat(a)gerf.org KF6VNC

1 0

LoginManager & Cookie Login
by Gerald Gutierrez 07 Mar '01

07 Mar '01

I noticed that the LoginManager supports Basic Auth Login, Basic Cookie Login and REMOTE_USER login by default. Does that mean that if I don't use cookies, and I want a form-based login, LoginManager will not work for me?

1 0

Re: [Zope] parsing dtml from sql-method
by Dieter Maurer 07 Mar '01

07 Mar '01

Ralf Kraemer writes: > i would like to put some dtml code into my database > and let it be parsed by zope by a query. > > it works fine with html, but with dtml it fails > > actual i have some > > <dtml-in get_item(item_id)> > <dtml-var item> > </dtml-in> > > can anybody help me ??? It will not work in DTML, but in an external Python Method: you take your DTML string (stored in the database) and create a document template object from it. You then render (call) this object. For how, you do all that, you should look at the "DocumentTemplate" package in your Zope distribution. Most relevant "DT_String.py" and "DT_HTML.py". Dieter

2 1

How to get the url without the domain part, using <dtml-in>?
by Ausum 07 Mar '01

07 Mar '01

Is it possible to return the absolute url without the domain/IP part, while in an iteration? With absolute_url I get this: http://100.0.0.1/folder0/folder1/folder2/current_object , and instead I'd like to have this: /folder0/folder1/folder2/current_object I tried the BASEPATH special variable, but it seems that it doesn't work within <dtml-in>. The other downside is that it needs an argument to get to know the nesting level of the object. Has anyone found a workaround? Thanks in advance, Ausum

3 4

Correction: OpenFlow works under 2.3.0
by Paolo Bizzarri 07 Mar '01

07 Mar '01

Hi everyone, I have verifyend that OpenFlow works correctly under 2.3.0. I simply had not installed the Extensions required. Sorry for the inconvenience. Ciao Paolo -- Paolo Bizzarri Icube S.r.l.

1 0