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
>    ([1][1] ;). 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] ;
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [3] ;.

Help support by shopping at with our affiliate
link: [4] ;



Visible links

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.