Oracle query not returning rows

sheilam

I have a pretty straightforward application that accepts keywords from the user and uses them to build a query that is then submitted to Oracle. Here's a code snippet:

$stmt = OCIParse($conn,$query);

OCIDefineByName($stmt,"FIELD1",&$disp_field1);
OCIDefineByName($stmt,"FIELD2",&$disp_field2);
OCIDefineByName($stmt,"FIELD3",&$disp_field3);

OCIExecute($stmt);

if(!OCIFetch($stmt))
{
echo "Sorry! No matches found!";
}

while (OCIFetch($stmt))
{

echo $disp_field1.  " " . $disp_field2 . " " . $disp_field3;

}

The OCIDefineByName seems to be where the problem is. If I echo $disp_field1 by itself, I get a blank reply, but there should be data there.

The query works, because I've echoed it out, then copied it into sqlplus. It returns 2 rows.

I've also tested for $stmt:
if(!$stmt){echo "no stmt!";} else {echo "stmt";}

and it's worked also.

Can anyone see what I'm doing wrong?

Thanks!

Anon

According to the documentation, you don't need the "&"'s. Try:

OCIDefineByName($stmt, "FIELD1", $disp_field1);
OCIDefineByName($stmt, "FIELD2", $disp_field2);
OCIDefineByName($stmt, "FIELD3", $disp_field3);

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

sheilam

Here's the weird thing (ok, things):
1. The OCIBindByName lines were copied directly off another page that does work...flawlessly...every time (and it didn't work after removing the &).
2. This page worked just a minute ago, about 3 times, then quit again. I am NOT having fun.

This is driving me nuts. Is there any bizarre little quirk around Oracle/Linux/PHP4 that anyone's run into?

Anon

How about posting more of the code so we can test it? The SELECT statment would be particularly useful.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com