Re: Seeking PyGreSQL help

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)PyGreSQL(dot)org>
To: "Alastair G(dot) Hogge" <agh(at)tpg(dot)com(dot)au>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Seeking PyGreSQL help
Date: 2003-08-05 16:44:15
Message-ID: 200308051244.15331.darcy@PyGreSQL.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Tuesday 05 August 2003 08:53, Alastair G. Hogge wrote:
> 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

Right. That's the error. You are trying to pass a Python variable name to
the PostgreSQL backend. Go to the Python page and look up formatting with
the '%' operator.

--
D'Arcy J.M. Cain
PyGreSQL Development Group
http://www.PyGreSQL.org

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Frank van Vugt 2003-08-05 21:45:21 Re: Multi-threaded user app segfaults when using libpq with separate connections
Previous Message Christoph Haller 2003-08-05 15:03:59 Re: unicode and libpq