Received: from gateway.indvalley.com (PPP-200-7-79.bng.vsnl.net.in [203.200.7.79]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9989Xn81074 for ; Tue, 9 Oct 2001 04:09:33 -0400 (EDT) (envelope-from guru@indvalley.com) Received: from GURU ([192.168.0.20]) by gateway.indvalley.com (8.11.2/8.11.2) with ESMTP id f998DLv03030 for ; Tue, 9 Oct 2001 13:43:21 +0530 Date: Tue, 9 Oct 2001 13:37:13 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Gurudutt Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <9114697982.20011009133713@indvalley.com> To: pgsql-php@postgresql.org Subject: Re: PEAR Problem MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/45 X-Sequence-Number: 598 Hello Dan, Thanks very much for the help. Ya I tried enclosing with the quotes on that unfortunately it doesn't work, it gives error. Here are source code for the files. You can try creating a table names ACT_NetworkTab with 2 fields, NetCode(Integer) and NetWorkName(Varchar) This is the php code which is used to print the values query($Begin_Query); //Auto Commit Query .. //$AutoCommit_Query = "SET autocommit=0"; //$AutoCommit_Result = $db->query($AutoCommit_Query); $Query = "SELECT \"NetCode\",\"NetWorkName\" FROM \"ACT_NetworkTab\""; $Result = $db->query($Query); if(DB::isError($Result)) { //Do a Roll Back .... $RoleBack_Query = "ROLLBACK"; $RoleBack_Result = $db->query($RoleBack_Query); echo "Query Failed (line 38)"; exit; } else { while($Row = $Result->fetchrow()) { echo "NetCode:",$Row[NetCode]."---NetName:".$Row[NetworkName]; echo "
"; } } //end of if db success .... //Commit the operation here ..... $Commit_Query = "COMMIT"; $Commit_Result = $db->query($Commit_Query); } //end of if submit ... ?> This is the pgsql.php include file for Database connectivity getMessage(); } else { $db->setFetchMode(DB_FETCHMODE_ASSOC); } ?> Please try and help me!! -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates Tuesday, October 09, 2001, 9:34:24 AM, you wrote: DW> This is caused by the fact that PostgreSQL is case insensitive. In order DW> for it to actually take the case into account, you need quote your field DW> names and table names. DW> So your query would then be: select "NetCode","NetworkName" from DW> "NetworkTab"; DW> Then you would be able to access the fields with $dbRow[NetworkName]. DW> -Dan DW> : Hi, DW> : DW> : It's me again. I have been ab