- Zope - Zope lists

RE: [Zope] Question about dtml-var, "null=", and data types
by Passin,Thomas B. (Tom) 10 Sep '02

10 Sep '02

[ Jean-Francois.Doyon] > > I have a tag as such: <dtml-var DMT_S_E null=N/A> > > DMT_S_E is a variable that comes from a SQL Method with a > PostgreSQL backend. DMT_S_E is of pgsql data-type "float8". > > Yet, for some reason, when I do <dtml-var "_.int(DMT_S_E)" > null=N/A>, I get an error about not being able to convert it > to int. This is where the value is null, and therefore "N/A" > gets displayed. > > So, does this mean that the "null" value has to be of the > same data-type as the variable itself? _.int() will convert a string or number to an integer, but a null is not a string or number. If you are just displaying the data (as with dtml-var), you do not really have to convert it into an integer anyway. This would avoid the problem. If you need to do some formatting, you ought to be able to do it with a formatting string rather than trying to convert to in integer. Also, once you work out what you want to do, you will want to use null="N/A", since the argument of null must be a string. Cheers, Tom P

1 0

using expr inside sendmail
by Mike Doanh Tran 10 Sep '02

10 Sep '02

Hi, Assume A=5, B=3, and C=2. when I use this expression outside of the <dtml-sendmail> tag then I get a Total="10" Total = <dtml-var expr="A+B+C"> But when i use the above expression inside of <dtml-sendmail> </dtml-sendmail> I get the value of A,B,and C (5 3 2) I just want to send out the grand total of A,B, and C. What is wrong with my syntax? Can someone help please? Thanks, -- Mike Doanh Tran Shuffle Master Inc.

2 2

How to get the owner of an object?
by Borislav 10 Sep '02

10 Sep '02

I was unable to find the method to get the owner of an object through the Zope APIs. Any info will be appreciated. --Borislav

3 4

Question about dtml-var, "null=", and data types
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 10 Sep '02

10 Sep '02

Hello, I have a tag as such: <dtml-var DMT_S_E null=N/A> DMT_S_E is a variable that comes from a SQL Method with a PostgreSQL backend. DMT_S_E is of pgsql data-type "float8". Yet, for some reason, when I do <dtml-var "_.int(DMT_S_E)" null=N/A>, I get an error about not being able to convert it to int. This is where the value is null, and therefore "N/A" gets displayed. So, does this mean that the "null" value has to be of the same data-type as the variable itself? If so, this isn't documented in the DTML Reference. I don't want to use "0" (Zero) as this would not be accurate. Is there an easy alternative, or am I going to have to use an if-then statement? Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410

1 0

RE: [Zope] PCGI and WebDAV?
by Greg Fischer 10 Sep '02

10 Sep '02

I did most searching with results on Google. I didn't find anything in the list archives. After pages and pages of browsing on it, I found a page noting that Apache wants to take over the WebDAV requests. It also stated that there is a workaround, but didn't state what or where it is. I found the mod_cgi patch here: http://www.zope.org/Members/Brian/Misc/mod_cgi_webdav_patch.html I have been unable to apply the patch to the mod_cgi.c file. I am not a C++ programmer, but I am guessing it's because I have Apache 2.0.39 and the patch was dated from 1999 on an older version of mod_cgi. OR, maybe because I am doing this all in Windows. I read the Apache docs, searching for anything with directives pertaining to the HTTP OPTIONS problem with mod_cgi as described in the link above. I didn't find any new options or patches. Apache(on Win32) is doing NTLM authentication for me. Zope(on Win32)is setup in REMOTE_USER mode with the access file in the server root. The user accounts now have no passwords because of that. I like the way it works on my Intranet. My users can open there browser and I know who they are based on there windows logon. (This works great since we all have Win2000) It appears that since Apache is doing the authentication, then Zope has no way of knowing who I am if accessed directly, so I can't just bypass Apache. I will continue to search, and will include the Apache lists as well. If you have any ideas to get WebDAV working through Apache or could point me in the right direction, I would appreciate it. Thanks! Greg -----Original Message----- From: Andreas Jung [mailto:zopyx@t-online.de] Sent: Monday, September 09, 2002 8:49 PM To: Greg Fischer Cc: zope(a)zope.org Subject: Re: [Zope] PCGI and WebDAV? This is a FAQ. Please check the mailing list archives. -aj On Mon, Sep 09, 2002 at 05:17:43PM -0700, Greg Fischer wrote: > I just setup Apache on Win2000 with PCGI access to Zope. I am using > > mod_auth_sspi to authenticate users. It works great, but I ran into > > a problem. How do I get my WebDav to work now? > > In order to setup Apache to authenticate you must put the server > > into REMOTE_USER mode. I noticed that the users I create in Zope > > now do now have passwords anymore. This is fine, Apache is taking > > care of that, but, now Zope wont authenticate by itself. > > This is what I used to setup the authentication. > > <Location /cgi-bin/Zope.cgi> > > AuthType SSPI > > SSPIAuth On > > SSPIAuthoritative On > > require group "DOMAIN\GroupName" > > </Location> > > > > If I add the DAV portion to Apache, it still wont work. The errors > > say "Unable to Authenticate." > > I do have the mod_dav enabled. I added this to the Location above: > > DavLockDB c:/temp/davlock > > Dav on > > Thanks for any help you may have. > > Greg Fischer > > sysman(a)techgroupinc.com > _______________________________________________ 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

