May 2000 - Zope - Zope lists

Re: [Zope] Newbie: MS Access ODBC connection strings
by Rik Hoekstra 18 May '00

18 May '00

-----Original Message----- From: Andy Gates <Andy.Gates(a)bristol.ac.uk> To: zope(a)zope.org <zope(a)zope.org> Date: donderdag 18 mei 2000 11:24 Subject: [Zope] Newbie: MS Access ODBC connection strings >Before you all start, I know, MS Access is pants and I should be using >a "real" database. And I shall, once the "proof of concept" stage is >passed and I can migrate the existing data over to one. But for now >I'm stuck with it. > >Right, that over, here's my plea: I'm trying to create a connection >object to a MS Access 97 database. I've installed the ODBC DA product >but I cannot get my connection to actually connect. The error I get is, >"invalid connection string: project," (project is the DSN name). > >According to the docs that come with the ODBC-DA, there's usually no >need for a connection string and accordingly I have left it blank; I >presume that the DA is defaulting to connecting using the DSN name as >its string. The database has no security settings that might limit >access. > >What's going wrong? Help! Hm, a few possibilities I haven't seen yet: - You don't happen to have spaces in the Access file name? This may upset one object or another. - There isn't an Access workgroup type of authentication going on (just checking) Rik

1 0

Newbie: MS Access ODBC connection strings
by Andy Gates 18 May '00

18 May '00

Before you all start, I know, MS Access is pants and I should be using a "real" database. And I shall, once the "proof of concept" stage is passed and I can migrate the existing data over to one. But for now I'm stuck with it. Right, that over, here's my plea: I'm trying to create a connection object to a MS Access 97 database. I've installed the ODBC DA product but I cannot get my connection to actually connect. The error I get is, "invalid connection string: project," (project is the DSN name). According to the docs that come with the ODBC-DA, there's usually no need for a connection string and accordingly I have left it blank; I presume that the DA is defaulting to connecting using the DSN name as its string. The database has no security settings that might limit access. What's going wrong? Help! ---------------------- Andy Gates, Learning and Research Technology Andy.Gates(a)bristol.ac.uk - ICQ#74362415

2 2

Zope Product tools.
by Jerry Spicklemire 18 May '00

18 May '00

Bryan Patrick Coleman asked: >I was wondering if there were any products for the following Genre's >configuration managment, Project managment, bug tracking, cvs browsing.... >etc for Code / Bug Tracking check out : http://www.zope.org/Members/klm/TrackerWiki/FrontPage http://www.zope.org/Members/shalabh/iTrack for Project Management : http://bits.netizen.com.au/Xen/ http://sourceforge.net/project/?group_id=2370 >Basically anything that would help with Development and testing. >For that matter it would be cool to see what kind of application type >products are available for Zope use. Not limited to Zope, but Python related, check out: http://www.software-carpentry.com Later, Jerry S.

1 0

RE: [Zope] listmate + CSV problem
by michael angelo ruberto 18 May '00

18 May '00

hi, Heiko it works! i had to replace all whitespaces in column names with under_scores. it's the whitespace that created a problem. now i have to enter "NULL" in all the empty cells to make the table line up properly -( but this is not your fault, it's mine. i think many people in my company are going to be happy now! thank you for all the help you have provided. -<mike>- -----Original Message----- From: stoermer(a)innominate.de [mailto:stoermer@innominate.de]On Behalf Of Heiko Stoermer Sent: Thursday, May 18, 2000 3:46 AM To: michael angelo ruberto Subject: Re: [Zope] listmate + CSV problem michael angelo ruberto wrote: > Error Type: Bad Request > Error Value: Invalid or duplicate property id > > yes, I see. the first line of the csv will be split up into words and for each word a table column is created. these column names are actually properties of some internal object, so they MUST be unique. So if you have the same word appear twice in the first line of the file, you will get this error. the file size or column number should not be a problem. duplicate column names are. hope this helps, Heiko -- heiko.stoermer(a)innominate.de innominate AG networkingpeople fon: +49.30.308806-0 fax: -77 web: http://innominate.de

1 0

FW: [Zope] Zope and PHP
by peter 18 May '00

18 May '00

-----Original Message----- From: peter [mailto:peter@grenna.net] Sent: 18 May 2000 17:59 To: 'Chris Herrnberger' Subject: RE: [Zope] Zope and PHP Sure thing. But "being compatible" is maybe not the right word. http://www.zope.org/Members/Mamey/PHP "As you migrate your site to Zope, you may want to embed a previously created PHP or Perl directory tree within Zope. Or perhaps you found a nifty web application that is coded in PHP/Perl and want to serve it within your Zope site. " "You'll also need a web server that can serve Zope as well as the PHP/Perl tree. We use Apache, and that is what this How-To will use as an example. " -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Chris Herrnberger Sent: 18 May 2000 17:14 To: zope Subject: [Zope] Zope and PHP Greetings, In discussions with friends the question came up is zope compatible with php, specifically if zope is run through apache. best 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

