Sure. I didn't look at the SQL, just fixed the function call.
----- Original message -----
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: [IBMiOSS] beginning python
Date: Thu, Jan 9, 2020 10:17 AM
On Thu, Jan 9, 2020 at 11:10 AM Kevin Adler <kadler@xxxxxxxxxx> wrote:
> You're calling the function wrong. You may want to read the docs
what you want:
> query = "select bhuact, bhubld, bhuutl, rvdes, bhuuse, bhuamt,
bhutax " \
> "from ublhu inner join urvc on bhurvc = rvrvc" \
> "and bhuact = ? and bhubld between ? and ? " \
> "and bhurvc <> ' ' " \
> "order by bhubld, bhuact, bhurvc "
> cursor.execute(query, (acct, begdate, enddate))
Except that he'll need to be more careful with the leading and/or
trailing spaces, or lack thereof.
I am not completely sure what he put in his e-mail is actually what
he's got in his source code, but if it is, there will be a problem
with the SQL.
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.