- Zope - Zope lists

RE: [Zope] PYTHON script
by Norman Khine 11 Jun '01

11 Jun '01

Thanks a lot guys, appreciated ;^) -----Original Message----- From: Peter Kropf [mailto:peter@verecomm.com] Sent: 11 June 2001 23:31 To: 'Norman Khine' Subject: RE: [Zope] PYTHON script Quotes within quotes - Try: b.execute("SELECT location, SUM(IF(gender='M',1,0)) AS M, SUM(IF(gender='F',1,0)) AS F FROM locations INNER JOIN employees USING (loc_code) GROUP BY location") - Peter > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > Norman Khine > Sent: Monday, June 11, 2001 3:20 PM > To: Zope > Subject: [Zope] PYTHON script > > > Hello I have a MySQL database and I can run the following > script using the > command prompt > > SELECT location, SUM(IF(gender='M',1,0)) AS M, > SUM(IF(gender='F',1,0)) AS F > FROM locations INNER JOIN employees USING (loc_code) GROUP BY > location; > > this also works within Zope > > but when I try to run this from the python prompt I get an > > File "<stdin>", line 1 > b.execute('SELECT location, SUM(IF(gender='M',1,0)) AS M, > SUM(IF(gender='F',1,0)) AS F FROM locations INNER JOIN employees USING > (loc_code) GROUP BY location') > ^ > SyntaxError: invalid syntax > > this is what I did > > >>import MySQLdb > >>db = MySQLdb.connect(db='mydb',user='myuser',passwd='mypasswd') > >>b = db.cursor() > >>b.execute('myquery') > > error > > any ideas > > thanks > > norman > > ps perhaps this post is more suited to the python mail list, > please forgive > as I am only a member of the zope community.;^) > > zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz > zz/********/z/****\zzz|****\*\zz|*******|z > z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine > zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman@khine.net > zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley > z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK > zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz > zz/******/zz\******/zz|*|zzzzzzz|*|*****|z > z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z > zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz > > > > _______________________________________________ > 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 1

PYTHON script
by Norman Khine 11 Jun '01

11 Jun '01

Hello I have a MySQL database and I can run the following script using the command prompt SELECT location, SUM(IF(gender='M',1,0)) AS M, SUM(IF(gender='F',1,0)) AS F FROM locations INNER JOIN employees USING (loc_code) GROUP BY location; this also works within Zope but when I try to run this from the python prompt I get an File "<stdin>", line 1 b.execute('SELECT location, SUM(IF(gender='M',1,0)) AS M, SUM(IF(gender='F',1,0)) AS F FROM locations INNER JOIN employees USING (loc_code) GROUP BY location') ^ SyntaxError: invalid syntax this is what I did >>import MySQLdb >>db = MySQLdb.connect(db='mydb',user='myuser',passwd='mypasswd') >>b = db.cursor() >>b.execute('myquery') error any ideas thanks norman ps perhaps this post is more suited to the python mail list, please forgive as I am only a member of the zope community.;^) zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz zz/********/z/****\zzz|****\*\zz|*******|z z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman@khine.net zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz zz/******/zz\******/zz|*|zzzzzzz|*|*****|z z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

2 1

FW: Wikis without the headers and footers?
by Meilicke, Scott 11 Jun '01

11 Jun '01

Sorry to answer my own (newbie) question - I need to learn the basics of zope :) I created a zwiki page, changed the page_type property to structuredtextdtml, and entered: <dtml-in expr="(WikiPage1,WikiePage2,OtherWikiPages)"> **<dtml-var title_or_id>** <p> <dtml-var text> </dtml-in> -Scott -----Original Message----- From: Meilicke, Scott Sent: Monday, June 11, 2001 8:32 AM To: 'zope(a)zope.org' Subject: Wikis without the headers and footers? Hello, I want to create a single document from all of my relevant wiki pages. I created a DTML method that calls each wiki page that I want: <dtml-var FrontPage> <dtml-var Purpose> <dtml-var KeyCustomers> etc... but that gives me headers and footers. Is there a way to remove the headers and footers of each page? I'm using zwiki 0.8.1 and zope 2.3.0. Thanks - Scott

1 0

ExtImage and Email
by Arno Gross 11 Jun '01

11 Jun '01

