June 2003 - Zope - Zope lists

(Slightly off topic) SQL syntax to HTML
by Peter Bengtsson 26 Jun '03

26 Jun '03

Does anybody have or knows where I can find some module/function to "pretty print" some SQL strings to HTML. Just like there's py2html, but sql2html for python. I'm asking the Zope people because in Zope you very often output HTML and often use SQL. Peter

3 2

Your message to Html-template-users awaits moderator approval
by html-template-users-admin＠lists.sourceforge.net 26 Jun '03

26 Jun '03

Your mail to 'Html-template-users' with the subject Re: Application Is being held until the list moderator can review it for approval. The reason it is being held: Post by non-member to a members-only list Either the message will get posted to the list, or you will receive notification of the moderator's decision.

1 0

We will not receive your email
by csmail＠support.prognet.com 26 Jun '03

26 Jun '03

Greetings, You have received this message as a result of replying via email to a RealNetworks Order Receipt or Customer Service message. We will -not- receive this email, and have no means of responding. If you received this mail as a result of replying to your Order Receipt from our e-commerce system at www.real.com or www.realstore.com, you will need to submit your service request at the following URL: http://service.real.com/faq/contcs.html If you received this message as a result of replying to a customer service response, there are instructions on how to reply to the customer service agent that responded to your inquiry. This reply method is handled with a web form, and you may find the URL in the Customer Service response message. Thanks again for seeking assistance, and we hope that your problem is resolved shortly. Best regards, Customer Service RealNetworks, Inc.

1 0

Re: [Zope] DTML form variable name cocatenation
by Mike Doanh Tran 25 Jun '03

25 Jun '03

use <dtml-var sequence-number>: <dtml-in SQL_getMath> <input name="i<dtml-var sequence-number>" type="checkbox" value="1" > </dtml-in> See section Appendix A of Zope Book under "in: Loops Over Sequences" for more details. Cheers, Mike On Wednesday 25 June 2003 01:26 pm, you wrote: > Would anyone have a suggestion on how to do this in DTML? > > I have a dtml-in statment that returns a variable number of values > from a database field "standard_text" from a MySQL database. What I > need to do is replace the <input name="i" ..> name value with a > unique variable name for each iteration. > > <dtml-in SQL_getMath> > <input name="i" type="checkbox" value="1" ><br> > </dtml-in> > > Optimally this would output something like: > > <input name="i1" type="checkbox" value="1" ><br> > <input name="i2" type="checkbox" value="1" ><br> > <input name="i3" type="checkbox" value="1" ><br> > > Where the letter "i" is cocatenated to a incremeting value to > construct the form checkboxes name value. > > My guess is that the solution would have something to do with > cocatenation and looping. Any suggestions? > > Harlow Pinson > Indepth Learning > Email: hpinson(a)indepthl.com > Web: http://www.indepthl.com > Voice: 505-994-2135 > FAX: 208-475-7678 > >

1 0

Re: ZOPE IN WINDOWS, ANY WARNINGS I SHOULD KNOW?
by hpinson＠indepthl.com 25 Jun '03

25 Jun '03

We are finding W2K Server / Zope 2.51 / MySQL-ZODBC / Apache to be a very stable platform, and a breeze to manage via the MS Terminal Server. The only failure we have had in a year of production usage was due to exceeding the 2G file size limit. The server is under moderate load running government information websites. And yes, we like Linux too, Redhat 9 and Mandarke 9.1. ;o) Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

1 0

RE: [Zope] calling os.system using external method
by sean.upton＠uniontrib.com 25 Jun '03

25 Jun '03

Some notes on spawning an external process, assuming you want it to "detach." http://aspn.activestate.com/ASPN/Mail/Message/zope-List/1629207 > -----Original Message----- > From: J Cameron Cooper [mailto:jccooper@jcameroncooper.com] > Sent: Wednesday, June 25, 2003 1:07 PM > To: zope(a)zope.org > Subject: Re: [Zope] calling os.system using external method > > > > > > > >I have an External method that uses os.system to execute > >a linux command on a local host. I am trying to pass a file name > >to the findDocs function (see below) to locate the location > (path) of the > >wanted file and print it out on a dtml document. Can > someone please show me > >how to make this work? > > > >Thanks in advanced for any suggestions. > > > >#Python script to find location/path of local file > >import os > >unixCommand = 'find /home/uploads/ -name %' > >def findDocs(arg): > > os.system(unixCommand%arg) > > > >DTML: > ><dtml-call "externalMethodName(arg=fileName)"> > > > > > I suspect you'll want to use one of the commands that allows > you to get > the results of a system call. Without the Python docs in > front of me, I > think that's 'os.popen' or similar. Maye you can do it with > 'os.system', > but I don't do it enough to have memorized it. > > Split the results from stdin into elements of a list(by newline, > probably), and call it with a list iterator (like dtml-in) to do your > rendering. Shouldn't be more that five or six lines. > > --jcc > > > > _______________________________________________ > 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 ) >

