January 2001 - Zope - Zope lists

Dynamic ordering of DTML-IN?
by Andy Gates 23 Jan '01

23 Jan '01

Another one from the "my brain don't work" side of the tracks: I have a staff list that I want to be orderable by first or last name. So I have buttons for each that link thus: <a href="staff?orderby=firstname"> etc The idea is that that feeds over to the DTML-IN tag thus: <dtml-in "sql_search(search='foo')" sort=orderby> But this barfs, because it's expecting a field name "orderby" and there isn't one. How do I evaluate that? ---------------------- Andy Gates, Learning and Research Technology Andy.Gates(a)bristol.ac.uk - ICQ#74362415 http://www.ilrt.bristol.ac.uk

4 4

EMail with uploaded attachments
by Klaus Herrmann 23 Jan '01

23 Jan '01

Hi Folks! I have another problem: I wrote a nice web interface for email feedback etc., but i want to add an option for attaching files to the emails. how can i do this? i can't get it to work. i have this: <form action="send_email" method=post enctype="multipart/form-data"> .. <input type=file size=18 maxlength=3000000 name="attached_file"> </form> and in send_email: <dtml-sendmail mailhost=fox> To: ... From: ... Subject: ... <dtml-mime type=text/plain encode=7bit> plain text.... <dtml-boundary type=application/octet-stream disposition=attachment encode=base64> <dtml-var attached_file></dtml-mime> </dtml-sendmail> but the only result is that the attachments contains: <ZPublisher.HTTPRequest.FileUpload instance at 88b4df0> what am i doing wrong? thanks in advance! bye, Klaus -- Klaus Herrmann <klaus.herrmann(a)goelz.com> Goelz & Schwarz GmbH, Munich www.goelz.com phone:+49 - (0)89 - 544 67 0 22 fax: +49 - (0)89 - 544 67 0 10

2 1

RE: [Zope] Opensource DBMS for WIN?
by Farrell, Troy 23 Jan '01

23 Jan '01

PostgreSQL compiles on Win32, but only under RedHat's(formerly Cygnus') Cygwin Unix Compatibility Layer. http://www.postgresql.org http://people.freebsd.org/~kevlo/postgres/portNT.html MySQL, the newly GPL'd version, was declared stable yesterday. http://www.mysql.com SapDB is to be open-sourced soon. http://www.sapdb.org Troy -----Original Message----- From: Petru Paler [mailto:ppetru@ppetru.net] Sent: Tuesday, January 23, 2001 6:48 AM To: Paul Zwarts Cc: zope(a)zope.org Subject: Re: [Zope] Opensource DBMS for WIN? On Tue, Jan 23, 2001 at 10:35:11AM +0100, Paul Zwarts wrote: > Was wondering if there was an open source dbms to use with Zope on a > Win2k machine...? I found references of using cygwin to run PGSQL (which > we have on our unixbox) but would prefer something that doesnt run over > an extender-shell... I don't think I get what you mean by "extender shell". As far as I know (never used it though), PostgreSQL works on win32. I'd ask on the postgres lists first, though. -- Petru Paler, mailto:ppetru@ppetru.net http://www.ppetru.net - ICQ: 41817235 _______________________________________________ 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 )

2 1

Re: [Zope] Dynamic ordering of DTML-IN?
by Oliver Bleutgen 23 Jan '01

23 Jan '01

> Then change your Z SQL Method to look like; > select * from Customers where > foofield=<dtml-sqlvar search type=string> > <dtml-if orderby> > ORDER BY <dtml-var orderby> > </dtml-if> Hmm, I wouldn't do that, you're trusting the client here, imagine someone going to http://yourserver/staff?orderby=firstname%20;%20delete from Customers; (sufficient dbuser rights assumed) I would use staff?order_id=1 (2,3,...) etc. and then set orderby via a dictionary (or some simple dtml-ifs). cheers, oliver

2 1

Getting an object from it's id
by Gale 23 Jan '01

23 Jan '01

Hi, This is obviously a newbie question. I have several places in my dtml code where in order to obtain an object I loop through objects of that kind and make a test to determine if each objects id matches the id I picked up from a form. This is the only way I could get it to work; but I feel there must be a better, more efficient way. Here is an example: <dtml-in expr="objectValues('Folder')"> <dtml-if "myId==id"> Once I get a match I then proceed to use it in subsequent code, such as a <dtml with id> and it works since id now refers to the object I'm interested in. Is there a Zope API method that will allow me to get an object from it's id, or can I write a simple Python method to do it, or am I missing something even more obvious? Thanks Geoff Armstrong

