- Zope - Zope lists

Display images stored in Relational DB
by Thomas G. Apostolou 19 Oct '05

19 Oct '05

Hello all, I try to display some images stored in SQL Server 2K. What i do is: I have an External Method "GetPrList" witch is connected to a python module that reads like this def GetPrListData(self, sysDSN="Test_A_Voisys", usr="sa", mypass="voisys"): id = self.id import dbi import odbc connection=odbc.odbc(sysDSN+'/'+usr+'/'+mypass) cur=connection.cursor() sSQL='SELECT M.CODE,M.NAME,X.SODATA FROM dbo.MTRL M JOIN dbo.XTRDOCDATA X ON M.MTRL=X.REFOBJID WHERE X.SOSOURCE=51 AND M.MTRGROUP=3' cur.execute(sSQL) data=cur.fetchall() cur.close() connection.close() return data X.SODATA is jpg stored in SQL 2K in a field degined as [SODATA] [image] NULL The above select returns -executed from within PythonWin- the folowing: [('ACC.ART.0001', 'xd3xc5xd4 xc2xc9xc4xc5xd3 & xd0xc1xcexc9xccxc1xc4xc9xc1 xccxc5 xc5xcbxc1xd4 andy', <DbiRaw object at 0x0099D2A0>), ('ACC.CO3.0001', 'BATTERY xccxcfxcbxd5xc2xc4xcfxd5 12V', <DbiRaw object at 0x0099D2D0>), ('ACC.CO3.0002', 'MExcbxc1xcdxc9 xcfxcaxc9 10i/12i/14e', <DbiRaw object at 0x0099D2C0>)] Then from a DTML Method "ShowResults" i call the above External Method "GetPrList" and show its results in a table. ShowResults reads like this: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"> <script type="text/javascript" src="/plone_javascript_variables.js"></script> <script type="text/javascript" src="/plone_javascripts.js"></script>  <style type="text/css" media="screen"></style>  <style type="text/css" media="screen"></style>  <style type="text/css" media="all"></style>  <meta http-equiv="imagetoolbar" content="no" /> </head> <dtml-var standard_html_header> <table id="sortable" class="listing" summary="Content listing" cellpadding="0" cellspacing="0"> <thead> <tr> <th class=""> Κωδικός </th> <th class=""> Ονομασία </th> <th class=""> Εικόνα </th> </tr> </thead> <tbody> <dtml-in expr="GetPrList(sysDSN=dsnName, usr=usrID, mypass=passWD)"> <dtml-if sequence-even> <tr class="even"> <dtml-else> <tr class="odd"> </dtml-if> <dtml-in sequence-item> <td><dtml-var sequence-item> </td> </dtml-in> </tr> </dtml-in> </tbody> </table> <dtml-var standard_html_footer> dsnName, usrID, passWD are properties with values of a folder i use with aquisition when i call DTML Method "ShowResults" The problem is that i get a "pythonw.exe" Debug-Send Error Report-Don't Send window and zope server breaks down. ( yes i use windows Xp Pro, Zope 2.7.0, Python 2.3.3) Thanks in advance Thomas G. Apostolou Software Engineer Θωμάς Γ. Αποστόλου Μηχανικός Λογισμικού

2 2

Showing image field from SQL Server 2K
by Thomas G. Apostolou 19 Oct '05

19 Oct '05

How can i show image field from SQL Server 2K? Do i have to select and show it with a special way? Thomas G. Apostolou Software Engineer Θωμάς Γ. Αποστόλου Μηχανικός Λογισμικού

2 1

Re: [Zope] Zope Debugger lets WingDbg fail to connect toclient
by Chris Withers 19 Oct '05

19 Oct '05

Stephan Deibel wrote: > You can turn on and off debugging from the WingDBG control panel > which installs/removes the tracer hook and also the monkey > patches. When off, it's the same as if no debugger were running > (except that WingDBG lets you turn it on again dynamically). Is the WingDBG control panel in Zope or in WingIDE? Where's the code which does this "turning off and turning on"? >>>Also, someone mentioned changing the monkey patch to call inherited. >> >>Not sure what you mean by that... > > I meant trying to call the inherited/replaced method to do the > work or more of the work rather than completely replacing it. > This *might* make things less brittle (but I doubt it, actually > ;-). Well, it's more than you may want to call the method you're replacing when you're monkey patched method is done doing what it's doing. zdb does this with prettymuch all its monkeypatches... > The old/existing impl adds a ##'ed comment block to scripts and > ends up stripping the block before compiling the script so that > line numbers in the code object don't match up with the copy of > the script that has the ##'s (which is what anyone reading from > the file system will see). The patch changes this to compile > the script w/ the ##'ed comment in place. Yes, but this stuff isn't necessary ;-) (and has nothing to do with the code that patches co_filename, right?) > Re: patching Zope + CMF: It should be possible to patch CMF so > that it can run w/ either patched or unpatched Zope. The author > of CMFFormController accepted our patch when it was originally > submitted and did that. Odd. You earlier suggested you wanted to get "Zope" changed to co_filename was meaningful. That change also needs to be made in FSPythonScript. That one small change is the only thing I'm talking about ;-) > Hmm, so perhaps reworking the patch for CMF to work like that > might help get it accepted... then the question is whether the > Zope patch can be made to work w/ unpatched CMF (if that is an > issue; or is it OK for Zope to change under CMF?). The two should have nothing to do with each other... > As far as a standard for co_filename it should be the full path > file name for FS scripts (O/W most debuggers won't work out of > the box), Well, you see, that doesn't work for me ;-) (Since I tried both FSPythonScripts and PythonScripts in the same way, and that uses their full ZODB path) > We'll try to do actual work on this (rather than sending emailed > drivel ;-) after Wing 2.0.4 is out. Unfortunately, we've got > various things going on that has left us w/ very little extra > time for the next month or so. You might start by actually getting to know how zdb works, there's very little code in it and it tackles the problem in a different way which avoids all the trouble you're getting into above... cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

