January 2000 - Zope - Zope lists

Dbase error
by Denny Valliant 10 Jan '00

10 Jan '00

Hola everyone! I have been having a problem with my zope database ever since I converted it from the old zope to the new one. The problem that I keep having is: When I am in the management area of zope, and it shows me the list of folders, methods, etc. that are in my zope database, a funny thing keeps happening. About 3 folders deep, there is a folder, that when I click on it, instead of showing me the contents of the folder, it loads up the standard header that is _inside_ the folder. I say: "what the heck?!?!" I've tried exporting from the old db, importing into the new db, with on luck. I've tried renaming the subfolder... no luck. I've tried logging in as different users... no luck. I've tried some really weird stuff that I was just hoping would work, no luck. For the life of me I can't figure out what is going on. I click on the subfolder, and it gives me a web page instead of an index of what's actually _in_ the folder. Under the old version of zope, it works fine. The problem only started when I implemented the new ver. In short; People are yelling at me, and I haven't a clue as to how to fix this. If ANYONE has seen this before... PleAsE HElP!!! Yall have been a great help in the past... I'm hoping yall can be a great help to me now too! If people keep helping me, maybe someday I will know enough to actually be able to help others, ya know? Thanks, even if no one knows the answer. I have to get this working, so with or without help, I will, but I would REALLY appreciate the help. Gracias, Denny V.

2 1

ZODBC and MSSQL: "Invalid cursor state" bug
by Alexander Staubo 10 Jan '00

10 Jan '00

Not being an expert on ODBC, I'm at a loss dealing with this bug. Using ZODBC 3.1.0b2 (MSSQL 6.5, NT 4.0 SP4), multiple queries -- especially combining calls to select-type SQL methods with inserts/delete-type methods -- eventually prompt the following error: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid cursor state') Example traceback: File c:\zope\lib\python\ZPublisher\Publish.py, line 214, in publish_module File c:\zope\lib\python\ZPublisher\Publish.py, line 179, in publish File c:\zope\lib\python\Zope\__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File c:\zope\lib\python\ZPublisher\Publish.py, line 165, in publish [...] File c:\zope\lib\python\Shared\DC\ZRDB\DA.py, line 401, in __call__ (Object: DeleteFilters) File c:\zope\lib\python\Products\ZODBCDA\db.py, line 199, in query sql.error: (see above) I can easily reproduce this error, but only in my real-world apps. It occurs *very easily*. The only workaround that I know is to combine the operations into to fewer SQL methods -- design hell. -- Alexander Staubo http://www.mop.no/~alex/ The difference between theory and practice is that, in theory, there is no difference between theory and practice.

1 0

Anyone using Zope Mail Host with MS Exchange ?
by chas 10 Jan '00

10 Jan '00

I have a client reporting that mail sent from Zope using a MS Exchange box as their Zope Mail Host never arrives. The forms themselves are known not to be at fault since we have previously tested them using a Zope Mail Host defined on a unix box (running QMail). I can test the forms from remote as an end user and they seem to submit properly - so the mail host is accepting the messages - but they never arrive anywhere (not even in their postmaster a/c) Since they are doing this from behind a firewall and refuse to open it for ssh access, I thought I'd first check if this is a known issue before I take a flight there to sort it out. Thanks in advance, chas

1 0

Adding another base class to an existing ZClass
by Steve Jibson 10 Jan '00

10 Jan '00

I've spent many hours working on a ZClass (with multiple sub-zclasses, etc.), and now I've decided that I should have inherited from Folder as well as ObjectManager when I created the ZClass. Is there a way to add a base class to the base class list of an existing ZClass, or do I need to start all over? Thanks, Steve

5 7

nested dtml-in
by cesare＠planningsrl.it 10 Jan '00

10 Jan '00

Hi all! I have two sql-method (Master, Detail) I would like to do something like this: Group Code Description <dtml-in Master> <dtml-in "second(MasterCode='<dtml-sqlvar Master.Code>' type=String )"> <dtml-sqlvar Master.Code> <dtml-sqlvar Detail.Code> <dtml-sqlvar Detail.Description> </dtml-in> </dtml-in> How can I do it? TIA, Cesare Cesare Raoss Planning srl Via Bolzano 45 38014 Gardolo (TN) cesare(a)planningsrl.it http://www.planningsrl.it

2 1

Re: Re: User Authentication
by Andrey V Khavryutchenko 10 Jan '00

10 Jan '00

Hi, Stuart! >>>>> "SB" == Stuart 'Zen' Bishop writes: SB> On 9 Jan 2000, Andrey V Khavryutchenko wrote: >> The later is great (and is what I'm using now), but ought to have better >> debugging facilities (hey, zen! ;) SB> Thats why I also wrote the Logger product :-) Aha, I see. But it hardly could help me in debugging my GenericUserFolder setup, which I've made first time :) -- SY, Andrey V Khavryutchenko http://www.kbi.kiev.ua/~akhavr Software & SPI Engineer Visit my site Shick's Law: There is no problem a good miracle can't solve.

1 0

RE: [Zope] How can you insert strings with newlines into SQL data base?
by Michel Pelletier 10 Jan '00

10 Jan '00

Post the patch to the collector it will get done... -Michel > -----Original Message----- > From: Anthony Baxter [mailto:anthony@interlink.com.au] > Sent: Monday, January 10, 2000 7:47 AM > Cc: itamars(a)ibm.net; zope(a)zope.org > Subject: Re: [Zope] How can you insert strings with newlines into SQL > database? > > > >>> Anthony Baxter wrote > > Aaron Watters posted a patch for gadfly to fix this - you might > > want to check either the Zope list archives or the gadfly list > > archive (at egroups.com) It should probably be applied to the > > version that's in the Zope CVS.... > > Ok, I found it: > > > Anthony Baxter has mentioned a number of times that > > gadfly barfs on strings with embedded newlines. There is a > > one line patch to this. In sqlgen.py replace > > > > charstre = "'[^\n']*'" > > > > with > > > > charstre = "'[^']*'" > > > > Sorry! -- Aaron Watters > > (this would be a nice patch to apply to the CVS tree :) > Anthony > > _______________________________________________ > 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

Select List
by Oai Luong 10 Jan '00

10 Jan '00

I have a table that lists all the tables that are in my database: tables _______ gistools gisexperts inforesources vendors I want to be able to put this in a selected options list box using the queries returned by the sql method. My sql method is called tables. Can someone tell me how this can be done? thanks

2 1

Forms
by Scott Tran 10 Jan '00

10 Jan '00

I've set up a form that calls a dtml method to input the form data into a database table, then it calls another dtml method to take the form data and sends via e-mail. I'm having problems with referencing the form data in my method that sends the e-mail. Any suggestions? Thanks. Scott

2 1

Zope and Data Entry
by darryl＠igor.penguinpowered.com 10 Jan '00

10 Jan '00

I am designing a site which will be used for a lot of data entry. I have zope 2.1.2 and mysql talking nicely. Now my problem is design. I want the user to be able to fill in a form using some HTML select fields, these fields should then be translated into their respective item IDs for input into my table. So even though the user chooses: cat dog mouse the sql final method should be: insert into table animals (cID, dID, mID) values (12, 14, 18) In a CGI, I would use a python dictionary or perl hash to translate the keys into their values before makeing. But I'm a little stumped with zope? Should I handle this with an external method or can I do it with straight sql methods and built-ins?

5 4