[PHP-DB] CONNECT BY PHP problem

[Mirko Cegledi]

Hello there!

 I'm new to this list and I've got a problem ;). Have I to introduce myself?
Anyway, here it is:

 I'm using an oracle database to store hierarchic data in a single table.
With HORA, it is no problem to display the hierarchic structure via the
CONNECT BY clause. I tried the same statement in PHP3 and it didn't work out
right. Except in one case, I always receive no rows in the result. The
exception is, however, when there's only one row in the result. Could it be
that there is something that prevents me from using this feature (CONNECT
BY) or have I to nuzzle through my source in an endless quest for a
microscopic bug?

Regards,

Mirko Cegledi


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] CONNECT BY PHP problem

[David Benson]

 With HORA, it is no problem to display the hierarchic structure via the
 CONNECT BY clause. I tried the same statement in PHP3 and it 

I'm using php4pl1 with Oracle 8.1.6 and this works:

select c.cvsn_id,
   c.parent_cvsn_id,
   level
  from cvsn c
 where start with c.cvsn_id = :cvsn_id
 connect by prior c.cvsn_id = c.parent_cvsn_id

David



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]