SQL prob on SAPDB
by Vitor Varalonga 10 Sep '02

10 Sep '02

Hi! I need to copy the data from one table to another, on my SAPDB database. If I where working with a SQL Server DB I would run the following query: INSERT INTO TableB (fieldB1, fieldB2) SELECT fieldA1, fieldA2 FROM TableA ORDER BY fieldA1 But it seems that it doesn't work on SAPD, since it returned me the following error message: Database error occured: Native error: -5015 Text: [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5015 POS(191) Missing keyword:GROUP,OR,MOD,HAVING,DIV,AND,UPDATE,UNION,REJECT,INTER. Sorry for the somehow off-topic non-zope question, but I would really appreciate if someone could please enlighten on this. kind regards, Vitor Varalonga

2 1

Re: returning related objects
by VanL 10 Sep '02

10 Sep '02

Hello, You said: > >/ I want to do queries like: /> >/ "Who are the managers that look over Golden Delicious Fields?" /> >/ "What kinds of apples are grown in the Valley Orchard?" /> >/ /> >/ Currently, I am trying to do a zcatalog query for the known item (say, /> >/ the Orchard) and then run up or down the acquisition chain to retrieve /> >/ the unknown, but related quantity. /> >/ /> >/ Is there an easier way to do this? One of the things that I like about /> >/ Zope is the ability to store objects in their natural hierarchies. Can /> >/ I use that to get information about objects that are related to my /> >/ current object? /> >/ /> >/ Thanks, /> >/ /> >/ VanL /> > have a look at ZCatalogs-PathIndex... with some python-logic you should > be able to do this kind of questions. I have been trying to do figure it out with the path, but I am still not able to. Any suggestions or sample code? Thanks, VanL

2 2

actually getting into it.
by harry lee 10 Sep '02

10 Sep '02

I'm building a product called mcp: music control program: it will be front end to my shoutcast server and my audiotron. \Initially, I created a zclass called cdclass, but it seems to me I might want to have classes for: artist, title (where title is more or less cdclass) and track. In looking at the book class in the zopebook, analogously, there should be author and publisher classes. I understand they were trying to keep it very simple. can antone give me any pointers on how you'd go about this?

2 1

We're being censored! Kinda. (Was: RE: Offensive Email - RE: [Zope] Some basic questions on Zope performance/scalability)
by Charlie Reiman 10 Sep '02

10 Sep '02

I just sent that little joke about Fred being Jane and I got this creepy response from some over-protective server in New Zealand. > -----Original Message----- > From: fw_admin(a)airnz.co.nz [mailto:fw_admin@airnz.co.nz] > Sent: Tuesday, September 10, 2002 9:15 AM > To: creiman(a)kefta.com > Subject: Offensive Email - RE: [Zope] Some basic questions on Zope > performance/scalability > > > This message has not been delivered. It potentially contains one > or more words that could be considered offensive. Please request > the sender to resend without any potentially offensive words. > > Message: B00050725b.00000001.mml > From: creiman(a)kefta.com > To: mike.stevenson(a)airnz.co.nz > Subject: RE: [Zope] Some basic questions on Zope > performance/scalability > > If you feel this is in error, please contact the Service Desk > (+64 9 3065222) Ext 65222 to organise its release. > I hardly think I've sent any offensive email to the list. Off-topic and irrelevant, sure, but not offensive. Most interesting is that it doesn't send you the offensive email or note what the offensive words are. After studying my email, I think it is triggering on the word 'blow' in 'joeblow', though it might as well be triggering on 'Internet'. Obviously, this block is on Mike's email, not the list's so it's not that heinous. I find it chilling but on the plus side, Mike's delicate sensibilities will be protected.

3 2

mysterious periodic crashes
by Matthew T. Bell 10 Sep '02

10 Sep '02

Hi -- I have been having a problem where a Zope server I am running periodically (as in every couple days) crashes whenever a user tries to access an external method. Initially it returns the error "(external method) file does not exist)", and then all the Zope programs terminate, making the website inaccessible. Restarting seems to solve the problem. Does anyone know what might be causing this and how I could prevent it from occurring? Thanks, Matthew Bell Graduate Student University of Pittsburgh

1 0