php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #7886 Return Columns
Submitted: 2000-11-20 05:25 UTC Modified: 2001-02-18 06:25 UTC
From: vvtk at stealthcomp dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.3pl1 OS: RedHat6.2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: vvtk at stealthcomp dot com
New email:
PHP Version: OS:

 

 [2000-11-20 05:25 UTC] vvtk at stealthcomp dot com 
I don't know bug it or future.

Query:

SELECT a1.*,a2.*,a3.* FROM (SELECT VALUE FROM V$SYSSTAT WHERE NAME='db block gets') a1,(SELECT VALUE FROM V$SYSSTAT WHERE NAME='consistent gets') a2,(SELECT VALUE FROM V$SYSSTAT WHERE NAME='physical reads') a3

OCIFetchStatement return array with 1 field, but I expected 3 fields.

(SQLPlus return 3 fields).

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-07 19:52 UTC] sniper@php.net 
Does this happen with PHP 4.0.4 ?

--Jani
 [2001-01-09 06:41 UTC] vvtk at stealthcomp dot com 
PHP 4.0.4 - same effect.
OCIFetchStatement return 1 column, but I expected 3 columns.
 [2001-02-18 06:25 UTC] thies@php.net 
php does not allow two columns to have the same name! if i 
paste you select into sqlplus i get:

     VALUE      VALUE      VALUE
---------- ---------- ----------
     17069     157090       7984

do "select ... as col1, ... as col2" etc
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 15:01:27 2025 UTC