- Zope - Zope lists

Date/Time - DTML - SQL question
by chalaouxf＠synbio.tpgnet.net 15 Feb '99

15 Feb '99

<color><param>0100,0100,0100</param>Hi All, In the following sql method I select records with 'date' (a float field) superior to an 'dayfloatdate' float field. 'dayfloatdate' is just the date of the day in the float fomat (i.e. 19990215.0) How is it possible to construct '</color><FontFamily><param>Times New Roman</param><bigger>dayfloatdate' before sqlmethod call cause construct 'dayfloatdate' in the sql method seems difficult for me :)<color><param>0100,0100,0100</param><FontFamily><param>Arial</param><smaller> ----------------------- SQL method ----------------------- <FontFamily><param>Times New Roman</param><bigger>select * from table where date > < Bye, FR.<FontFamily><param>Arial</param><smaller> François-Régis Chalaoux Bioinformatics Group Synthélabo Biomoléculaire 67080 Strasbourg Cedex FRANCE Tél : 03 88 60 87 14 Fax : 03 88 45 90 70

1 0

Re: UserDB: docLogout, LoginRequired traceback.
by Anthony Baxter 15 Feb '99

15 Feb '99

> Can someone tell me what the docLogout page does? How does > it get called? I'd like to have the ability to flush the > cookie from the users system (useful for when they're on > a shared system)... ok, I dived into the code for this one... docLogout can be called as acl_users/docLogout, and it will set the magic login cookie to the string "deleted". This is good. > Also, when using cookie-based auth, the docLogin page gets > a LoginRequired exception traceback scribbled below it - is > there any way to fix/stop this? This, I still don't know... On a more fundamental note, I'm trying to mix UserDb and normal User Folders, and I'm not having a lot of luck working out how it works. Let's say I have the following layout of folders: interface/ top/ user/ admin/ top contains generic DTML, SQL methods, and the like, for use by both users and admins. Users have a home page of interface/top/user, which looks in the "user/" folder for configuration information (like what links they are presented with). admins have a top page of interface/top/admin. This has a different set of configuration items (a tinytable, other bits). Now, in the top/ folder, I've created both admin and user roles, and I've put a UserDb in it. I initially wanted to have the UserDb in only the user/ folder, with the assumption that acquiring objects from the top/ folder would "just work" without defining the users in the top/ folder... This didn't work (no idea why, anyone?). I would still like to also have a separate User Folder in the admin directory, since administrative accounts are not stored in the SQL database used by users. But no matter what I do, I always get prompted with the docLogin screen from the top/ UserDb. Thanks for any help with understanding this stuff :) Anthony.

1 0

UserDB: docLogout, LoginRequired traceback.
by Anthony Baxter 15 Feb '99

15 Feb '99

