Re: Seeking PyGreSQL help

On Tuesday, 05 August 2003 22:45, D'Arcy J.M. Cain wrote:
> On Tuesday 05 August 2003 08:41, Alastair G. Hogge wrote:
> > "db.query("INSERT INTO test VALUES (temp, 'none')")" is the line causing
> > the problem. The internel server error from apache.
>
> What happens when you try doing that line directly into psql?  I don't know
> what your schema for test is but perhaps what you want is this:
>
> db.query("INSERT INTO test VALUES (temp, NULL)")
In pyhton?
temp = "hello"
>>> db.query("INSERT INTO test VALUES (temp, NULL)")
Traceback (most recent call last): File "<stdin>", line 1, in ?
_pg.error: ERROR:  Attribute "temp" not found