in reply to Storable Problems

There's nothing wrong with a line feed in a value being used in an SQL statement. The code probably uses DBI placeholders.

Replies are listed 'Best First'.
Re: Re: Storable Problems
by dstar (Scribe) on Aug 17, 2001 at 04:35 UTC
    Yup, it uses placeholders. The error message I get is 
    DBD::Pg::st execute failed: ERROR:  Unterminated quoted string at /usr
+/local/share/perl/5.6.1/Apache/Session/DBIStore.pm line 150.
DBD::Pg::st execute failed: ERROR:  Unterminated quoted string at /usr
+/local/share/perl/5.6.1/Apache/Session/DBIStore.pm line 150.
[Wed Aug 15 21:50:09 2001] [error] Error! DBD::Pg::st execute failed: 
+ERROR:  Unterminated quoted string at /usr/local/share/perl/5.6.1/Apa
+che/Session/DBIStore.pm line 150.
    (in cleanup) DBD::Pg::st execute failed: ERROR:  Unterminated quot
+ed string at /usr/local/share/perl/5.6.1/Apache/Session/DBIStore.pm l
+ine 150.

    [download]
[reply]
[d/l]
      You are using an older version of Apache::Session. The new version doesn't have a file called DBIStore.pm. Can you try upgrading to 1.53?
[reply]
        Bingo. Somehow when I did 'install Apache::Session' it picked up 1.03.....I'm now storing things in the table in the DB. Unfortunately, that's *all* it's doing -- it's never retrieving.

        Still, step by plodding step I'm making progress.

[reply]

In Section Seekers of Perl Wisdom