1 0

RE: [Zope] Rendering PageTemplateFile
by sean.upton＠uniontrib.com 25 Jun '03

25 Jun '03

Online ZDG chapter on acquisition should cover: Implicit.__of__() Any class inheriting from Implicit has the __of__() method, for wrapping its instances in context and containment, for example: app = Zope.app() portal = app['myCMFSite'].__of__(app) ##portal should acquire from parent folder Note, in this case, portal is NOT the CMF site object, but a wrapper that contains the CMF site object (aq_base) and proxies calls to it, and further up the chain to the parent (aq_parent). In your case the template object needs to actually be a wrapper containing a PageTemplateFile object, and reference to parents to try when it's deemed necessary to move "upward" on the so-called namespace stack. Sean > -----Original Message----- > From: Max M [mailto:maxm@mxm.dk] > Sent: Wednesday, June 25, 2003 12:37 AM > To: Dieter Maurer > Cc: zope(a)zope.org > Subject: Re: [Zope] Rendering PageTemplateFile > > > Dieter Maurer wrote: > > > You page template is not acquisition wrapped (and therefore cannot > > define "here", "container", ... > > > > Try: > > > > pt= PageTemplateFile(...).__of__(self) > > Dieter, is __of__() documented anywhere? > > Is it a new method? I haven't seen it before. > > regards Max M > > > _______________________________________________ > 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 ) >

1 0

DTML form variable name cocatenation
by hpinson＠indepthl.com 25 Jun '03

25 Jun '03

Would anyone have a suggestion on how to do this in DTML? I have a dtml-in statment that returns a variable number of values from a database field "standard_text" from a MySQL database. What I need to do is replace the <input name="i" ..> name value with a unique variable name for each iteration. <dtml-in SQL_getMath> <input name="i" type="checkbox" value="1" ><br> </dtml-in> Optimally this would output something like: <input name="i1" type="checkbox" value="1" ><br> <input name="i2" type="checkbox" value="1" ><br> <input name="i3" type="checkbox" value="1" ><br> Where the letter "i" is cocatenated to a incremeting value to construct the form checkboxes name value. My guess is that the solution would have something to do with cocatenation and looping. Any suggestions? Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

1 0

Content management system
by keith＠lightwave1.net 25 Jun '03

25 Jun '03

Dear Sir I was just looking at Zope 2.6.1 on your website and I would like to know if it or any other software you provide could help me fulfil certain objectives for an upcoming job. A prospective client of mine requires a content management system. We are planning to install this on his server that houses the company's intranet and we want to set up a system whereby if a user from another country logs onto this intranet site via the worldwide web (with a pre-defined USERNAME and PASSWORD) he could, according to his access privileges access a HTML or PHP page with a menu and search function and use this to search for a list of documents by certain criteria (for example by date or subject etc) These documents will be contained within a database possibly MySQL or Oracle etc. He will then see a webpage with the list of documents with links. When he clicks on one link, he will then see the document (through the web browser) and it could be a WORD or EXCEL document and he could have the option to download this by clicking a download button. He could then alter this document in WORD etc (depending on the document itself) and then upload this to the same database on the intranet so that it replaces the old one. This would work very much like Livelink (www.livelink.com) Ideally it has to be a system that is easy to use especially by someone not used to IT. I was looking at your website and I wondered if your software could meet the above requirements. I would really appreciate it if you could get back to me as soon as possible as this client requires an answer within the next 2 days. Thank you very much Keith Trodden

2 2

testing query results for presence in an array
by David Siedband 25 Jun '03

25 Jun '03

This is for a page where the user can update the listing for a particular project. I have a query that returns a complete list of all locations, and another query that returns the list of locations already selected for a given project. What I'd like to do is render the complete list in a multiple selection form element and have the keywords that are already entered for the project appear as selected in this list. Here's the code: <dtml-in "queries.getPlacesForHypothesis()" prefix=obj> <select multiple name="places"> <dtml-in "queries.getPlacesAll()"> <option value="<dtml-var PlaceID>" <dtml-if "PlaceID in obj_items" > selected </dtml-if>><dtml-var PlaceName></option> </dtml-in> </select> </dtml-in> About the Z SQL queries: getPlacesAll() returns an array of PlaceID's and PlaceName's getPlacesForHypothesis() returns a sequence of PlaceID's How do I test to see if a place is in in the list of selected places for a project? thanks, David

1 0