Re: GLENN - I am so close to having my sp working, I can SMELL it.

Congrats on the trout. Willing to share your spot? (I work in PA and live in NJ)

Back to work...

It appears you used a copy of the code I got working on my system so I'm not sure where to go from here. You may want to start a conversation with easycom (tech@xxxxxxxxxxxxxxxx). They were very responsive when I asked them about the 'auto next result' thing. (Keep in mind that they're in France and there may be a time delay) From what they told me, if you have Zend installed they will support you.

If I may ask... Are you willing to try the db2* functions? Whenever possible, I prefer to use code that isn't hardware specific.

Glenn

On 4/17/2010 12:29 PM, Tom Deskevich wrote:

Or it may be that I went trout fishing here in PA this morning and did
not take a shower...(I got 9, my dad 14 btw)

But nevertheless.

The stored procedure is being CALLED now from the AS/400.

NO errors, either reported by my script or in the error log.

BUT....

No output. Just the headings Library Procedure.

I call the SAME procedure from VB.NET and get a result set back.

echo "</br></br>";
echo "<table><tr><td>Library</td><td>Procedure</td></tr>";

while($row = i5_fetch_row( $result, I5_READ_NEXT )){
$SCHEMA = $row[0];
$PROC = $row[1];
echo("<tr><td nowrap>$SCHEMA&nbsp;</td>
<td nowrap>$PROC&nbsp;</td></tr>");
}

echo "</table>";

var_dump of $result and $hdl:
$HDL (from i5_execute) resource(5) of type (easycom result)
$result(from i5_prepare)= bool(true)


TIA Tom Deskevich
Check my picture on midrange facebook to get an idea of my state of
mind.