[Zope] sqlsession and postgresql

Shortie Lo shortie@vbc.com.tw
Wed, 22 Mar 2000 20:59:11 +0800


i have installed sqlsession product and only change sqlSessionCreate as

insert into sessions ( session ) values ( nextval('sessions_session_seq')
:: varchar )

i have tried code block from How-To: Using SQLSession. everything seems to
work
except <dtml-call "SESSION.clear()">.

traceback:

Traceback (innermost last):
  File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py,
line 214, in publish_module
  File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py,
line 179, in publish
  File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line
202, in zpublisher_exception_hook
    (Object: ElementWithAttributes)
  File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py,
line 165, in publish
  File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py,
line 160, in mapply
    (Object: sessiontest)
  File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py,
line 102, in call_object
    (Object: sessiontest)
  File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line
150, in __call__
    (Object: sessiontest)
  File
/home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py,
line 502, in __call__
    (Object: sessiontest)
  File
/home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py,
line 335, in eval
    (Object: SESSION.clear())
    (Info: SESSION)
  File <string>, line 0, in ?
  File
/usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py
, line 172, in clear
  File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py,
line 408, in __call__
    (Object: sqlDeleteValue)
  File
/home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py,
line 186, in _argdata
    (Object: sqlDeleteValue)
Bad Request: (see above)

 --
'Life is like boxes of chocolate, Forrest. You never know what you're
gonna
get.' -- Forrest Gump (1994)
Lo Chung-Chang (shortie) shortie@ms14.hinet.net http://shortie.vbc.com.tw/
ICQ#27118251
Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe