pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gurudutt <guru@indvalley.com>
To: pgsql-sql@postgresql.org
Cc: pgsql-php@postgresql.org
Subject: PEAR Problem
Date: Mon, 8 Oct 2001 18:07:14 +0530
Message-ID: <11730930852.20011008180714@indvalley.com> (raw)

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




view thread (3+ messages)  latest in thread

Message-ID: <11730930852.20011008180714@indvalley.com>
Permalink:  ../11730930852.20011008180714@indvalley.com/
Also on:    postgresql.org/message-id/11730930852.20011008180714@indvalley.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: guru@indvalley.com, pgsql-php@postgresql.org
  Subject: Re: PEAR Problem
  In-Reply-To: <11730930852.20011008180714@indvalley.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox