[Zope-dev] SQLSession help needed!

[Clayton Miller]

I have posted this message on the Zope maillist but I did not get a good
answer. So I decided maybe some real Geeks hang out here instead. I am
having trouble getting the SESSION.set(...) to work.
Here is the code I am using.

<dtml-comment>
-----code starts here --------
ZipCode = <dtml-var ZipCode>
Distance = <dtml-var Distance>
<dtml-var "SESSION.set('myZipCode', ZipCode)">
<dtml-var "SESSION.set('myDistance', Distance)">
<frameset cols="30%,70%">
<frame src="<dtml-var Root>/Menu" name="Menu">
<frame src="<dtml-var Root>/Main" name="Main">
</frameset>
-----code ends here -------
</dtml-comment>

Here is the error I am getting:
!

                 Temporarily Unavailable

                 The resource you requested is temporarily unavailable -

please try again later.

(116) unable to connect, fd=5

If I <dtml-comment> out the SESSSION.sets on down. I do see the values
of Zipcode and Distance working correctly.

I am connecting to a Postgresql database. Zope/Apache/Postgresql are all

running on my Linux box.  I have created the Sessions and Session_data
tables as prescribed. I have included a <dtml-call Session> in my
standard_header_html file. Just to see if the code was working at all, I

modified the SQLSession.py:__init__ routine to put the sessionName into
the Session_data table. I can see this information just fine using a
<dtml-var "REQUEST['SESSION']"> command.  This shows one key called
session (this is the name I gave it in __init__) and the value of
sessionName (the value I assigned).
This is the type of error I have received plenty of times when the SQL
statement was incorrect somehow. Just how do you debug this error? I
looked at standard_error_html and I do not see this error text. How do
you find out which object /line is causing the problem?
Thank you for the help.
Clayton.