Re: [Zope] insert but updates don't work

2000-11-05 Thread Andrew Kenneth Milton
+---[ Graham Chiu ]-- | | > You don't have 'permissions' to an update, this is a ZSQL | > perms problem. | > You might need to give your update method a 'proxy' role | > to fix it. | > | > I thought this was fixed some time ago, do you have some | > particularly | > ancien

Re: [Zope] insert but updates don't work

2000-11-05 Thread Graham Chiu
On Mon, 6 Nov 2000 11:20:12 +1000 Andrew Kenneth Milton <[EMAIL PROTECTED]> wrote: > *This message was transferred with a trial version of > CommuniGate(tm) Pro* > +---[ Bowyer, Alex ]-- > | > but get an authentication challenge that I can not > pass. > | > Is there someth

Re: [Zope] insert but updates don't work

2000-11-05 Thread Andrew Kenneth Milton
+---[ Bowyer, Alex ]-- | > but get an authentication challenge that I can not pass. | > Is there something special about sql updates? You don't have 'permissions' to an update, this is a ZSQL perms problem. You might need to give your update method a 'proxy' role to fix it

[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

Re: [Zope] insert but updates don't work

2000-11-04 Thread Graham Chiu
On Sat, 04 Nov 2000 13:05:08 -0800 Michel Pelletier <[EMAIL PROTECTED]> wrote: > > There shouldn't be, are you using DTML in both methods? Yes. It's the same method, I just change the inner zsql statement. The one with the update fails, the one with the insert is okay. > If so, I > suspect o

Re: [Zope] insert but updates don't work

2000-11-04 Thread Michel Pelletier
Graham Chiu wrote: > > I have this rather curious problem with Zope 2.1.3 on WinNT. > > I have a zsql query which returns a number of records. I > want to do an update on the same table that is being queried > for each record returned, but get an authentication > challenge that I can not pass.

[Zope] insert but updates don't work

2000-11-04 Thread Graham Chiu
I have this rather curious problem with Zope 2.1.3 on WinNT. I have a zsql query which returns a number of records. I want to do an update on the same table that is being queried for each record returned, but get an authentication challenge that I can not pass. If instead I do, eg, an insert i