- Zope - Zope lists

RES: [Zope] formatting problem...
by Daniel Corrêa de Azevedo 15 Mar '01

15 Mar '01

Deer paz, my group figured out that there is a SQL function FORMAT that can be used to get rid of the L sufix that comes in the query result. e.g: SELECT FORMAT(int_key, 0) FROM data That code should result to you a query without the L sufix. See you, Daniel. **************************************************************************** ******************************************************** > ZMySQLDA always converts columns of MySQL type int(11) (the normal > 'integer' field type) to Python Long values. The reason this is done is > that the MySQL integer data type can hold values larger than the normal > Python integer. > > Python 1.5.2 and earlier had a bug that caused a Python long to print > out with the L suffix; this bug was fixed in 2.0 (and maybe 1.6, > although I haven't tried it). > > The conversion table in ZMySQLDA can be found in > lib/python/Products/ZMySQLDA/db.py, in the DB class: > > conv={ > FIELD_TYPE.TIMESTAMP: _mysql_timestamp_converter, > FIELD_TYPE.TINY: int, > FIELD_TYPE.SHORT: int, > FIELD_TYPE.LONG: long, > FIELD_TYPE.FLOAT: float, > FIELD_TYPE.DOUBLE: float, > FIELD_TYPE.LONGLONG: long, > FIELD_TYPE.INT24: int, > FIELD_TYPE.YEAR: int, > FIELD_TYPE.DATETIME: DateTime, > FIELD_TYPE.DATE: DateTime, > FIELD_TYPE.TIME: DateTime > } > (from ZMySQLDA-2.0.4) > > > If these L's are causing you trouble, you can edit this code to show int > in place of long for the FIELD_TYPE.LONG and FIELD_TYPE.LONGLONG. > > Something like this external method might also work, if you call it > before making any SQL queries: > > def patch_ZMySQLDA_for_ints(self): > from Products.ZMySQLDA.db import DB > from _mysql import FIELD_TYPE > DB.conv[FIELD_TYPE.LONG] = int > DB.conv[FIELD_TYPE.LONGLONG] = int > > Note that this method would have to be called at every time your server > was started, or for safety's sake before each query was run. > > -Randy > > > -----Original Message----- > > From: Paul Zwarts [mailto:paul.zwarts@oratrix.com] > > Sent: Thursday, March 15, 2001 8:12 AM > > To: Daniel Corrêa de Azevedo > > Cc: 'zope(a)zope.org' > > Subject: Re: [Zope] formatting problem... > > > > > > Hi Daniel, > > > > I have had similar problems with MySQL... What I use to get > > around it is to send > > it through the integer module. You'll find this also handy > > for converting > > strings that only contain numbers and dates to floats and > > yadda yadda....: > > > > <dtml-var "_.int(varname)"> > > > > Anyone got a better one? Or rather, explain why MySQL > > translates everthing as > > long integers? Is this ALWAYS the case when defining a dbase > > field as INT4? > > Cheers, > > Paz > > > > Daniel Corrêa de Azevedo wrote: > > > > > Hello you all. > > > I´m having problem in using FMT atribute of the > > DTML-VAR tag in dtml > > > methods. The situation is that when I receive some integer > > data from a MYSQL > > > database, I get it with a L sufix. That makes it necessary > > to format the > > > data with <dtml-var key fmt="%d">. Now, the problem is > > that, sometimes, I > > > need to keep on passing the data over to a few dtml > > methods, and when ever I > > > need to reformat the data, I get an erro message: " Ilegal > > argument type for > > > built-in operation.". > > > I need to reformat because the data in the other > > dtml-methods in the > > > sequece may be being received from the MYSQL database. > > > How coud I reformat the data using <dtml-var key > > FMT="????">, even if it > > > has already been formated by <dtml-var key fmt="%d">? > > > > > > Thanks, > > > > > Daniel C. Azevedo > > > > > > _______________________________________________ > > > 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 ) > > > > > > _______________________________________________ > > 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 0

Re: [Zope] Authenticating against NT domain from NT-based Zope
by spinwing＠inwind.it 15 Mar '01

15 Mar '01

Hello Ian sorry, I missed that. The only pointers I can give you is the following. Reading the "Python Programming on Win32" from O'Reilly, there is a short example on how to reboot a machine. In this example it is mentioned to refer to the MS WinNT Security document. Looks like the win32security module is just a wrapper around the standard MFC or C API for Microsoft. I have found http://msdn.microsoft.com/library/psdk/winbase/accclsrv_9cfm.htm. In this pointer is stated that the flag LOGON32_LOGON_NETWORK is associated with limitations as: "to authenticate clear text passwords". I suppose you did not tricked the registry to send clear password over the network, so this can be one problem. It could be that you should use LOGON32_LOGON_BATCH. Let me know, I' curious. Regards Stefano Dear Stefano, > have you tried to do this in an External Method rather than in a > script? Scripts have security checks which are not applied to > external methods. This can be a little help in solving the problem. Indeed. The script I gave in my original email < http://groups.yahoo.com/group/zope/message/54291 > isn't actually a Zope Python Script. It's just a standalone bit of Python that I can't get to work. Technically, I suppose, I'm having problems with the win32security module (I'm still keen to find some documentation if anyone can point me in the right direction), rather than Zope, but I was hoping someone here would have had similar problems. Cheers, Ian

1 0

Re: [Zope] Namespace confusion
by Dieter Maurer 15 Mar '01

15 Mar '01

Joel Burton writes: > On Wed, 14 Mar 2001, Dieter Maurer wrote: > > > Apparently, the "JDiscuss_Folder_add" only looks on "REQUEST" > > and not on the namespace. > > Erm, it's just the standard ZClass _add method. How could I get it to look > elsewhere on the namespace? It was generated during the ZClass construction. It is DTML. Look at its code (beside the ZClass in your product). Dieter

