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/

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2022 by midrange.com 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.