- Zope - Zope lists

Best way to handle SQL update with variable number of fields?
by chris＠ncafe.com 10 Sep '00

10 Sep '00

Hello, I'm creating a number of ZSQL methods to insert, update and delete records from several Oracle tables. Everything is working fine with the insert forms (creating new records) and the delete (of course). However, the best way to do the * update * without locking the user into a *very* rigid format is eluding me.. The problem - I would like to populate the form with the existing values and then allow the user to change the ones they want to. Some of the fields in the database are empty and it will always be that way. The length of the update statement will change. Nomatter how I do it, I am having problems with the commas. What is the best way to build the necessary logic into the form? Is there a sample in a product or a How-to somewhere that I can look at? I am assuming I need to create a list externally in a method and use that to determine the comma placement. Is that the "correct" direction? Or is there a better way.. Thank you, Chris Beaumont cbeaumon(a)msri.org

2 1

Modification Posts to the list (was: [Zope] Import from file via management-interface)
by Dieter Maurer 10 Sep '00

10 Sep '00

Hi Tino (and other potential patch posters), if possibly, you should not post complete source modules to the list. Instead, you should use either context or uniform differences to the source. Such a difference file is called a patch. Patches have considerable advantages over the complete source: * they are much smaller * they can (usually) be applied to more than one version * they show directly what has been changed, this is essential for a decision whether or not to trust the changes. I will never install any source modules posted to the list. Usually, I will not even look at them. Patches can be created with the "diff" utility. This is a "standard" unix program (i.e. installed on any Unix system). There is an improved GNU version, which is also available for Win/32. There are other Windows implementations for "diff". Patches are applied with the "patch" utility. Again, there is a GNU version, and surely there are versions for Win/32. Dieter

2 1

Length of a list (was: [Zope] How does one display document count of a folder?)
by Dieter Maurer 10 Sep '00

10 Sep '00

sean(a)horse101.com writes: > I am using a script to display the contents of a folder, but I > wonder how I might display a document count of the dtml > documents in a folder? You want to get the length of a list, in your case the return value of "objectIds". This is a FAQ: you use "_.len(<list expression>)" or (insided a dtml-in) "<dtml-var sequence-length>". Dieter

1 0

Object from Object Id (was: [Zope] Get help about variable and entity of Zope.)
by Dieter Maurer 10 Sep '00

10 Sep '00

hanse(a)yeah.net writes: > With DTML,I define a variable AA, and let AA equal a object's ID, > HOW can I get the object's property through the variable AA? Maybe > need a function? > Need your help? > > I want to express as : > <dtml-call "AA.propertysheets.SUBJECT.manage_changeProperties > (Name=1)"> You have an object ID (in your AA variable) and you want to get the object accessible through this object ID. This is an FAQ: you use "_.getitem(<expression for id>)" in your case "_.getitem(AA)". Dieter

1 0

Changing list elements (was: [Zope] 2d list manipulation)
by Dieter Maurer 10 Sep '00

10 Sep '00

Tim Russell writes: > .... 2 dimensional list access and modification of elements .... > I can easily access the value of > an element using: > > <dtml-var "col[index1][index2]"> > > However, the difficulty comes when trying to change the value of one of > these elements.... There is no easy and safe way to do it in DTML (because a list does not have a method to replace a list element. If interested in a hack, you may look at the list methods "remove" and "insert"). The easiest thing is to write an external (or Python) method. Dieter

1 0

Folderish Properties
by Tim Cook 10 Sep '00

10 Sep '00

