Calling a stored procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello all,

I am having soem difficulty when trying to call an INFORMIX stored procedure
with PHP.

I have verified that the if() condition is true and all of the parameters I
am passing are valid. However, when I run the following:

if ($num_rows > 0 && $barcode_id == "") {
 echo "The query found ".$num_rows." row(s)";
 $call_procedure = "CALL informix.updt_brcd_id_req('$case', '$event_date',
'$event_sequence', '$event_code')";
 $call_result = $connect_id->query($call_procedure);
 }

I get this error message: PHP Fatal error: Call to a member function query()
on a non-object

I have never tried to call a stored procedure in PHP before so I'm not even
sure if I am on the right track.

Any help is greatly appreciated.

Dan

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux