Re: PHP using ODBC not liking like

[Don Brown <DBrown@xxxxxxxxxx>]

MFSLIBRARY is a global variable.

Everything works except the LIKE selection.

Cheers






From:   "Jack Woehr via MIDRANGE-L" <midrange-l@xxxxxxxxxxxxxxxxxx>
To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc:     "Jack Woehr" <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Date:   27/09/2022 02:33 PM
Subject:        Re: PHP using ODBC not liking like
Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



If you do var_dump($sql); there you'd see what's broken.
Put quotes around "MFSLIBRARY"

On Mon, Sep 26, 2022 at 9:51 PM Don Brown via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> I an trying to use a LIKE in my SQL to allow searching for the result.
>
> From Run SQL Scripts this works exactly as expected
>
> select * from mfsdta/mfsdebpf
>   where debcoy = 1 and debac like 'A%' and debact = 'A'
>   fetch first 10 rows only;
>
> But from PHP running on the IBMi using the toolkitservice I have
>
>                 $conn = getToolkitServiceForCurrentUser();
>                 $sql = "select * from "
>                         . MFS_LIBRARY . ".MFSDEBPF "
>                         . " where DEBCOY = ? and DEBAC like ? and debact 
=
> ? "
>                         . " order by DEBAC "
>                         . " fetch first 10 rows only";
>
>                 $values = array();
>                 $values[0] = $company;
>                 $values[1] = $search . "%";
>                 $values[2] = $status;
>                 print_r($values);
>                 $stmt = prepareAndExecute($conn, $sql, $values);
>
> The $values array have these values
>
> Array ( [0] => 1 [1] => A% [2] => A )
>
> No errors are received but no records either.
>
> If I change the where to use and DEBAC >= ?  then I get records returned
> so it has to be the way I am formatting the variable with the % sign.
>
> As a separate question I can't find any log file that may hold the 
answer
> - any suggestions ????
>
> Thanks
>
> Don
>
>
>
> --
> This email has been scanned for computer viruses. Although MSD has taken
> reasonable precautions to ensure no viruses are present in this email, 
MSD
> cannot accept responsibility for any loss or damage arising from the use 
of
> this email or attachments..
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com