Re: [Zope] insert but updates don't work
+---[ 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 | > ancient version of Zope ? | | Using 2.1.3. Is this considered ancient? I would say yes at this stage. I wouldn't recommend any release below 2.2 any more, and 2.3 is coming RSN. While in terms of elapsed time it's not that long, web technology is moving pretty quick, and 2.2 closes some large security holes. | I have a work round, and now find what I was trying to do | has not succeeded in speeding up my queries :-( That's a bummer. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] insert but updates don't work
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 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. > > I thought this was fixed some time ago, do you have some > particularly > ancient version of Zope ? Using 2.1.3. Is this considered ancient? I have a work round, and now find what I was trying to do has not succeeded in speeding up my queries :-( -- Graham Chiu ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] insert but updates don't work
+---[ 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. I thought this was fixed some time ago, do you have some particularly ancient version of Zope ? -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] insert but updates don't work
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 one of the methods is using DTML which requires > higher > authentication privledges. > But I'm the superuser. When it fails the authentication, it says I don't have rights to access standard_html_header -- Graham Chiu ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] insert but updates don't work
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. > > If instead I do, eg, an insert into another table with each > value returned, it works fine. Is there something special > about sql updates? There shouldn't be, are you using DTML in both methods? If so, I suspect one of the methods is using DTML which requires higher authentication privledges. -Michel ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )