On Nov 30, 2007 1:39 PM, Dan Shirah <mrsquash2@xxxxxxxxx> wrote:
> 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
>
You have to first instantiate the class.
For example:
<?
include_once("classes/layout.class.php");
$H = new Head();
$B = new Body();
$P = new Page($H, $B);
$H->title("A Sample PHP Page");
$H->css("sample.css");
$B->content("This is where Dan Shirah's content would go.");
$P->render();
?>
--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
If at first you don't succeed, stick to what you know best so that you
can make enough money to pay someone else to do it for you.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
