Thread: quesion on functions calling from php

Hi,<br />  <br />    I have written a plpgsql function media_format_func(p_in overlay_format_type) which returns
int<br/>  <br /> $sql='select * from media_format_func((200,400,'640*481','jpg')::overlay_format_type)';<br />  <br />
$result= $this->objDB->query($sql);<br /> print_r($result,1);<br />  <br />   I should get a value as 10, instead
Iam getting the Resource ID as 128 which is wrong I guess I am getting the output as an object and I am not getting the
expectedresul that I should get.  <br />  <br />  What may be the problem?<br />  <br />    I am using PEAR object
modulefor the db connections.<br />  <br />   Please advise.<br />  <br /> Regards<br /> skarthi<br />  <br /><br /><hr
/>WithWindows Live Hotmail you can now see trouble.before he arrives. <a href="http://Newlivehotmail.com"
target="_new">Checkit out for yourself.</a> 

Karthikeyan Sundaram wrote:
> Hi,
>  
>    I have written a plpgsql function media_format_func(p_in 
> overlay_format_type) which returns int
>  
> $sql='select * from 
> media_format_func((200,400,'640*481','jpg')::overlay_format_type)';
>  
> $result = $this->objDB->query($sql);
> print_r($result,1);
>  
>   I should get a value as 10, instead I am getting the Resource ID as 
> 128 which is wrong I guess I am getting the output as an object and I 
> am not getting the expected resul that I should get. 

Try one of the methods $this->objDB->getRow($sql), 
$this->objDB->getAll($sql) or $this->objDB->getOne($sql) instead.
Also, have a look at the documentation at pear.php.net

-- 
Tommy
www.gildseth.com