Re: [SQLObject] "unrecognized token" when using SQLite

[Ian B. <ia...@co...>]

On Fri, 2003-05-02 at 14:17, Mike Hostetler wrote:
>   INSERT INTO site_data (category, link, description, title, date,
> site_id) VALUES ('tech', 'http://slashdot.org/article.pl?sid=03/05/02/1645224', 'Smaz writes "Apparently Carnegie Mellon has set up a Hall of Fame for robots and their inventors. Wonder if it\'ll have the pull of a RnR Hall of Fame or
> ...', 'Robot Hall of Fame', '2003-05-02T18:15:48+00:00', 1)
> 
> I'm not sure what ":" in the statement SQLite doesn't like . . . I can
> use the same data with PostgreSQL.

My guess is it doesn't like \', but would prefer ''.  Try changing line
76 of SQLBuilder.py:

# original:
('\'', '\\\'')
# with:
("'", "''")

If that works I'll just check that change into CVS.

  Ian