- Zope - Zope lists

RE: [Zope] can't store a date in Access database
by Micah Martin 25 Oct '01

25 Oct '01

Whoops, this was a typo. The code is actually: insert into TableName (Date) values ("10/24/2001") I'm still looking for a solution to the problem. Micah From: "Capesius, Alan" <CapesiusA@S...> Date: Wed Oct 24, 2001 10:13 pm Subject: RE: [Zope] can't store a date in Access database "Insert into" or just "Insert" rather than "Insert in" >>>-----Original Message----- >>>From: Micah Martin [mailto:micah@o...] >>>Sent: Wednesday, October 24, 2001 4:47 PM >>>To: 'zope@z...' >>>Subject: [Zope] can't store a date in Access database >>> >>> >>>Hello, >>> >>> This is the error the is troubling me: >>> >>>Error Type: sql.error >>>Error Value: ('37000', -3502, '[Microsoft][ODBC Microsoft >>>Access Driver] >>>Syntax error in INSERT INTO statement.') >>> >>>My SQL statement: >>>insert in TableName (Date) values ("10/24/2001") >>> >>>I have tried at least a dozen different date formats >>>including the wierd '#' >>>delimiters. Anyone solve this problem? >>> >>> Micah >>> >>>------------------------------------------------------------- >>>--------------- >>>-- >>>Micah Martin >>>Software Engineer >>>Object Mentor, Inc. >>>micah@o... >>>www.objectmentor.com, www.xprogramming.com >>>www.pairprogramming.com, www.junit.org >>>

3 3

Re: [Zope-dev] login prompt after letting user change his passwor d.
by Behrens Matt - Grand Rapids 25 Oct '01

25 Oct '01

[Moving to zope(a)zope.org, like I guess I should have done in the first place] Clark OBrien wrote: > When you say "the client is still sending the username/password". I > don't use cookies > but, because I only use relative urls, Zope seems to maintain the same > security "context" thoughout the "session" (a relative url would be href > = "dir1\dir2"). I am looking for some way to refresh this security > "context" to use the new password. When you log in to a site that uses basic auth, which Zope does by default, each HTTP request from your browser comes with your username and password. It is totally separate from cookies (although cookies operate in much the same way.) Your browser will continue sending the same username and password until it is closed or gets an Unauthorized message from the site. Basically, Zope doesn't maintain that authentication. Your browser does. HTTP is designed that way. > It is really confusing for the login to pop up at this point- > particularly because > it looks like it is asking for permissions to change the password ( > needs OLD password) Unfortunately, that's the way it works. > -----Original Message----- > From: Behrens Matt - Grand Rapids [mailto:Matt.Behrens@Kohler.Com] > Sent: Thursday, October 25, 2001 10:09 AM > To: Clark OBrien > Cc: 'zope-dev(a)zope.org' > Subject: Re: [Zope-dev] login prompt after letting user change his > password. > > > Clark OBrien wrote: > > >>Hi all >>I have written some code to alow a user to change his password (below) >> >>The problem is that after executing this code the login dialog pops >> > up. > >>The login requires the user to enter his NEW password. >> > > > There is absolutely nothing wrong with that. > > > Basic authentication works by sending the username and password with > each request. You've changed the password on the server, but the client > > is still sending the old password, which doesn't authenticate them any > longer. > > The user'd have to do it sometime, why not right after their password is > > changed? > > BTW, the proper forum for this type of question is the main Zope mailing > > list, <zope(a)zope.org>. > > -- Matt Behrens <matt.behrens(a)kohler.com> System Analyst, Baker Furniture

1 0

CMF Question
by Scott Kuei 25 Oct '01

25 Oct '01

Hi there, Does anyone know how to use the addImage function of Image.py module in CMFDefault? I really need help on this one. Thank you. Scott,

1 0

Caching Question (short)
by Sidnei da Silva 25 Oct '01

25 Oct '01

It is possible to make a folder cacheable? -- Sidnei da Silva X3ng Consultoria e Desenvolvimento Ltda. sidnei(a)x3ng.com.br

2 1

Zope and MS Media Server Integration (Video)
by Harlow Pinson 25 Oct '01

25 Oct '01

Does anyone know how to call video on the Microsoft streaming media server from a Zope DTML document. I.E. in a document named video.dtml: <a href="mms://welcome.asf">Play video.</a> works just fine when viewed on the local Zope server machine, but when called from another machine returns this: http://<domain_name>/video_test/video.dtml/mms://welcome.asf Which does not work. Any suggestions? Thanks. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

2 1

Problem with nested Z SQL Methods
by Krone, Armin 25 Oct '01

25 Oct '01