I have a folderish ZClass with a set of properties. When I create an instance via DTML my code doesn't update the properties from REQUEST. I use exactly (names changed of course) the same code to instantiate a document like ZClass and it works fine. So what's the difference between Folderish ZClasses & Document ZClasses in assigning to their properties? (The instance IS created, just the properties aren't assigned values.) I used the howto on adding instances via DTML change to the '_add' methods in both ZClasses. Here's the code FWIW: --- Document-'ish' --- <dtml-var standard_html_header> <dtml-call "REQUEST.set('id',REQUEST['med_name'])"> <dtml-call "REQUEST.set('title', REQUEST['med_name'])"> <dtml-call "REQUEST.set('online_lookup', REQUEST['online_lookup'])"> <dtml-call "REQUEST.set('indications', REQUEST['indications'])"> <dtml-call "REQUEST.set('contraindications', REQUEST['contraindications'])"> <dtml-call "REQUEST.set('warnings', REQUEST['warnings'])"> <dtml-call "REQUEST.set('alt_names', REQUEST['alt_names'])"> <dtml-call "REQUEST.set('dose_delivery', REQUEST['dose_delivery'])"> <dtml-call "REQUEST.set('doc_type', REQUEST['doc_type'])"> <dtml-with "manage_addProduct['FreePMProduct']"> <dtml-call "DrugClass_add(_.None, _, NoRedir=1)"> </dtml-with> <center> <H2><dtml-var med_name> was added.</H2> <p> <a href="formulary"> Back to Formulary Menu </a> </center> <dtml-var standard_html_footer> --- Folder-'ish' --- <dtml-var standard_html_header> <dtml-call "REQUEST.set('id',REQUEST['login_id'])"> <dtml-call "REQUEST.set('login_id', REQUEST['login_id'])"> <dtml-call "REQUEST.set('first_name', REQUEST['first_name'])"> <dtml-call "REQUEST.set('middle_name', REQUEST['middle_name'])"> <dtml-call "REQUEST.set('last_name', REQUEST['last_name'])"> <dtml-call "REQUEST.set('honorific', REQUEST['honorific'])"> <dtml-call "REQUEST.set('generation', REQUEST['generation'])"> <dtml-call "REQUEST.set('gender', REQUEST['gender'])"> <dtml-call "REQUEST.set('fda_number', REQUEST['fda_number'])"> <dtml-call "REQUEST.set('supervisor_id', REQUEST['supervisor_id'])"> <dtml-call "REQUEST.set('job_title', REQUEST['job_title'])"> <dtml-call "REQUEST.set('created_by', REQUEST['created_time'])"> <dtml-call "REQUEST.set('created_time', REQUEST['created_time'])"> <dtml-with "manage_addProduct['FreePMProduct']"> <dtml-call "ProviderClass_add(_.None, _, NoRedir=1)"> </dtml-with> <center> <H2><dtml-var login_id> was added.</H2> <p> <a href="providers"> Back to Provider Menu </a> </center> <dtml-var standard_html_footer> As Always - Thanks! -- Tim Cook -- FreePM Project Coordinator http://www.freepm.org OS Health Care Alliance Supporter http://www.oshca.org

1 1

keeping Java Servlets session ids based on url rewriting
by albert boulanger 10 Sep '00

10 Sep '00

I am using the latest Zope release using ZServer directly (but will be running under Apache....) I need to coordinate Zope based sessions and servelet sessions. We will be using url rewriting (I know use cookies, but we are doing worst case planning.). As you may know the rewritten urls that the servlet does look like http://foo/bar;$<id here>$. I need to retain the stuff after the ;. This seems to be dropped i think in ZServer. I was going to store the servlet sesssion id in a SQLSession object by having the servlet do a response redirect to a dtml method to process the id after the ;. Will Apache frontending and setting the CGI-vars fix this issue? A more general question, has anyone worked on the general cross-session issues like this? I think this is consideration item for the new session support in Zope. Regards, Albert Boulanger aboulanger(a)vpatch.com >From Zope: Try this http://www.zope.org/Members/aboulang/printresponse;fffff aboulang form cookies other AUTHENTICATION_PATH URL0 http://www.zope.org/Members/aboulang/printresponse TraversalRequestNameStack [] SiteRootPATH / VirtualRootPhysicalPath ('',) URL http://www.zope.org/Members/aboulang/printresponse AUTHENTICATED_USER Anonymous User SERVER_URL http://www.zope.org URL0 http://www.zope.org/Members/aboulang/printresponse URL1 http://www.zope.org/Members/aboulang URL2 http://www.zope.org/Members URL3 http://www.zope.org BASE0 http://www.zope.org BASE1 http://www.zope.org BASE2 http://www.zope.org/Members BASE3 http://www.zope.org/Members/aboulang BASE4 http://www.zope.org/Members/aboulang/printresponse environ HTTP_ACCEPT_ENCODING gzip, deflate channel.creation_time 968523573 SERVER_PROTOCOL 1.0 SERVER_PORT 1380 PATH_INFO /Members/aboulang/printresponse HTTP_HOST www.zope.org:1380 REQUEST_METHOD GET PATH_TRANSLATED /Members/aboulang/printresponse SCRIPT_NAME SERVER_SOFTWARE Zope/(unreleased version) ZServer/1.1b1 HTTP_ACCEPT_LANGUAGE en-us REMOTE_ADDR 209.67.167.55 SERVER_NAME localhost.localdomain GATEWAY_INTERFACE CGI/1.1 HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.01; Windows 98) HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*

3 2

ZClasses - Base classes
by Philipp Auersperg 10 Sep '00

10 Sep '00

I know that one cannot change the base classes of a ZClass after it has een created, but my question: How can I just find out / enmerate the base classes of a ZClass? thanks phil

1 0

RE: [Zope] 2d list manipulation
by Stephan Richter 09 Sep '00

09 Sep '00

At 03:40 PM 9/9/00 -0500, Tim Russell wrote: >That's the thing -- It doesn't give any errors, it just doesn't have any >effect on the value in the array. Weird, no? > >--Tim > > >Nope, still nothing... > > > > > > > > <dtml-call "REQUEST.set('col[index1][index2]', 5)"> > > > > > > > > Just try it without the single quotes: > > > > > > > > <dtml-call "REQUEST.set(col[index1][index2], 5)"> > > > > Can you send me the traceback? Thinking about it again makes me realize that it will not work, since set just sets a variable, but does not take care of assignments. It is a little bit hard to explain, maybe someone else can do a better job. Here is what you would have to do: <dtml-var standard_html_header> <dtml-call "REQUEST.set('a', [[0, 0], [0, 0]])"> <dtml-call "REQUEST.set('a1', a[0])"> <dtml-call "a1.insert(0, 1)"> <dtml-call "a.insert(0, a1)"> <dtml-var "a[0][0]"> <dtml-var standard_html_footer> This code is tested and works. But you will see that this is far too complicated, thats why I would suggest you use a Python Method or an Eternal Method to solve the issue. Regards, Stephan -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management

1 0

RE: [Zope] 2d list manipulation
by Tim Russell 09 Sep '00

09 Sep '00

Nope, still nothing... > > <dtml-call "REQUEST.set('col[index1][index2]', 5)"> > > Just try it without the single quotes: > > <dtml-call "REQUEST.set(col[index1][index2], 5)">

1 0