8 10

Re: Trivial challenge ?
by Olivier Deckmyn 23 Jan '01

23 Jan '01

I got it : <dtml-with "mydoc"> <dtml-var render> </dtml-with> rather than : <dtml-with mydoc> <dtml-var render> </dtml-with> after all, this is quite logical ;) ps : The idea came to me after playing with : <dtml-var "mydoc.title_or_id()"> ----- Original Message ----- From: "Olivier Deckmyn" <odeckmyn.list(a)teaser.fr> To: <zope(a)zope.org> Sent: Tuesday, January 23, 2001 2:24 PM Subject: Trivial challenge ? > Hi all, > > I have a problem that looks simple (if not trivial) : I would like to > "render" a DTML Document using a DTML Method. > > The DTMLDoc is "mydoc", has a title (="My Document") and a content (="I am > the doc content") > > The DTMLMethod is "render" and its code is : > """ > I am rendering the <dtml-var title_or_id> page ! > """ > > And, at last, I have a index_html like this : > > """ > <dtml-with mydoc> > <dtml-var render> > </dtml-with> > """ > (All the items are in the same folder , whose id=test and no title) > > When viewing http://localhost:8080/test/ the result I expect is : > > I am rendering the My Document page ! > > OK ? > > But I got : > > I am rendering the test page ! > > THE <DTML-WITH> DID NOTHING !!!!!! > > What makes me become crasy is that http://localhost:8080/test/mydoc/render > works as expected !!! : > I am rendering the My Document page ! > > Can anyone explain me this ? > > And by the way give a solution to my problem ??? Of course I cannot use the > http://localhost:8080/test/mydoc/render notation. > > Thanx for reading that far. > > Olivier. > >

1 0

RE: [Zope] Getting an object from it's id
by Max Møller Rasmussen 23 Jan '01

23 Jan '01

From: Geoff Armstrong [mailto:geofstro@monaco.mc] >In DTML there doesn't seem to be a way of saying, "I have this string with >the name of an object, now fetch me the object." Shure there is: <dtml-var "some_container_object[remote_id].title"> As far as I remember. regards Max M A snippet I use somewhere: <dtml-in "emner[_['sequence-item']].objectValues('maal')"> <dtml-var title><br> <dtml-var description><br><br> </dtml-in>

2 1

Re: [Zope] Zope, database field formats, output format of queries
by Dieter Maurer 23 Jan '01

23 Jan '01

Michael Schmidt writes: > Can you create fields in a zope based database where you force > the fields to accept e.g. only letters "M" or "W" or any other > other combination of your choice? What do you mean with a Zope based database? If you mean an external database, look for the datatypes and restrictions, they support for column values. SQL 3 may give you some of what you want. Whether internal or external, you can control what goes through Zope to your database. You will probably need External Methods to get the full Python power, see "python.org" for documentation about Pythons vast library. You will be especially interested in the "re" module. It implements (Perl style) regular expressions. Dieter

2 1

Getting access to python methods of some product
by Ivan Somov 23 Jan '01

23 Jan '01

How I can use method, stored in a ".py" file of some product, and send some parameters to that method? I want to create an instance of ExtImage product programmatically, but have a troubles doing it..

2 1

exchanging ids in a single transaction
by Jerome Alet 23 Jan '01

23 Jan '01

Hi, I'm currently thinking about a project in which I'd want to be able to exchange 2 objects ids. My plan is to save the first one's id then rename the first one with the second's id then rename the second with the first's id which is very classical. I've got no code yet, but I want to know if there's a method to do all this in a single transaction: if any error occur then I don't want any id to be changed Is it possible and How ? Should I use the UNDO machinery to do that or is it possible with another way ? When I rename an object will my Data.fs grow (some objects may be 5 MBytes large, but rarely) ? Any tip will be appreciated. Jerome Alet - alet(a)unice.fr - http://cortex.unice.fr/~jerome Fac de Medecine de Nice http://wwwmed.unice.fr Tel: (+33) 4 93 37 76 30 Fax: (+33) 4 93 53 15 15 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

1 0