Received: from gateway.indvalley.com (PPP-200-7-136.bng.vsnl.net.in [203.200.7.136]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f98Ce1n45367; Mon, 8 Oct 2001 08:40:07 -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 f98ChLY03965; Mon, 8 Oct 2001 18:13:21 +0530 Date: Mon, 8 Oct 2001 18:07:14 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Gurudutt Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <11730930852.20011008180714@indvalley.com> To: pgsql-sql@postgresql.org CC: pgsql-php@postgresql.org Subject: PEAR Problem MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/42 X-Sequence-Number: 595 Hi, It's me again. I have been able to solve most of the porting problems from mysql to pgsql. But I have got struck in one place. I have a problem where PEAR's associative array doesn't recognise the mix case letters. eg . I issue a query through PEAR db and get results using fetchRow of PEAR. Now I have set associative array feature ON. suppose the query is select NetCode,NetworkName from NetworkTab; this would return the result into a variable called $dbRow to echo the contents returned by the pgsql, I have to give $dbRow[NetCode] and $dbRow[NetworkName] This used to work perfectly fine with mysql, but as I moved to pgsql, PEAR started to return nothing like if i echo $dbRow[NetCode] it prints nothing but in the same echo is I change it echo $dbRow[netcode], it prints the value of the Network Code. How do I handle this situation. The application is fully written with Mix Case letters for the database fields and returned result set. And one more thing "SET AUTOCOMMIT=0" which is to set auto commiting to "No" in mysql doesn't work in pgsql what is the equivalent command. -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates