Re: [PHP] Calling a stored procedure

2007-11-30 Thread Daniel Brown
On Nov 30, 2007 5:16 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > ALMOST have it! > > I have changed the code to this: > > if ($num_rows > 0 && $barcode_id == "") { > echo "The query found ".$num_rows." row(s)"; > $procedure = "Execute Procedure informix.updt_brcd_id_req('$case', > '$event_date',

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Dan Shirah
[EMAIL PROTECTED] > > Sent: Friday, November 30, 2007 4:00 PM > > To: Daniel Brown > > Cc: php-general > > Subject: Re: [PHP] Calling a stored procedure > > > > I tried a different approach with the code below: > > > > if ($num_rows > 0 &&am

RE: [PHP] Calling a stored procedure

2007-11-30 Thread Andrés Robinet
> -Original Message- > From: Dan Shirah [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 4:00 PM > To: Daniel Brown > Cc: php-general > Subject: Re: [PHP] Calling a stored procedure > > I tried a different approach with the code below: > > if

RE: [PHP] Calling a stored procedure

2007-11-30 Thread Warren Vail
l Brown > Cc: php-general > Subject: Re: [PHP] Calling a stored procedure > > I'm not sure if we're on the same page. > > I have a stored procedure on my Informix server. All I am trying to do is > create a simple form that when submitted will pass several parameters

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Daniel Brown
On Nov 30, 2007 1:56 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > I'm not sure if we're on the same page. > > I have a stored procedure on my Informix server. All I am trying to do is > create a simple form that when submitted will pass several parameters to the > stored procedure and execute it. >

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Dan Shirah
I tried a different approach with the code below: 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 = ifx_query($connect_id, $call_proc

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Dan Shirah
I'm not sure if we're on the same page. I have a stored procedure on my Informix server. All I am trying to do is create a simple form that when submitted will pass several parameters to the stored procedure and execute it. I shouldn't have to pass the head/body/content to the Informix server to

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Daniel Brown
On Nov 30, 2007 1:39 PM, Dan Shirah <[EMAIL PROTECTED]> 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 fo