[Zope] SQLSession help needed!

Sat, 20 Nov 1999 00:02:39 -0500

I did get my SQLSession installed. Thank you Harry.  However, I am
having trouble getting the SESSION.set(...) to work.
Here is the code I am using.

<html>
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>
</html>

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.