Ok, since DC don't support UserDB, this is addressed at everyone else: Can someone tell me what the docLogout page does? How does it get called? I'd like to have the ability to flush the cookie from the users system (useful for when they're on a shared system)... Also, when using cookie-based auth, the docLogin page gets a LoginRequired exception traceback scribbled below it - is there any way to fix/stop this? Thanks, Anthony

1 0

Dicts in folder attributes
by Shaw, Howard 15 Feb '99

15 Feb '99

Paul told me how to extract a list of column names from a returned SQL result. Now I need my DTML document to have ready access to a dict mapping the potential names to human-readable names, so that whichever columns show up in my result, the DTML knows how to display it. Basically where my table could contain column names like 'DOB' I want to display 'Date of Birth', but without actually knowing whether 'DOB' is present in the output prior to rendering the page. Therefore I want to make a dict like {'DOB':'Date of Birth','SSN':'Social Security Number',...}. But since this is not really data that is solely relevant to that single DTML document, I would rather not have to specify it by an ugly . Is making an External Method class and assigning the results to map to that class my only option? I would prefer a folder attribute, because an External Method requires me to go back to the filesystem to change it; but folder attributes don't seem to have dict as an option. Any ideas would be appreciated. [Note: this would be much easier if there was a non-containing version of 'with'. Something that edited the actual namespace, instead of making an altered namespace available to its contents. It would be much easier to pull in sets of variable references from other DTML documents.]

3 2

Re: Zope digest, Vol 1 #145 - 30 msgs
by Kent Polk 14 Feb '99

14 Feb '99

> From: Mike Pelletier <mike(a)compar.com> > Subject: [Zope] Using __repr__ and DocumentTemplates > > I have an object I would like to be able to render with a DTLM tag like > this: [...] > If I view a page which attempts to render an instance of this class, it > raises a KeyError, indicating that it doesn't know what 'id' in the DTML > refers to. If I change the line to: > > repr = HTMLFile("template") > > and view it explicitly from my browser, I get the results I am expecting. This appears to be related to my earlier, similar question whereby a method which is referenced directly called can reference its object's id, but an indirectly referenced method cannot. I'm still stuck. Kent

1 0

BoboPOS and nested dictionaries
by Jeff Bauer 14 Feb '99

14 Feb '99

Hi all. I'm having a slight problem with BoboPOS and nested dictionaries. BoboPOS 2.0.2. The problem is that changes to a nested dictionary attribute are not being saved. Here are two of my workarounds, discovered just this morning. # Dictionary deletions not saved. Workaround: Delete # the dictionary item, make a shallow copy to a new # dict, and reassign the object attribute to it. del self.treatment_orders[treatment] d = {} for k,v in self.treatment_orders.items(): d[k] = v self.treatment_orders = d Next, to assign a dictionary sub-element, I would usually perform the following kind of operation: self.treatment_orders[treatment]['FREQ'] = frequency However, the changes aren't saved unless I borrow Python's deepcopy feature, and reassign the attribute to the dict copy. from copy import deepcopy d = deepcopy(self.treatment_orders) d[treatment]['FREQ'] = frequency self.treatment_orders = d Before I spend more time on this issue, I'd be interested in learning if there are any known problems with nested dictionaries in BoboPOS. Environment: Python 1.5.2a2, linux2 Best regards, Jeff Bauer Rubicon, Inc.

2 2

Re: [Zope] Hiding Products
by Stefan Franke 14 Feb '99

14 Feb '99

Mike Pelletier wrote: > Jim was (after taunting me for no reason I can tell) very helpful in pointing out that Folderish classes can have their own > meta-types tupple, just like in the __init__.py file, which makes those meta-types unique to that kind of Folderish class. I > haven't tried it yet, but I thought someone else might like to know. Can you post Jim's, errr Paul's <wink> original mail to list in the case it contains more information than your posting, since I'm quite interested in this topic? Stefan

2 1

ZSybaseDA problem
by WWW Admin 14 Feb '99

14 Feb '99

hi all, anybody have an idea where i can find that libtli library which is required by ZSybaseDA and appearently isn't part of sybase open client for linux. i really want to try out tying sybase for linux into zope and would greatly appreciate if anybody could help me solve this problem. regards, webman --------------------------------------------------------------------------- webman | _ beehive GmbH | ASCII ribbon campaign ( ) berlin, Germany | - against HTML email X http://www.beehive.de | & vcards / \

2 1

Re: [Zope] RE: sendmail and variable mailto
by Jeffrey P Shell 14 Feb '99

14 Feb '99

> This won't do. I really need to be able to send mail using only the > received variable, and no folder properties; at least no dynamic ones. the REQUEST variable has the attribute 'form', which contains only the passed-in values in a form. For example,  will _only_ get the email address from the form. I don't understand why you're trying to set the folders property if it constantly gets overwritten with each request. In any case, if two people access a page at the same time and that page modifies a property, the transaction (the entire process from when Zope recieves the REQUEST to when it sends out RESPONSE) is atomic. That is, if Person A hits first, all of his transactions will be carried out and used beforer Person B can. Unless you're using ZServer, Zope really only handles one request at a time. In regards to what I think you're trying to do with the sendmail tag, you don't have to use the 'mailto' and 'mailfrom' parameters. The only parameter you really need is the ID of the mailhost or the IP address of the SMTP host. To do dynamic to's and from's and even subjects, do the following:  to:  from:  subject: congratulations on your furby addiction! message  The sendmail tag process all the headers and uses the "to" and "from" headers evaluated values if mailto and/or mailfrom aren't set. If mailto and mailfrom are used, they don't necessarily show up in the message when its recieved as the mailto and mailfrom values are used to talk with SMTP. It's important to note that the headers and the body of the message must be seperated by a blank line. You can use any header in the header area you wish (like x-mailer: Zope_Is_King 1.10), Zope only cares about the to and from values. And again, only if the mailto/mailfrom parameters aren't in the tag itself. The code in the sendmail tag is rather old and we're open to new patches/mods people make (like using SMTP lib!). The mailto/mailfrom/subject parameters currently only evaluate their values as strings and don't look them up from the namespace. .jPS | jeffrey(a)digicool.com | http://www.zope.org/

1 0

RE: sendmail and variable mailto
by Shaw, Howard 13 Feb '99

13 Feb '99

Well, I see in the earlier 'Hiding Products' discussion how to set folder properties. But that makes me wonder... What happens when two people hit my page at the same time? Each enters their data, including an email, and reach the response page at about the same time. The contents of the pages are uniquely rendered, but surely their interactions with folder properties could cause some weird overlap, like this: A requests the page. B requests the page. Zope starts processing A's page. Zope sets the folder attribute based on A's email address Zope starts processing B's page. Zope sets the folder attribute based on B's email address Zope sends mail for A to current folder address - which is B's address. Zope sends mail for B to current folder address - which is B's address. A gets no response. B gets two responses. This won't do. I really need to be able to send mail using only the received variable, and no folder properties; at least no dynamic ones. Please help.

1 0