5 Jul
2001
5 Jul
'01
4:31 a.m.
From: "Lee" <lee.reilly@ntlworld.com>
The script appears to be connecting okay (well, it doesn't result in an error), but when I try and execute the SQL I am asked for my user/auth again, which isn't recognised and gives the following error:
result=db_conn.query(updatePersonSQL) =>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Unauthorized
There's no permission or other security declaration on the connection's query() method, so Zope security prevents you from calling it. You can edit the DB code to add security, or write an External Method that takes a connection and returns its query method (and possibly its sql_quote method as well, if you need it). Cheers, Evan @ digicool & 4-am