A Flash file in Zope262
by GAYOT Philippe SZSIC35 - BOM 19 Oct '05

19 Oct '05

Hi, I want to show a Flash file in my home's page under ZopeCMF 262. Could anyone tell me the best way to do that ? Best regards.

3 2

Zope 2.8.3 released
by Andreas Jung 18 Oct '05

18 Oct '05

Hi all, on behalf of Zope Corporation and the Zope community I am pleased to announce the release of Zope 2.8.3. You can download Zope 2.8.2 from http://www.zope.org/Products/Zope/2.8.3/ This version obsoletes Zope 2.8.2 which shipped with an older Docutils version as expected. For security reasons you should update to Zope 2.8.3. Some new features of Zope 2.8: - ZODB 3.4 with MVCC (multi version concurrency control) support. MVCC solves nearly every problem with ZODB read-conflict errors which is very important for high-traffic Zope sites. - Extension Classes were rewritten as Python new-style classes making all features of Python new-style classes available in Zope objects. This includes support for cyclic garbage collection. - Integration of Zope 3 technologies through Five (see http://codespeak.net/z3/five/) For more information on what is new in this release, see the CHANGES.txt files for the release: http://www.zope.org/Products/Zope/2.8.3/CHANGES.txt See also: http://www.zope.org/Wikis/DevSite/Projects/Zope2.8/OverView Please bring all the bugs you have found to the Zope bugtracker: http://collector.zope.org/Zope":http://collector.zope.org/Zope For more information on the available Zope releases, guidance for selecting the right distribution and installation instructions, please see: http://www.plope.com/Books/2_7Edition/InstallingZope.stx Please also keep in mind that Zope 2.8.2 requires Python 2.3.5. Zope 2.8.2 is not certified for any Python 2.4.x versions. So using Python 2.4 is neither recommended nor supported and any related questions or problems are likely to be ignored until 2.4 is an officially supported Python version for Zope. -- Andreas Jung (andreas at zopyx dot com)

1 0

How can i call a pyhton module's function from with in Page Temmplates?
by Thomas Apostolou 18 Oct '05

18 Oct '05

Hello, i saw that from within a DTML Method one is able to call a fuction of a python module in the file system. Now i want to get the funtion's results from within a Page Template. Is the right way to make a Script(Python) that calls this module's function and then call this Script(Python) from within my Page Template? Is there any other less nifty way to do this? Thanks in advance. ___________________________________________________________ Χρησιμοποιείτε Yahoo!; Βαρεθήκατε τα ενοχλητικά μηνύματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr

5 6

access rule and authentication
by Krzysztof Kubacki 18 Oct '05

18 Oct '05

Hi, Python Script which is set as "Access Rule" for some Folder is execute before authentication is done. This way the following code won't work if context.portal_membership.getAuthenticatedUser().getId() == "admin": return "dog" return "cat" I will always get "cat". So does somebody know how to resolve it? Regards Krzychula

3 4

Re: [Zope] selected in select lists
by Garry Saddington 18 Oct '05

18 Oct '05

Nicolas Gouzy wrote: >I think this code works : > ><select name="groupabbrev"> ><dtml-in getpastoralgroups> > <option value="<dtml-var expr="_['sequence-item']">" <dtml-if >expr="groupabbrev==_['sequence-item']"> selected</dtml-if> ><dtml-var >expr="_['sequence-item']"></option> ></dtml-in> ></select> > >-- >Nicolas Gouzy >nicolas.gouzy(a)gmail.com > > > > This producing the following result, is this what it should do? <select name="groupabbrev"> <option value="<Shared.DC.ZRDB.Results.r object at 0x43aa7c0c>"><Shared.DC.ZRDB.Results.r object at 0x43aa7c0c></option> <option value="<Shared.DC.ZRDB.Results.r object at 0x43f95824>"><Shared.DC.ZRDB.Results.r object at 0x43f95824></option> <option value="<Shared.DC.ZRDB.Results.r object at 0x43aa7c0c>"><Shared.DC.ZRDB.Results.r object at 0x43aa7c0c></option> <option value="<Shared.DC.ZRDB.Results.r object at 0x43f95824>"><Shared.DC.ZRDB.Results.r object at 0x43f95824></option> </select> regards Garry

6 11

DateTime again.
by Fernando Lujan 18 Oct '05

18 Oct '05

Is it possible to informe the DateTime module about the date format without changing the zope.conf file? Format: dd/mm/yyyy When I try the <dtml-var "DateTime(12/11/2005)"> it returns 2005/12/11 instead of 2005/11/12. Thanks in Advance. Fernando Lujan

3 2

NTUserFolder still useful?
by Sean Dunn 17 Oct '05

17 Oct '05

I'm running Zope on WindowsXP with plans to run it on server 2003. Instead of creating user accounts I'd like to leverage NT authentication.. And NTUserFolder looks like it might be what I want, except that it looks like a dead product. Besides a note that it works on Win2k under certain constraints, I'm not sure if I should try using it. Have people had success installing this on WinXP/S2003? Thank you, Sean - Sean Dunn Tools Programmer Troublemaker Digital

3 2