From: <hagen@datasundae.com>
To: "'Adrian Klaver'" <adrian.klaver@aklaver.com>,
	<psycopg@lists.postgresql.org>,
	<psycopg@postgresql.org>
References: <0bef01d6cce4$987d8120$c9788360$@datasundae.com>
 <5c55fb91-0b03-2077-fce7-38f2dcc0d402@aklaver.com>
 <0bf801d6cce8$011969d0$034c3d70$@datasundae.com>
 <63f9baec-b185-3278-e8a7-84692579f9d8@aklaver.com>
 <f8e31d3b-f5f4-0e9b-0318-0cddd77fd988@datasundae.com>
 <e8197628-973c-db98-e35d-73a1c1390b33@aklaver.com>
In-Reply-To: <e8197628-973c-db98-e35d-73a1c1390b33@aklaver.com>
Subject: RE: BACK: Inserting a variable into cur.execute statement
Date: Sun, 20 Dec 2020 18:21:11 -0700
Message-ID: <1a5001d6d737$91f209e0$b5d61da0$@datasundae.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: 
 AQJo2ByQlIUQoUmlPw+s83H/ns7RlQIr5Xh8AbQDjf0A356bEAKbJZSIAolmMdOojZ5AgA==
Content-Language: en-us
Precedence: bulk

Interesting - thank you Adrian.

-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com>=20
Sent: Sunday, December 20, 2020 5:57 PM
To: Hagen Finley <hagen@datasundae.com>; psycopg@lists.postgresql.org; =
psycopg@postgresql.org
Subject: Re: BACK: Inserting a variable into cur.execute statement

On 12/20/20 3:13 PM, Hagen Finley wrote:
> Hello,
>=20
> I finally got around to trying to implement this code and I am running =

> into an "IndexError: tuple index out of range" problem.
>=20
> I am running a function with parameters from a list:
>=20
> def def_acct_analysis(sht,acct):
>      print(param[par][0])
>      print(param[par][1])
>      sheet =3D"sheet"+str(sht)
>      print(sheet)
>      account =3D acct
>      print(account)
>=20
> par =3D0 param =3D [(1,'ACCT0'),(2,'ACCT1'),(3,'ACCT2'),]
>=20
> for pin param:
>      def_acct_analysis(param[par][0], param[par][1])
>=20
>      par +=3D1


FYI, the above can be simplified to:

param =3D [(1,'ACCT0'),(2,'ACCT1'),(3,'ACCT2'),]

for p in param:
     def_acct_analysis(p[0], p[1])

>=20
> #Print statements above output:
>=20

--
Adrian Klaver
adrian.klaver@aklaver.com