From: | "Matthew Morvant" <uce(at)bigfatreddog(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Mixed Case column names (php 4.3.5 & pg 7.4.2) |
Date: | 2004-04-28 16:43:30 |
Message-ID: | VaRjc.1243$28.922@fe07.usenetserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Typo on that post. Here is what is should be:
echo pg_fetch_result($rsTest,0,"ridStudent");
which still doesn't work.
"Matthew Morvant" <uce(at)bigfatreddog(dot)com> wrote in message
news:U7Rjc(dot)1242$28(dot)743(at)fe07(dot)usenetserver(dot)com(dot)(dot)(dot)
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kilmer C. de Souza | 2004-04-28 18:13:39 | Postgre and Web Request |
Previous Message | Matthew Morvant | 2004-04-28 16:40:24 | Mixed Case column names (php 4.3.5 & pg 7.4.2) |