Did you miss this yesterday?
http://archive.midrange.com/web400/201004/msg00096.html
--
Alfredo Delgado
6800 Broken Sound Pkwy, Suite 150
Boca Raton, Florida 33487
-----web400-bounces@xxxxxxxxxxxx wrote: -----
To: "'Web Enabling the AS400 / iSeries'" <web400@xxxxxxxxxxxx>
From: "Tom Deskevich" <thomas.l.deskevich@xxxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
Date: 04/15/2010 09:13
Subject: Re: [WEB400] MAJOR information leaked out
aboutthefutureofPHPinmeeting 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
[[1]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
[[2]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
[[3]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
[[4]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
[[5]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.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [6]
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [7]
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [8]
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [9]
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [10]
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [11]
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [12]
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [13]
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [14]
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [15]
http://archive.midrange.com/web400.
References
Visible links
1. mailto:web400-bounces@xxxxxxxxxxxx
2. mailto:web400-bounces@xxxxxxxxxxxx
3. mailto:web400-bounces@xxxxxxxxxxxx
4. mailto:web400-bounces@xxxxxxxxxxxx
5. mailto:web400-bounces@xxxxxxxxxxxx
6.
http://lists.midrange.com/mailman/listinfo/web400
7.
http://archive.midrange.com/web400
8.
http://lists.midrange.com/mailman/listinfo/web400
9.
http://archive.midrange.com/web400
10.
http://lists.midrange.com/mailman/listinfo/web400
11.
http://archive.midrange.com/web400
12.
http://lists.midrange.com/mailman/listinfo/web400
13.
http://archive.midrange.com/web400
14.
http://lists.midrange.com/mailman/listinfo/web400
15.
http://archive.midrange.com/web400
midrange.com
