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>
Cc:
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
> ([1][1]
https://www.python.org/dev/peps/pep-0249/#id15 ;). Here's
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.
John Y.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [2]
https://lists.midrange.com/mailman/listinfo/opensource ;
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [3]
https://archive.midrange.com/opensource ;.
Help support midrange.com by shopping at amazon.com with our affiliate
link: [4]
https://amazon.midrange.com ;
References
Visible links
1.
https://www.python.org/dev/peps/pep-0249/#id15
2.
https://lists.midrange.com/mailman/listinfo/opensource
3.
https://archive.midrange.com/opensource
4.
https://amazon.midrange.com/
midrange.com