Hello, I am trying to send an image of class ExtImage as attachment in an email. If image is of class Image I can do this: <dtml-boundary type=application/octet-stream disposition=attachment name=myTest.gif encode=base64> <dtml-var "myTest.data"> But which method (I couldn't find one) have I to use when image is of class ExtImage? Any hints? Best regards Arno

1 1

Zope book comment form
by Kyler B. Laird 11 Jun '01

11 Jun '01

Is the comment form at http://www.zope.org/DocProjects/Book/comments active? Once again, I submitted a list of typos, and I don't see the entry in the bug tracker. Here's what I caught scanning the first 50 pages. it's friendly, open source license Zope let's you it's ZEO technology based on it's id it's URL would be it's purpose is to It'd be great if new users could at least get through the first few pages before they encounter a typo. I want people to think of Zope as being a polished product. Thank you. --kyler

3 2

Viewing a version of a website?
by Etienne Labuschagne 11 Jun '01

11 Jun '01

Hi all If I am working on a version of a website, how do I view the website reflecting the current version I am working on and not the one visible to the public. Due to some JavaScript that we use, I cannot view the site in the management interface and must open a seperate browser on which to view the site. Also, is there a way of auto-joining a version the moment I log in? I want to avoid the possibility of editing the "live" website by accident if I forget to join a version. An alternative would be to lock all the objects in a site to the current edit version, but I don't know how to do that - any suggestions? Any pointers to articles on using Zope versioning would also be very helpful as I couldn't find any on Zope.org or other sites. Etienne

2 1

FSSession trouble
by Peter Bengtsson 11 Jun '01

11 Jun '01

I have problems with the FSSession product (0.4.2) http://www.zope.org/Members/gaaros/FSSession Firstly, I rename the FSSession object to prevent naming confusion. ------ index_html --------------------------- <dtml-call changesSession> <dtml-var "_.str(changesSession)">  <dtml-call "changesSession.set('name','peter')"> <dtml-var "_.str(changesSession)">  <dtml-call changesSession> <dtml-var "_.str(changesSession)">  ------ /index_html --------------------------- Did you see what happened?? I lost a variable I managed to set as a cookie when calling the FSSession object again towards the bottom! Why this? How to prevent it? What I do in reality (the above pseudo) is that in standard_html_header I call the FSSession object and then use it to display custom Stylesheets. Then I call the FSSession object again to use it in standard_html_footer to use it to display different footers. The <dtml-call FSSession> is vital to be able to begin to use it, but why isn't it enough just to do it once in standard_html_header in a code like this: <dtml-var standard_html_header> <h1>A Page</h1> <dtml-var standard_html_footer> One simple alternative is to set a REQUEST variable in standard_html_header and use that instead of using the object in the standard_html_footer Welcoming some Zopezen Peter

3 5

Re: [Zope] Browsers Differences Again
by Tim Cook 11 Jun '01

11 Jun '01

"Thomas B. Passin" wrote: > > That's why I wanted to see the original html. I have never had trouble with > IE finding things on relative paths, it's always worked just as I expected. > With Zope, though, I sometimes have trouble if there isn't a trailing slash. > Maybe that was involved, and maybe NS supplies one. > Hmm, maybe on the right track with that. The bad code: > > > <frame src="menu" name="sched_menu"> > > > <frame src="<dtml-var this_year>" name="sched_main"> The working code: > > > <frame src="/FreePM/scheduling/menu" name="sched_menu"> > > > <frame src="/FreePM/scheduling/<dtml-var this_year>/index_html" As you can see I added the /index_html at the same time I prepended the path. So for the second frame that would explain it. However, in the first frame the called method is in the same folder as the calling method. Oh well, maybe when I have some extra time I'll break it again on the development site and try to figure it out. <s> -- Tim Cook, President - FreePM,Inc. http://www.FreePM.com Office: (731) 884-4126 ONLINE DEMO: http://www.freepm.org:8080/FreePM

1 0

Indexing and plaintext display gives PDF errors
by Leigh Ann Hildebrand 11 Jun '01

11 Jun '01

I'm using Zope 2.3.2 with Python 1.5.2 running on Redhat. I don't use Python, I work in DTML. I'm cataloging technical documents. I do not use Document Library or the CMF, in part because of compatibility restrictions. (The site must support NetPositive, a non-javascript, non-CSS compatible browser.) The documents I'm indexing are html, text, Word, PowerPoint, and PDF files. I have the CMF and the Document Library product installed; I also had installed wvWare, though I'm not sure I installed it correctly. (The instructions were vague.) This is my problem. When I update my Catalog, I get a number of errors on the linux box that runs my Zope installation, related to PDF files: Error (0): PDF file is damaged - attempting to construct xref table ... Error: Top level pages is wrong type (null) Error: Couldn't read page catalog Error: Couldn't find trailer dictionary Error: Couldn't read xref table These repeat a few times, giving me two screens worth, before the index updating is complete. I can think of at least one problem that might be going on here: I think some PDF documents were added as type "DocumentFile", which is related to the DocumentLibrary stuff. Anyway, I'm trying to get rid of the errors, and be able to index the text of PDF and Word files. Suggestions? I'm forwarding this to the DocumentLibrary product engineer, too. Leigh Ann -- Leigh Ann Hildebrand leighann(a)onebox.com - email (650) 223-2199 x2231 - voicemail/fax __________________________________________________ FREE voicemail, email, and fax...all in one place. Sign Up Now! http://www.onebox.com

2 1

zsqlrelay
by J�lio Dinis Silva 11 Jun '01

11 Jun '01

Hi, this message is for ppl who use zsqlrelay. I'm having the following problem: I start 3 sqlr-connection-freetds. Then I do 3 queries(execute 3 zsql methods) with success but after that it is no more :-(, i.e, I cant do no more queries. Arent this connection persistent ones? Only by giving the sqlr-stop and sqlr-start command I'm then able to query again the mssql db. setup: -sql-relay 0.21 (where is the 0.24? firstworks.com is no more, anyone?) -rudiments-0.15 -freetds0.51 configured --with-tdsver=7.0 to support mssql 7.0 -zope 2.3.2-src Any help? Directions to sqlrelay new locations? Best Regards, Julio Dinis Silva _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0