May 2003 - Zope - Zope lists

setting date to Null in MS SQL?
by Kelley, Sean 21 May '03

21 May '03

I have a simple app where I need to let people set dates to null via a form. I am trying to test for an empty form field and set the value to NULL if empty. It seems to work on form submission but when I do a database query I see it is actually set to 1/1/1900 I have found a way to update a record if it already has a value and you clear the form field, but for some reason this same method does not work for an initial insert. In both of my sql methods I have: <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> What am I missing?

1 0

Can't save Version in 2.6.1, please help!
by Ken Causey 21 May '03

21 May '03

I know, I'm an idiot for using Versions, but they've worked reasonably well for me for a while and they are very handy for my situation allowing me to make modifications in the background and more or less instantaneously commit them for all to see. I have a Version I've been working in now for about 3 weeks. I've modified and/or created around 50 new objects. No matter what I do I can neither Save or Discard this version. I've tried doing while working in the version, while not working in the version. I've packed the database two or three times. I've gone through and while working in the version I've resaved every single modified object. Nothing I do will result in the version being saved. At this point I've even tried to discard the version so it will free up the locks on the objects and even that won't work. I'm using Zope 2.6.1 with Python 2.1.3. If there is any other information I can provide please let me know. I'm getting desperate for a solution to this. Help me this time and I swear I will never use Versions again. Ken Causey

4 6

How to get the value of form data in Page Template itself?
by saravanan annamalai 21 May '03

21 May '03

Hi All, I have a form in a page template. Submission of the form calls the same page again with some other parameters. I want to get the value of the parameter(form data) in the Page Template itself. Its very urgent for me... Hope somebody helps me regards saravanan A ___________________________________________________ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more.

3 2

ldapuserfolder
by Adriana Chirita 21 May '03

21 May '03

Hello I've installed LDAPUserFolder and it works great when I look for members in the LDAP Base. But when I try to enter my site authenticating under ldap, I've got a big bug in python.exe: "the instruction at "0x696d5320" uses the memory adress "0x696d5320". Memory can't be "read"" (sorry, it's translated from french...). I'm developping under windows 2000, with Zope2.6.1 and the latest version of plone, and the ldap server is an openldap 2.07 running under a woody machine. Does someone have an idea?

2 1

Dynamic Folders in <dtml-in>
by Dieter Fischer 21 May '03

21 May '03

Hello I have the following struture in my folders: sql - oracle - postgresql - odbc I've the idea to share most of the SQL-Methods via aqusition (they are in sql), but have the specific ones (not ANSI SQL) in the db folder (e.g Oracle with it's to_date function. I've tried this statement for an <dtml-in>: <dtml-set query="sql.oracle.browse()"> #1 See bottom <dtml-in "query" size=12 start=query_start> which works fine. I'd like to have it more dynamicly, so I tried: <dtml-set query_string="'sql.'+getDatabase()+'.browse()'"> #1 See bottom <dtml-set query="_.getitem(query_string)"> #1 See bottom <dtml-in "query" size=12 start=query_start sort="code,bez"> getDatabase is a Python-Script which get's the db for the folder (oracle,postgresql,odbc). But it doesn't find the object: Error Type: KeyError Error Value: sql.oracle.browse() This resource may be trying to reference a nonexistent object or variable sql.oracle.browse Anybody can give me an advice for the correct syntax? Thanks Dieter #1 I'm using the dtml-set tag, so <dtml-call "REQUEST.set(foo, 10)"> is: <dtml-set foo='10'>

5 8

Other content types and ZPT
by Jeremy Cook 21 May '03

21 May '03

Hi, I want to create a real audio metafile (.ram extension) on the fly using templates but am struggling with this. A .ram file should contain a single line with the URL of the media file that I want the client browser to play. I want to create this URL using ZPT so that the correct URL relative to the portal home is given. I don't want to use a hard coded URL because that would mean that my media content wouldn't work when I move my portal to another location for off-line editing. It would also mean that links could be broken in an obscure way some time in the future. If I create a 'page template' called 'RMTheJam.ram' with a simple line pointing (for now) to a hardcoded URL: http://217-13-29-76.dd.nextgentel.com/KSMi/interactive/TheJamBam.rm and then in the Page template editor change the content_type from text/html to audio/x-pn-realaudio then I get an error "cannot import name expat". Any ideas how to achieve a dynamic real audio metafile? I am running zope 2.6.1 Thanks, -- Jeremy Cook <Jeremy.Cook(a)ii.uib.no> Parallab

3 2

formulator form.header() problem
by Mark Nenadov 21 May '03

21 May '03

Hello all, I'm making a form with the latest version of Formulator. When I call form.header() it gives me a "mutilated" form header like so: <form enctype="multipart/form-data" method="POST" name="add_vehicle_form" action="addVehicleMethod enctype="multipart/form-data">" > It doesn't put the last quote after my action and it adds the enctype line again. This obviously causes problems. I've confirmed that I didn't make any mistakes in the form settings I'm using Zope 2.6.1 and Formulator 1.4.0. I'd appreciate any feedback. ~Mark

2 1

Zcatalog & KeywordIndex
by John Toews 21 May '03

21 May '03

I'm having some difficulties using my Zcatalog & my KeywordIndex within that catalog. I have a subdirectory of different files, each with a property called "repo_keywords". I created a KeywordIndex called "repo_keywords". When I search using this, I must enter the exact text within the repo_keywords property (instead of just one word or a phrase). Also, when I add a new file, I have to re-find everything in my Zcatalog, update catalog doesn't seem to work? (Win32, Zope 2.6.1, Python 2.1.3) Thanks, John Toews

3 2

How to Add a File Dynamically??
by Zope＠Stylus 21 May '03

21 May '03

Hi I am working on Zope-2.5.1 installed on Mandrake Linux 9.0. I am working currently on a small project that functions similar to the CMF but not completely covering all its features. I am basically trying to add a folder into the Zope Directory Structure and then trying to upload files into the newly added folder through my web interface (Not ZMI) While adding a new folder I would like to add 3 files by default into the folder (like when i add a folder object through ZMI) 1) index_html - (Page Template) 2) tree.py - (Python Script) 3) getPath.zsql - (ZSQL Method) My Backend is Postgresql 7.2.2. For adding Folders and Files intot the Zope Directory I am using External Methods which are functioning perfectly fine. But the main issue is that when I add a folder I want that three objects are added into the folder as well by default. a Python Script a Page Tenplate a ZSQL Method These three Objects should contain the code which is decided by me and is a constant in all folders like the code in index_html for all folders. The Zope folder Object accomplishes this ... when we add a folder if I select to add a User Interface .. a default page template is added called index_html. I also would like to do something exactly similar.Please help me out ... I m stuck with this for quite a few days now. Thanks for reading through the whole letter .. n thanks in advance for all Help. Best Regards John --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.481 / Virus Database: 277 - Release Date: 5/13/2003

