Try converting the ROWID to a character string first:

  select rowidtochar(rowid), field1 from table1

Now you can echo it out or do whatever you would do with a character
string.  There's also the Oracle function CHARTOROWID to go the other
way around.

signup wrote:
> 
> On Mon, Jan 22, 2001 at 01:38:22PM -0800, signup wrote:
> > Hello,
> > does anyone know how to write te result of the following SQL statement (I have 
>problems with rowid):
> >
> > select rowid, field1 from table1
> 
>     rowid is an opaque datatype in php. you cannot "output" it
>     but only use it for further processing using ocibindbyname().
> 
>     tc
> 
> --
> 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]

-- 
------------------------------------------------------
Harry N. C. Ng
Office of Information Services
Air Resources Board
1001 I Street                 E-mail: [EMAIL PROTECTED]
P.O. Box 2815                 Phone:  916-322-6201
Sacramento, CA  95812         FAX:    916-327-0640

-- 
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]

Reply via email to