Mixed Case column names (php 4.3.5 & pg 7.4.2)

Поиск
Список
Период
Сортировка
От Matthew Morvant
Тема Mixed Case column names (php 4.3.5 & pg 7.4.2)
Дата
Msg-id U7Rjc.1242$28.743@fe07.usenetserver.com
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Matthew Morvant"
Дата:
Сообщение: Re: Mixed Case column names (php 4.3.5 & pg 7.4.2)
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Tracking structural changes from psql