|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-12-09 11:40 UTC] tal@php.net
[2003-04-27 16:32 UTC] lsmith@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 09:00:01 2025 UTC |
My test skeleton of PEAR DB commands : $conn =DB::connect("pgsql://... etc $stmt= $conn->query($_POST[query]); $cols= $stmt->tableInfo(); for ($i=0; $i< $ncols; $i++){ $col_name[$i]= $cols[$i][name]; $type[$i]= $cols[$i][type]; $len[$i]= $cols[$i][len]; $flags[$i]= $cols[$i][flags]; while( ($r= $stmt->fetchRow())){ . . . etc THE PROBLEM: fetchRow() returns Null. If you interchange the order of fetchRow() with tableInfo() no problem arises. This is unacceptable if you want to format a query result using information obtained from tableInfo(): you would have to re-submit the same (possibly large) query again! MY PHP config.nice file: './configure' \ '--with-apxs=/usr/local/apache/bin/apxs' \ '--with-mysql=/usr' \ '--with-pgsql=/usr/local/pgsql' \ '--with-interbase=/opt/interbase' \ '--with-db3' \ "$@" Celio Guimaraes celio@ic.unicamp.br Dec 9, 2002