java.sql.SQLException: ERROR: parser: unterminated quoted string at or near "' - Mailing list pgsql-advocacy

From Timo Nentwig
Subject java.sql.SQLException: ERROR: parser: unterminated quoted string at or near "'
Date
Msg-id 1062002757.3827.47.camel@tcn.local
Whole thread Raw
Responses Re: java.sql.SQLException: ERROR: parser:
List pgsql-advocacy
Hi!

I download a web page and store the HTML in a String which I want to
insert:

PrepatedStatement p = new PreparedStatemetn("INSERT blah INTO (one, two,
three) VALUES (?, ?, ?)");

p.setString(1, htmlstring);
p.setTimestamp(2, t);
...
p.executeUpdate();

This throws an java.sql.SQLException: ERROR:  parser: unterminated
quoted string at or near "'<html>

What am I doing wrong??

Thanks
Timo
--
uggc://avgjvg.qr


pgsql-advocacy by date:

Previous
From: Dennis Gearon
Date:
Subject: Please scan your computer
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Fw: Bulletin #76 PHP Everywhere