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_procedure); }

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', '$event_sequence',

Re: [PHP] Calling a stored procedure

2007-11-30 Thread Dan Shirah
that error and how to get rid of it? Thanks! Dan On 11/30/07, Andrés Robinet [EMAIL PROTECTED] wrote: -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

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 ($num_rows 0 $barcode_id == ) { echo

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. I

RE: [PHP] Calling a stored procedure

2007-11-30 Thread Warren Vail
-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 to the stored procedure and execute it. I

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 following:

[PHP] Calling a stored procedure

2007-11-30 Thread Dan Shirah
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