Re: MAJOR information leaked out in TFM -- WEB400

Describing what parameters to get what output?
Are you saying that a result set needs to be defined as a parameter?

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of ADelgado@xxxxxxxxxxxxxxxxxx
Sent: Thursday, April 15, 2010 10:37 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] MAJOR information leaked out in TFM

It seems like you missed the point about describing the parameters so
that
you can get at your output.
--
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 10:21
Subject: Re: [WEB400] MAJOR information leaked out in TFM

Sorry I am up to my ear lobes in alligators with my 'real' job
today.
But I think this is pretty much what I am doing.
I did see it.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx
[[1]mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of ADelgado@xxxxxxxxxxxxxxxxxx
Sent: Thursday, April 15, 2010 9:28 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] MAJOR information leaked out in TFM

Did you miss this yesterday?

[2]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][3]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][4]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][5]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][6]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][7]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][8]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [7][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:
[8][10]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [9][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:
[10][12]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [11][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:
[12][14]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [13][15]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][16]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [15][17]http://archive.midrange.com/web400.

References

Visible links
1. [18]mailto:web400-bounces@xxxxxxxxxxxx
2. [19]mailto:web400-bounces@xxxxxxxxxxxx
3. [20]mailto:web400-bounces@xxxxxxxxxxxx
4. [21]mailto:web400-bounces@xxxxxxxxxxxx
5. [22]mailto:web400-bounces@xxxxxxxxxxxx
6. [23]http://lists.midrange.com/mailman/listinfo/web400
7. [24]http://archive.midrange.com/web400
8. [25]http://lists.midrange.com/mailman/listinfo/web400
9. [26]http://archive.midrange.com/web400
10. [27]http://lists.midrange.com/mailman/listinfo/web400
11. [28]http://archive.midrange.com/web400
12. [29]http://lists.midrange.com/mailman/listinfo/web400
13. [30]http://archive.midrange.com/web400
14. [31]http://lists.midrange.com/mailman/listinfo/web400
15. [32]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: [33]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [34]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: [35]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [36]http://archive.midrange.com/web400.

References

Visible links
1. mailto:web400-bounces@xxxxxxxxxxxx
2. http://archive.midrange.com/web400/201004/msg00096.html
3. mailto:web400-bounces@xxxxxxxxxxxx
4. mailto:web400-bounces@xxxxxxxxxxxx
5. mailto:web400-bounces@xxxxxxxxxxxx
6. mailto:web400-bounces@xxxxxxxxxxxx
7. mailto:web400-bounces@xxxxxxxxxxxx
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
16. http://lists.midrange.com/mailman/listinfo/web400
17. http://archive.midrange.com/web400
18. mailto:web400-bounces@xxxxxxxxxxxx
19. mailto:web400-bounces@xxxxxxxxxxxx
20. mailto:web400-bounces@xxxxxxxxxxxx
21. mailto:web400-bounces@xxxxxxxxxxxx
22. mailto:web400-bounces@xxxxxxxxxxxx
23. http://lists.midrange.com/mailman/listinfo/web400
24. http://archive.midrange.com/web400
25. http://lists.midrange.com/mailman/listinfo/web400
26. http://archive.midrange.com/web400
27. http://lists.midrange.com/mailman/listinfo/web400
28. http://archive.midrange.com/web400
29. http://lists.midrange.com/mailman/listinfo/web400
30. http://archive.midrange.com/web400
31. http://lists.midrange.com/mailman/listinfo/web400
32. http://archive.midrange.com/web400
33. http://lists.midrange.com/mailman/listinfo/web400
34. http://archive.midrange.com/web400
35. http://lists.midrange.com/mailman/listinfo/web400
36. http://archive.midrange.com/web400