[Zope] insert but updates don't work

[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.
> 
> 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