ZSQL-Methods: last inserted id
by Andy 18 May '00

18 May '00

I wonder how I can find out about the last inserted id of a row in my mysql-database, which I inserted through a ZSQL-Method... I tried mysql's built-in function LAST_INSERT_ID(), but that did not solve my problem...

4 3

looking for ID after manage_addFile
by Didier Georgieff 18 May '00

18 May '00

Hello, I'm uploading some files thru a form and i want to setup some new properties just after the upload (who done the upload and so...) So i have a DTML method (addProperty) who does the manage_addProperties and i want to simply call ..../.../ID/addProperty for that. I also need to know the ID in order to check.if a previous version for this document was already upload Problem is i don't give any ID to the file uploaded since with and empty ID in manage_addFile, the file name is automatically setup as ID. <dtml-call expr="manage_addFile (' ',REQUEST['myFileBin'],REQUEST['myTitle'])"> I guess it's an obvious trick but i can't find a way to get and manipulate the ID for cheking existing file and calling addProperty. and i dind't find info thru the documentation. As a workaround I can put a forged ID but file name seems better for my needs. Thanks for any tip. Didier Georgieff

1 0

ZWiki RecentChanges problem with 2.1.6
by Chris Withers 18 May '00

18 May '00

Hi, The RecentChanges page in ZWiki no longer works in 2.1.6 The following code: <dtml-in "aq_parent.objectValues(spec='ZWiki Page')" sort=bobobase_modification_time reverse> Spits authorization errors even when I'm logged in as root. Anyone got any ideas? cheers, Chris PS: Traceback (innermost last): File /usr/local/zope/internal/2-1-6/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/zope/internal/2-1-6/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zope/internal/2-1-6/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/zope/internal/2-1-6/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/Products/ZWiki/ZWikiPage.py, line 178, in __call__ (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/Products/ZWiki/ZWikiPage.py, line 223, in render_htmldtml (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: RecentChanges) File /usr/local/zope/internal/2-1-6/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: aq_parent.objectValues(spec='ZWiki Page')) File /usr/local/zope/internal/2-1-6/lib/python/DocumentTemplate/DT_Util.py, line 329, in eval (Object: aq_parent.objectValues(spec='ZWiki Page')) (Info: aq_parent) File /usr/local/zope/internal/2-1-6/lib/python/Products/ZWiki/ZWikiPage.py, line 501, in validate (Object: RecentChanges) Unauthorized: (see above)

1 1

Zope Product tools.
by Coleman, Bryan 18 May '00

18 May '00

I was wondering if there were any products for the following Genre's configuration managment, Project managment, bug tracking, cvs browsing.... etc Basically anything that would help with Development and testing. For that matter it would be cool to see what kind of application type products are available for Zope use. - Bryan Patrick Coleman Questcon Technologies (336)273-2428 bcoleman(a)questcon.com

1 0

RE: [Zope] Cache
by Mabe, Brad 18 May '00

18 May '00

Does this work in IE5? I'm using similar META tags which work for IE4 and Netscape but don't work in IE5. -=Brad=- -----Original Message----- From: Dr. Peer Griebel [mailto:peer@knoll-is.de] Sent: Thursday, May 18, 2000 10:32 AM To: zope(a)zope.org Subject: Re: [Zope] Cache Jonothan Farr wrote: > > > How can I disable the browser cache in my zope documents ? > > One thing you can do is set the 'Expires' header like so: > > <dtml-call "RESPONSE.setHeader('Expires', _.DateTime().rfc822())"> This works using Netscape. But for IE I had to use: <dtml-call "RESPONSE.setHeader('Expires', '-1')"> <dtml-call "RESPONSE.setHeader('Cache-Control', 'no-cache')"> <dtml-call "RESPONSE.setHeader('Pragma', 'no-cache')"> I think the last Pragma can be left out. But the Cache-Control header ist neccessary. I got the information out of rfc2616. -- connection reset by Peer _______________________________________________________________________ Dr. Peer Griebel Tel. +49 7581 4831 23 Geschäftsführer Fax. +49 7581 4831 11 Knoll Informationssysteme GmbH http://www.knoll-is.de Dreiköniggasse 17 mailto:peer@knoll-is.de 88348 Saulgau privat: mailto:peer.griebel@gmx.de _______________________________________________ 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