I try to do two nested Database requests. In the outer lop there is selected all the merchants transactions and in the inner loop there shall be displayed the possible (0..n) Results. The TID shall be taken from from the outer loop. This fails with an syntax error. If I set in '<dtml-in expr="Database.sqlGetResults(tid='123')" >' instead it works (but the inner loop gets the wrong data - for shure). How can i nest this 2 Z SLQ Methods correct? <dtml-var standard_html_header> <h2><dtml-var title_or_id> <dtml-var document_title></h2> <p> <table border=1> <tr> <th>TID</th> <th>CURRENCY</th> <th>AMOUNT</th> <th>AMOUNTWITHOUTDECIMALS</th> <th>BASKET</th> <th>CARDNUMBER</th> <th>CARDEXPIRY</th> <th>USERID</th> <th>PAYMETHOD</th> <th>MERCHANTTID</th> <th>MERCHANTADDITIONALDATA</th> </tr> <dtml-in expr="Database.sqlGetTransactionMerchant(merchantid=_.SecurityGetUser().getU serName())" > <tr> <td><dtml-var TID></td> <td><dtml-var CURRENCY ></td> <td><dtml-var AMOUNT ></td> <td><dtml-var AMOUNTWITHOUTDECIMALS ></td> <td><dtml-var BASKET ></td> <td><dtml-var CARDNUMBER ></td> <td><dtml-var CARDEXPIRY ></td> <td><dtml-var USERID ></td> <td><dtml-var PAYMETHOD ></td> <td><dtml-var MERCHANTTID ></td> <td><dtml-var MERCHANTADDITIONALDATA ></td> </tr> <dtml-in expr="Database.sqlGetResults(tid=<dtml-var TID>)" > ########################################################### failes (...) </dtml-in> </dtml-in> </table> </p> <dtml-var standard_html_footer> regards Armin Krone

2 1

RE: [Zope] Zope Eats Memory
by sean.upton＠uniontrib.com 25 Oct '01

25 Oct '01

I have this same problem; on my 2 ZEO clients on a high-traffic, Catalog intensive site, running Debian as well, I had Zope chew through all my physical memory and most of my swap (up to between 1200-1300 MB), even to the point where the system kept my clustering software from sending a simple heartbeat over the systems serial port. Right now, I have a cron job to restart Zope daily... I think for a longer term fix, I am going to try to look into what Chris M. has suggested and read that howto... Sean -----Original Message----- From: Chris Gray [mailto:cpgray@library.uwaterloo.ca] Sent: Thursday, October 25, 2001 8:42 AM To: zope(a)zope.org Subject: [Zope] Zope Eats Memory I've been running Zope (with ZEO) on a Debian GNU/Linux box. Just today everything slowed to a crawl and it turned out that one python process was taking up 75% of system memory. Stopping and restarting Zope cured the problem. I'm doing some caching of DTML pages and MySQL queries. Any idea why Zope would start doing this? Are there any preventative measures? Thanks, Chris _______________________________________________ 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] access to parent
by sean.upton＠uniontrib.com 25 Oct '01

25 Oct '01

For some reason in TTW python scripts, context.PARENTS[1] seems to do the same as this... Sean -----Original Message----- From: Michel Vayssade [mailto:michel.vayssade@utc.fr] Sent: Thursday, October 25, 2001 5:11 AM To: zope(a)zope.org Subject: [Zope] access to parent Hi, in DTML you access to the parent object with PARENTS[0] for example <dtml-var PARENTS[0].id> What is the equivalent inside python code ? I guess the answer will be different if this python code is activated via the web interface OR if activated through the creation of new instance from another python code. -- _/ _/ _/_/_/ _/_/ Michel.Vayssade(a)UTC.fr Service Informatique _/ _/ _/ _/ T:33/0-3.44.23.49.24 Universite de Technologie _/ _/ _/ _/ F:33/0-3.44.23.46.77 BP 20.529 60205 Compiegne _/_/ _/ _/_/ _ mv(a)utc.fr __/www.utc.fr/~vayssade____ France _______________________________________________ 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

Fwd: Re: [Zope] ZODBCDA and W2k
by florian reiser 25 Oct '01

25 Oct '01

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi folks, the VFP ODBC driver doesn't require a user and a password. Remember the driver works with M$ Excel? My father told me that the driver works, if he configures him with free tables instead of giving him the database container. For the people that don't know of VFP, its a dbase like pc database. Greets Florian Am Dienstag, 23. Oktober 2001 23:51 schrieben Sie: > > I have seen the Zope adapter require a different form of connection > > string > > Its: DSN/user/pwd > > Cheers. - - -- - - ----------------------------------------------------------------------- | Florian Reiser PGP-Key:0x5368CF3F | | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | - - ----------------------------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE72DY8BdtuEVNozz8RArZEAJ9l40DhBkSEQCmx9StOMUkiah1KSQCeJwEk KjMz8NJp9DzVHk4kRIroTjY= =KUsL -----END PGP SIGNATURE-----

1 0

PDF from external method
by Juergen R. Plasser / HEXAGON 25 Oct '01

25 Oct '01

Hi, how can I pass a pdf generated by an external method (using Reportlab) back to Zope? Has anybody done this with Reportlab before? I am new to Python, Zope and Reportlab and I wanted to try one of those demo scripts coming with the Reportlab Installation. I think it is a Python problem, what do I have to do in the Python script to return the PDF file handle? -- Juergen Plasser plasser(a)hexagon.at

8 10