Ok, all weekend I've been chasing my tail. Now I scream for help... I cannot get SQLSession to insert values into the zsession_data table to save my freeking life. I'm not getting errors of any kind, just no inserted session data. However, the zsessions table shows the sessions being created, so that table is working ok. I mangled the SQL syntax for sqlSetValue, *then* I got a pg. error, so sqlSetValue *is* running, yes? I installed Logger and logged the values from sqlSetValue to the zope log. I cut and pasted those values from the log into the test query screen for sqlSetValues and when I submit the query it inserts just fine. At that point I can see the manually inserted values from session_test.dtml, so sqlGetValues is working. But if I try to insert values with session_test, they show up in the very next screen, but are gone thereafter and of course they do not show up in the database. I'm really at quite a loss here. I made sure to give SQLSession its very own ZPyGresQLDA connection. After beating on that unsuccessfully for awhile, I installed ZPoPyDA, and set SQLSession to use that, which of course didn't change anything. Here's the version particulars: Zope version: Zope 2.1.6 (source release, python 1.5.2, linux2) Python version: 1.5.2 (#1, Sep 17 1999, 20:15:36) [GCC egcs-2.91.66 19990314/Linux (egcs- System Platform: linux-i386 ZPyGreSQLDA 0.3 ZPoPyDA 0.5.1 PoPy 1.3.2 beta SQLSession 0.3.0 PostgreSQL 7.0.2 Other installed products (if it matters...): ZPyGreSQLDA Fortune Calendar Logger Photo ZPatterns Confera LoginManager SQLSession ZPoPyDA WorldPilot iTrack Mild rant: I've got a big, scary, and now behind schedule database-enabled website to build for a client. Most everything I've read, and even my earlier, simpler experiences with Zope have been fantastic. I've been going on to my client about how great Zope is, rapid deployment, etc, blah. So I committed, but after fighting with LM (It took weeks to get it working once and I have not been able to duplicate that feat since), a failed upgrade to Zope 2.2 (LM wouldn't work there yet(?), doh!), and now SQLSession... I'm *not* having an overall good feeling about all this. I'm even starting to get thoughts of retreating to Perl or learning PHP3 and never looking back. But I really want to get over what's probably mostly newbie learning curve & lack of docs and make this work in Zope. Please help!!! -cw- -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Charlie Wilkinson - cwilkins@boinklabs.com - N3HAZ Parental Unit, UNIX Admin, Homebrewer, Cat Lover, Spam Fighter, HAM, SWLer... Visit the Radio For Peace International Website: http://www.rfpi.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLOBBER INTERNET SPAM: See!! <http://spam.abuse.net/> Join!! <http://www.cauce.org/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ QOTD: Failure is not an option. It's bundled with your software.