Re: MAJOR information leaked outaboutthefutureofPHPinmeeting I attended.

[Glenn Hopwood <ghopwood.list@xxxxxxxxx>]

I tried creating a sample for Tom and I seem to be having the same 
problem (I tried switching the input to i5_fetch_assoc()). I can call my 
stored procedure fine with the db2* functions but when I try the i5* 
ones I get my parameter returned instead of a result set.

I have a couple of more things I want to try....

Glenn

On 4/15/2010 9:19 AM, Kevin Schroeder wrote:
> Could you try calling
>
> $stuff = i5_fetch_assoc( $procExec );
>
> I know that's not what the docs say but that just seems more correct.
>
>
> Kevin Schroeder
> Technology Evangelist
> Zend Technologies, Ltd.
> www.zend.com
> www.twitter.com/kpschrade
> www.eschrade.com
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Tom Deskevich
> Sent: Thursday, April 15, 2010 8:13 AM
> To: 'Web Enabling the AS400 / iSeries'
> Subject: Re: [WEB400] MAJOR information leaked
> outaboutthefutureofPHPinmeeting I attended.
>
>
>    $qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL(  )";
>          $request = i5_prepare( $qUpdateCustomer );
>          if( !$request ) var_dump( i5_error( ) );
>          $procExec = i5_program_call( $request, array() );
>          if( !$procExec ) var_dump( i5_error( ) );
>          $stuff = i5_fetch_assoc( $request );
>          var_dump($stuff) ;
>
>
> I am to take array() literally?
>
> Or are you telling me to define an array and pass it as a parmameter?
> array(8) { [0]=>  int(258) [1]=>  int(9) [2]=>  string(21) "Bad connection
> handle" [3]=>  string(0) "" ["num"]=>  int(258) ["cat"]=>  int(9) ["msg"]=>
> string(21) "Bad connection handle" ["desc"]=>  string(0) "" }
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Kevin Schroeder
> Sent: Thursday, April 15, 2010 8:44 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] MAJOR information leaked out
> aboutthefutureofPHPinmeeting I attended.
>
> Try
>
> $procExec = i5_program_call( $request, array() );
>
>
> Kevin Schroeder
> Technology Evangelist
> Zend Technologies, Ltd.
> www.zend.com
> www.twitter.com/kpschrade
> www.eschrade.com
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Tom Deskevich
> Sent: Thursday, April 15, 2010 7:40 AM
> To: 'Web Enabling the AS400 / iSeries'
> Subject: Re: [WEB400] MAJOR information leaked out about
> thefutureofPHPinmeeting I attended.
>
> Ok, you switched me from i5_execute to i5_program_call
>
> Here is my code:
>
> $qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL(  )";
>          $request = i5_prepare( $qUpdateCustomer );
>          if( !$request ) var_dump( i5_error( ) );
>          $procExec = i5_program_call( $request );
>          if( !$procExec ) var_dump( i5_error( ) );
>          $stuff = i5_fetch_assoc( $request );
>          var_dump($stuff) ;
>
> I get this:
>
> array(8) { [0]=>  int(263) [1]=>  int(9) [2]=>  string(51) "Wrong parameter
> count for i5_program_call function " [3]=>  string(0) "" ["num"]=>
> int(263) ["cat"]=>  int(9) ["msg"]=>  string(51) "Wrong parameter count
> for i5_program_call function " ["desc"]=>  string(0) ""
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Kevin Schroeder
> Sent: Thursday, April 15, 2010 8:21 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] MAJOR information leaked out about the
> futureofPHPinmeeting I attended.
>
> Nope.  What you are doing is taking the "prepare" resource and trying to
> get the result from that.  What I believe you want to be doing is taking
> the "execute" resource and extracting the result from there.
>
> However, the example that I see in the docs that uses i5_fetch_assoc()
> seem to use i5_program_prepare and not i5_prepare.  If that is the case
> your code should look something like
>
> $request = i5_program_prepare( $qUpdateCustomer );
> i5_program_call( $request );
> $stuff = i5_fetch_assoc( $request );
>
> If I were to venture a guess it looks like you might have combined the
> i5_prepare/execute code with the i5_program_prepare/call logic.
>
> Kevin Schroeder
> Technology Evangelist
> Zend Technologies, Ltd.
> www.zend.com
> www.twitter.com/kpschrade
> www.eschrade.com
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Tom Deskevich
> Sent: Thursday, April 15, 2010 7:04 AM
> To: 'Web Enabling the AS400 / iSeries'
> Subject: Re: [WEB400] MAJOR information leaked out about the future
> ofPHPinmeeting I attended.
>
> I think you meant to put the WAS on the next line down?
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
> On Behalf Of Kevin Schroeder
> Sent: Thursday, April 15, 2010 7:42 AM
> To: Web Enabling the AS400 / iSeries
> Subject: Re: [WEB400] MAJOR information leaked out about the future of
> PHPinmeeting I attended.
>
> Maybe I'm missing something here but shouldn't it be
>
> $qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL(  )";
>          $request = i5_prepare( $qUpdateCustomer );
>          if( !$request ) var_dump( i5_error( ) );
>          $procExec = i5_execute( $request );
>          if( !$procExec ) var_dump( i5_error( ) );
>          $stuff = i5_fetch_assoc( $procExec );<--    Was
> i5_fetch_assoc( $request );
>          var_dump($stuff) ;
>
> Here is my code:
> $qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL(  )";
>          $request = i5_prepare( $qUpdateCustomer );
>          if( !$request ) var_dump( i5_error( ) );
>          $procExec = i5_execute( $request );
>          if( !$procExec ) var_dump( i5_error( ) );
>          $stuff = i5_fetch_assoc( $request );<<== already has $request
>          var_dump($stuff) ;
>
> ANYWAY, I changed it to what I think you meant ($procexec) and now I get
> bool(false) shown.
>
> Tom Deskevich
> Insane with anger.