4 4

Re: [Zope] Re: How to Add a File Dynamically??--manage_clone ERROR
by Zope＠Stylus 21 May '03

21 May '03

Hi Seb Thanks for the guidance. I am actually cloning Page Templates and Python Scripts to a newly added folder and the folder gets added using the manage_addFolder method. When i try to clone a Python Script and a Page Template I get the Error. I have set anaonymous User permission for Both the External Methods and the Python Scripts calling the External Methods( although I actually cannot do this setting on the fly as I adding the Python Scripts also Dynamically ) INspite of my setting thew Security Permission on the External Methods and Python Script to Anonymous and also setting the Proxy Roles to anonymous I am still being asked to Login to Zope . Please help me out. Suggestion on as to how I can acheive this functionality by some other means would also be most helpful ,i.e, Adding a Folder on the Fly (which I am being able to do) and cloning a Python Script and a Page Template into the newly added folder on the fly(which I am not able to do) ..Both these actions happen simulatneously and it has to happen without Logging into the ZMI. Please help. Thanks John ----- Original Message ----- From: "Seb Potter" <seb(a)getfrank.com> To: "Zope@Stylus" <zope(a)stylusinc.net> Sent: Wednesday, May 21, 2003 10:36 PM Subject: Re: [Zope] Re: How to Add a File Dynamically??--manage_clone ERROR : On Wed, 21 May 2003 22:26:20 +0530, Zope@Stylus <zope(a)stylusinc.net> wrote: : : > Hi Seb : > : > Could you please advice me as to how I can assign Proxy Roles or Enable : > anyone to be able to use the manage_clone Method.I do not want to Login : > to : > Zope but I want to use the Mehtod.How can I do this?? : > : > Thanks once again for the prompt reply : > : > Best Regards : > John : : : In the ZMI, go to your PythonScript. Click the "Proxy" tab. Select the role : you want to assign (probably "Manager") and then click "Save Changes". Your : script will now run as if it's being run by the administrator, but you : won't have to be logged in. : : Needless to say, be very careful about what your script does, because if it : does things like delete objects, when anybody will be able to delete them. : : Regards, : : - seb : : -- : Seb Potter : Lead Developer : Getfrank Limited : : --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003

2 1