X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id A596AD1C7EB
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 01:23:37 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 60543-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue,  5 Aug 2003 22:22:21 -0300 (ADT)
Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58])
	by svr1.postgresql.org (Postfix) with ESMTP id B7048D1C918
	for <pgsql-interfaces@postgresql.org>;
	Tue,  5 Aug 2003 22:23:25 -0300 (ADT)
Received: from 192.168.0.4 (220-244-72-6.tpgi.com.au [220.244.72.6])
	by mail2.tpgi.com.au (8.12.9/8.12.9) with ESMTP id h761NOFO029274
	(version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO);
	Wed, 6 Aug 2003 11:23:27 +1000
From: "Alastair G. Hogge" <agh@tpg.com.au>
To: darcy@PyGreSQL.org, pgsql-interfaces@postgresql.org
Subject: Re: Seeking PyGreSQL help
Date: Wed, 6 Aug 2003 11:23:31 +1000
User-Agent: KMail/1.5.3
References: <200308051816.06256.agh@tpg.com.au>
	<200308052253.37438.agh@tpg.com.au>
	<200308051244.15331.darcy@PyGreSQL.org>
In-Reply-To: <200308051244.15331.darcy@PyGreSQL.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308061123.31792.agh@tpg.com.au>
X-Kaspersky-Antivirus: Passed
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/23
X-Sequence-Number: 4377

On Wednesday, 06 August 2003 02:44, D'Arcy J.M. Cain wrote:
> 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.
Ah I see. Thanks for that.
All is working ok now. :-)
-Al