Posted by Sonnich on 01/29/07 17:03

I got this to work using
while ($row = oci_fetch_row ($stid))

But not I get another problem, see comment here:

$stid = oci_parse($connX, $sql2);
if (!$stid)
{
$e = oci_error($connX);
echo htmlentities($e['message'])."<br>";
}
else
{
$r = oci_execute($stid, OCI_DEFAULT);
// instead of going ahead, it still gives the error here. How do I
stop that.
// the error is correctly catched here anyway, but I'd like to have it
only. Meaning no default response when the query fails.
if(!$r)
{
$e = oci_error($stid);
if(strpos($e['message'],"CONNECT BY loop")!==false)
echo "<font class=\"error\">Loop error with item:
$Item[$i]</font><p>";
else
echo htmlentities($e['message'])."<br>";
}
else
{



On Jan 26, 6:52 pm, "Sonnich" <sonnich.jen...@elektrobit.com> wrote:
> Hello there
>
> I'm trying to work with the example for OCI... and the $row returns 2
> values, the same twice, but my query only have one... code below.
>
> Can anyone explain?
>
> BR
> S
>

• Next in forum: SimpleXML Error: Node no longer exists (using addChild())
• Prev in forum: variable php_value in apache .htaccess?
• Thread view: Re: New to OCI - double results?

[Reply to this message]