[Zope] SELECT ... AS ... statement in ZSQL

2001-01-07 Thread Bowyer, Alex
A simple question, but I can't seem to find a simple answer in any of the documentation... How do you do a SELECT AS statement in a ZSQL method? For example SELECT FirstName + " " + LastName AS FullName Whenever I use AS, I end up getting the SQL error "Two few parameters: x expected" where is

[Zope] Advice on searching/indexing Word documents?

2001-01-02 Thread Bowyer, Alex
Our company has a repository of staff CVs (Resumes) as Word Documents and I am about to embark on creating a new feature for our Zope Intranet to allow project managers to search those documents for keywords such as particular skills or projects. I am thinking about several possibilities such as

[Zope] security

2000-11-26 Thread Bowyer, Alex
Can some one explain how the Define Permissions screen works. I really don't understand the concept behind it, what does it mean for a permission setting to own a permission? All I need to do is to make certain ZClass methods have a certain level of security and the other methods of the class

[Zope] security problems .. should be fairly easy...

2000-11-20 Thread Bowyer, Alex
I know I am posting quite a lot of questions to the list lately, sorry about that, it's just that I can save myself hours of trial-and-error coding when I get quick answers from list, so I hope you don't mind. It seems to be the fastest way to learn. I have a news page ZClass and a news article

[Zope] security problems

2000-11-16 Thread Bowyer, Alex
I am having some problems with getting the right security settings for my ZClass. I have one method index_html which should be viewable by anonymous. All other methods should only be viewable when a username/password is entered for someone with the role I have called UAAdmin One thing that is

[Zope] modifying objectValues from an external method?

2000-11-15 Thread Bowyer, Alex
You may remember I have posted a couple of times about problems I have had with manage_delObjects to delete a news article object from a news page which contains several child news article objects. I thought I would try and avoid the problem and make a Python method to remove the item. This

[Zope] How to maintain an up-to-date mirror site in Zope? (not-so-newbiequestion!) question!)

2000-11-13 Thread Bowyer, Alex
Here is the situation, can you offer advice? Machine A is running a Zope server for a wide-area network in Company A. This is an Intranet site which changes regularly. Machine B serves a separate wide-area network in Company B, and Company B employees need access to Company A's intranet. The

[Zope] Newbie question(s)

2000-11-12 Thread Bowyer, Alex
Hi, I have what I'm sure is a very simple question about Zope programming style: I want to count how many objects are contained in the current container object and then do something with that value, but I can't do the bit I need to do at the point of reading the count variable because I am in

RE: [Zope] Newbie question(s)

2000-11-12 Thread Bowyer, Alex
I want to count how many objects are contained in the current container object and then do something with that value, but I can't do the bit I need to do at the point of reading the count variable because I am in the wrong namespace. I would try and do it like this (untested):

RE: [Zope] Help wanted on Zope ZClasses/DTML please.

2000-11-06 Thread Bowyer, Alex
d I need to pass in the value of the_id not the name of it. Ideally I want to say dtml-call "manage_delObjects(REQUEST['id_to_delete'])" but again this fails to find the object. Any ideas? Thanks for helping, Alex -Original Message- From: Seb Bacon [mailto:[EMAIL PROTECTED]]

[Zope] insert but updates don't work

2000-11-05 Thread Bowyer, Alex
but get an authentication challenge that I can not pass. Is there something special about sql updates? I haven't used SQL in Zope but I experienced the same thing, an authentication request that cannot be satisfied even by the superuser account. For me I found that it happened when I was in a