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

From: Timo Nentwig <timo(at)nitwit(dot)de>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: java.sql.SQLException: ERROR: parser: unterminated quoted string at or near "'<html>
Date: 2003-08-27 16:45:58
Message-ID: 1062002757.3827.47.camel@tcn.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Dennis Gearon 2003-08-27 16:57:36 Please scan your computer
Previous Message Marc G. Fournier 2003-08-27 14:21:15 Re: ads on postgresql.org broken