- Zope - Zope lists

Limits on text posting
by Carlos A. Carnero Delgado 18 May '00

18 May '00

Hello again, zopistas! Actually, this is not directly related to Zope, but I just wanted to know. I have a simple form with a textarea, exactly, how much text fits in a text area? I mean, is there an upper limit to the number of characters the end user can type in the textarea? -- [ c a r l o s c a r n e r o ] [ r t v c o m e r c i a l ] [ t e x e l @ r t v c . c o m . c u ]

1 0

ZODBC connection & start method
by Stephen Nosal 18 May '00

18 May '00

Folks - I'm now finding some interesting behavior with the ZODBC connection. I set up a connection and had no problems with it (requires DSN id password). I went back to it at a later point in time and it no longer worked. What changed? I'm running ZOPE 2.1.6 on NT4 sp4. I started out running ZOPE from the start.bat file. type start.bat "c:\zope\ZopeDIR\bin\python.exe" "c:\zope\ZopeDIR\z2.py" -D -w 80 -a 127.0.0.1 If I start ZOPE from the start.bat file, the ODBC connection works flawlessly (with my minor testing) If I start ZOPE as a service (HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ZopeDIR\Parameters = "c:\zope\ZopeDIR\bin\python.exe" "c:\zope\ZopeDIR\z2.py" -S -D -w 80 -a 127.0.0.1) and then attempt to open the ODBC connection, I receive the following error Invalid connection string: DSN id password (changed for obvious reasons) Traceback (innermost last): File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 214, in publish_module File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 179, in publish File c:\zope\ZopeDIR\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: RoleManager) File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 165, in publish File c:\zope\ZopeDIR\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_open_connection) File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_open_connection) File c:\zope\ZopeDIR\lib\python\Shared\DC\ZRDB\Connection.py, line 209, in manage_open_connection (Object: RoleManager) File c:\zope\ZopeDIR\lib\python\Shared\DC\ZRDB\Connection.py, line 227, in connect (Object: RoleManager) File c:\zope\ZopeDIR\lib\python\Products\ZODBCDA\db.py, line 155, in __init__ BadRequest: (see above) Has anyone experienced this before? Any thoughts? I much prefer running Zope as a service, but... TIA. - Steve __________________________________________________________________ Get your Private, Anti-Spam, Free Email at http://e3mil.com and Step into a Friendly Universe!

1 0

Re: [Zope] Has anyone...?
by Rik Hoekstra 18 May '00

18 May '00

>...run multiple instances of Zope on an NT machine? >I guess I should ask first if anyone has been successful getting thier NT >Web Server to handle authentication/authorization to zope users via pcgi? yes. I don't see what the problem (in a theoretical sense) should be. > >I'm not running IIS but I imagine the problems are similar. We had it running before, without trouble behind IIS using pcgi. I changed jobs in between and recently there seem to have been problems with the NT box, though (from what I've heard I doubt if they're Zope related, though) > I'm using >Oreilly's Website Pro and have asked about this here before. I know nothing about this. >I want users to be able to log on to thier zope projects or zope products. A >manager should be able to get to the management area and say, a squishdot >admin should be able to review articles and any portal member should be able >to log-in via the front end server...... I seem to be finding just enough >info to keep me trying.....but no successes. > >I would appreciate hearing any NT server solution(s) to this. I'm stuck... Could you be more specific as to where are things going wrong? > >Thanks for any help on this... > hth Rik

1 0

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