Mixed Case column names (php 4.3.5 & pg 7.4.2)

From: "Matthew Morvant" <uce(at)bigfatreddog(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Mixed Case column names (php 4.3.5 & pg 7.4.2)
Date: 2004-04-28 16:40:24
Message-ID: U7Rjc.1242$28.743@fe07.usenetserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have a very simple page that illustrates an issue I am having. (Please
assume that dbConnect() returns a vaild connection and there is at least 1
record returned)

<?

include('GlobalFunctions.php');

$oConn = dbConnect();

$rsTest = pg_exec('SELECT "ridStudent" FROM "tblStudent"');

echo pg_fetch_result($rsTest,0,"ridstudent");

pg_close($oConn);

?>

Can anyone please explain why this doesn't work. I know that I can use an
all lowercase alias in the query, but there HAS to be an easier way. I
currently am referencing everything by ordinal, that is going to bite me
whenever someone decides to make a "simple" DB change. Is this pg_fetch
results even the best thing to use?

Thanks
Matthew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Morvant 2004-04-28 16:43:30 Re: Mixed Case column names (php 4.3.5 & pg 7.4.2)
Previous Message Anony Mous 2004-04-28 16:19:11 Re: FW: Postgres alongside MS SQL Server