Re: [Cgi-session-user] Trouble with C::S::SQLite

[Mark S. <ma...@su...>]

On Mon, Mar 06, 2006 at 03:01:06PM -0600, Puneet Kishor wrote:
> 
> Mark, any suggestions how/what debugging to turn on besides the usual
> diagnostics and -w? Actually, I also ran the script through the debugger
> but wasn't any wiser. I should have added my code snippet in the above
> email in the first place... this is what I am doing (simplified just a
> tad bit) --
> 
> $DBH = DBI->connect("dbi:SQLite:dbname=/path/to/my.db") or die;

Using this $DBH handle, you can access the session table directly,
outside of CGI::Session?

  my @row = $DBH->selectrow_array("SELECT * FROM sessions");
  use Data::Dumper;
  warn Dumper (\@row);

That should return a single row from the session table for you.
If that doesn't work, your problem is more fundamental, not related to
CGI::Session. 

Also, you may want to 'grep' the test suite shipped with CGI::Session to
see the syntax that we are using with SQLite that is known to work.

	Mark