- Zope - Zope lists

ODBC + Linux
by ratem＠censanet.com.br 14 May '03

14 May '03

Hi, I need to read an M$-SQLServer database from an conectiva linux machine. Is there an free alternative to mxODBC or a simpler way to do that then the one described on: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver Thanks in advance, Rogerio ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail

4 4

Problem with send in ZClass
by Jamie White 14 May '03

14 May '03

I still need help with this I built a ZClass and I want to send an email if a certain property is missing, the script I am using to try to do this looks like this # Send an Email if draft == None: body="Content Provider " + AUTHENTICATED_USER.getUserName() + " has completed work on. Please review for publishing" context.MailHost.send(body, mto="jamie(a)brobus.net", mfrom="zope(a)brobus.net", subject="Content Done", encode=None) return body else: return "No Message" It works when I test it alone, but for some reason when it is run from the zclass zope says: Zope Error Zope has encountered an error while publishing this resource. Error Type: Unauthorized Error Value: You are not allowed to access send in this context I tried changing the proxy role on the script to manager but that didn't help. Jamie jamie(a)brobus.net _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

3 2

multi-column sort with ZCatalog
by Mark Nenadov 14 May '03

14 May '03

Hello all, I have a simple ZCatalog query with a sort_on and sort_order being passed to it. Is there any way I can do the sort on multiple columns? This seems like an important feature. I've heard that is not possible, but I'm wondering if I am just missing something/getting wrong info. I'm already looking into the Generic Sort External Method, but I'm wondering if there is some other way to do this? Thanks, ~Mark

5 6

RE: [Zope] Zope on Windows 2000 or 2003 Server?
by Passin, Tom 14 May '03

14 May '03

[george donnelly] > Is anybody running Zope on Windows 2000 or 2003 Server? I've > got a client > who may need to do this and I'd like to see if there are any > pitfalls, etc? > Not on Server but on Win2000 Workstation. No problems. Cheers, Tom P

1 0

search on multiple indexes
by Stephan Goeldi 14 May '03

14 May '03

Is it possible to search on multiple indexes at one time? The scenario is this: I have a simple text input field where I enter a word, e.g. 'house'. I would like to find all documents which contain the word 'house' either in the PrincipiaSearchSource -OR- in the title. ---------------------- Goeldi.com - eBusiness ---------------------- www.goeldi.com web(a)goeldi.com Fon +41-61-7330555 Fax +41-61-7330556 ----------------------

4 6

RE: [Zope] ODBC + Linux
by ratem＠censanet.com.br 14 May '03

14 May '03

> If your production database is sufficiently awful, you could export the data > into another database server for analysis and queries. I do this with > Postgres. My production database(PervasiveSQL) has some crippling weaknesses > so I have a python script that slurps the data out and pushes it into > Postgres. Then I run some additional sql scripts to renormalize and > pre-aggregate some data fields. I then create zope-based web reports that > use that second database. If I need to drill-down to specific job details, I > can link directly to my production data and the users never see the seam. If > you give up and want to pursue something like this, I can send you my > scripts. > Although my M$ database is ok, I still consider exporting data to Linux and then querying, so I would appreciate if you send your Zope/Python scripts. Thanks a lot! Rogerio ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail

1 0

carriage returns and newlines entered into HTML form inputs
by AdvertisingDept 14 May '03

14 May '03

HTML Form contains a textarea inputs. Form submits data to MySQL database. User wants to enter distinct 'lines' into a textarea input box - such as a formatted mailing address. Street Address Suite / routing City, ST zipcode They press return at end of each line, and the textarea input box complies formatting the data on their screen. However, when I retrieve the data from the SQL database, the formatting / carriage returns are gone? Is this my imagination, or has it dropped the formatting characters? How do I pass/retain/interpret the returns? This is probably a simple NEW ZOPE USER issue, I just don't know how to phrase it when searching the list archives. Thanks in advance.

3 2

Local or not local roles?
by Marco Lazzeri 14 May '03

14 May '03

Hello! I was just surfing around into ZMI when into http://dual:27080/some_filename/manage_listLocalRoles i've found this: "To give a user extra roles when accessing this object (and ___its children___), select a user from the User list below, select the extra roles that should be given to that user from the Roles list." Are not local roles setted only in that exactly context? Why it says says "(and its children)"? Thank you, Marco Lazzeri

2 1

RE:[Zope] Newbie: creating objects programmatically
by Richard Jennings 14 May '03

14 May '03

Thanks Dmitry >1) method document_src() requires no parameters (self is passed implicitly by python) >so you write >context.['index_html'].write(context.memberIndex.document_src()) I tried this and got the error message mentioned, so I tried again with the explicit 'self' - no go. >2) To create a page template with a content, you may pass it in constructor: >container.manage_addProduct['PageTemplates'],manage_addPageTemplaate('index_html', text=context.memberIndex.document_src()) This is certainly more elegant and I had spotted it in ZopePageTemplates.py but I wanted to go step by step. However, neither of the solutions works for me because I always get the 'Unauthorized' error message. With my limited experience, I don't know how to start debugging this. Can you help me again? regards Richard

2 3

NewBie Question: How to get Collector Object for a particular Collector Issue Object?
by saravanan annamalai 14 May '03

14 May '03

Hi all, I have a Collector Issue Object. I want to get the Collector Object to which this issue belongs.. I know its a very simple problem for many of you. But I am a NewBie to zope.... Hope somebody would give their valuble guidance.. regards saravanan A ___________________________________________________ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more.

2 1