1 0

Re: [Zope] Authenticating against NT domain from NT-based Zope
by spinwing＠inwind.it 15 Mar '01

15 Mar '01

Hello Ian have you tried to do this in an External Method rather than in a script? Scripts have security checks which are not applied to external methods. This can be a little help in solving the problem. Regards Stefano Vedovelli

2 1

ANNOUNCE: Zope 2.3.1 beta 2 released
by Brian Lloyd 15 Mar '01

15 Mar '01

Hello all, Zope 2.3.1 beta 2 has been released - you can download it from Zope.org: http://www.zope.org/Products/Zope/2.3.1b2/ Zope 2.3.1b2 contains a number of bug fixes, including the fixes for the issues addressed by the 02/23 and 03/08 hotfixes. It also contains a number of changes to address issues with ZCatalog. New data structures have been introduced to reduce the number of conflict errors caused by object indexing under some types of usage, and to reduce the amount of object database bloat that occurs when indexed objects change frequently. The changes to ZCatalog have been designed so that newly created ZCatalog objects will take advantage of the new data structures. Existing ZCatalog objects will continue to work with the old data structures, but will not gain any of the benefits of the new code. It is possible to upgrade an existing ZCatalog object to use the new data structures by following the How-To at: http://www.zope.org/Members/mcdonc/HowTos/UpgradeToNewCatalog **Users of the Zope source releases should note** that this release contains new C code, as well as a few changes to existing C code. If you are using a source release (or the source diff update), be sure to run 'w_pcgi.py' or 'wo_pcgi.py' as appropriate before starting Zope to ensure that your binaries are rebuilt. For more information on what is new in this release, see the CHANGES.txt and HISTORY.txt files for the release: http://www.zope.org/Products/Zope/2.3.1b2/CHANGES.txt http://www.zope.org/Products/Zope/2.3.1b2/HISTORY.txt Note that we have also posted "diff" updates as .tgz files that will let you easily upgrade an existing 2.3.x site. These updates are available for those currently using the 2.3.x source release or the 2.3.x binary releases. To apply a differential update to your site: - download the appropriate .tgz file from zope.org - shutdown your Zope process - copy the .tgz to your Zope directory and extract it - run w_pcgi or wo_pcgi *if you are not using a binary release* - restart your process Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

Protected Z words
by Peter Bengtsson 15 Mar '01

15 Mar '01

Is there a list of variable names that should be avoided in Zope dev? For example, haveing a field in my mysql database called id or title isn't very smart. I know for a fact that "from" is a strange word. Or is it my application perhaps? <dtml-var from> didn't work, so I changed it to <dtml-var "REQUEST['from']"> and then it worked. Peter

2 1

Re: [Zope] SQLTEST is case insensitive?
by Dieter Maurer 15 Mar '01

15 Mar '01

The Doctor What writes: > .... > <dtml-sqlgroup where> > <dtml-sqltest ID type=int optional> > <dtml-and> > "val_Protocol"."ID" = "URL"."val_ProtocolID" > </dtml-sqlgroup> > > If I make that: > <dtml-sqlgroup where> > "URL"."ID" = <dtml-var ID sql_quote> > <dtml-and> > "val_Protocol"."ID" = "URL"."val_ProtocolID" > </dtml-sqlgroup> > > > Then ID cannot be optional. I can't use this object as a 'list all' > solution. Isn't that the whole point of the dtml-sqltest tag? Then, you wrap it into an "dtml-if": <dtml-sqlgroup where> <dtml-if ID> "URL"."ID" = <dtml-var ID sql_quote> </dtml-if> <dtml-and> .... Dieter

2 7

remote superuser mode
by Andrei Belitski 15 Mar '01

15 Mar '01

Hi! What I actually wants is to get the management interface using another machine as the machine ZOPE is installed on. When I write my superuser password on a remote machine zope doesnt accept it (only on zope local machine) Where can I change the remote access in superuser mode attributes? Thank you in advance

1 0

RE: Authenticating against NT domain from NT-based Zope
by Capesius, Alan 15 Mar '01

15 Mar '01

Look at http://msdn.microsoft.com/library/psdk/winbase/accclsrv_9cfm.htm The win32security is a wrapper for the MS Net API. you can search from the main page for other API functions or download the SDK. I have had the jcNTUserFolder working against a BDC, but haven't tried local machine. Try using the machine name "." instead of the actual machine name. Alan Capesius, MCSE/NTCIP+20 http://twsite.bizland.com/zopetips.htm >>>Message: 5 >>> Date: Thu, 15 Mar 2001 15:01:59 +0000 (GMT) >>> From: Ian Sealy <Ian.Sealy(a)bristol.ac.uk> >>>Subject: Authenticating against NT domain from NT-based Zope >>>What am I doing wrong? Can anybody point me towards some >>>documentation >>>for win32security? Can anyone point me to some documentation for the >>>win32security.NetUserChangePassword function mentioned by Chris >>>McDonough at >>>http://classic.zope.org/pipermail/zope/1999-October/013032.html ? >>> >>>Cheers, >>>Ian >>>

1 0

python9 conference presentations?
by Tom Jenkins 15 Mar '01

15 Mar '01

Hey folks, I've been looking (in all the wrong places ;) ) for the DC folks presentations from python 9 conference. I know Jim said he was posting his presentation template talk. Does anyone know where (or if) the DC folks have posted their presentations? TIA -- Tom Jenkins devIS - Development Infostructure http://www.devis.com

2 1