[PHP-DB] Problems with pg_FieldNum

[Brady A. Johnson]

Greetings,

I am having trouble with the PostgreSQL pg_FieldNum() funciton.  When I 
execute the following:

  $DB = pg_Connect ( "dbname=lists" );
  $Recs = pg_Exec ( $DB, "SELECT 123 AS \"ABC\"" );

  $FieldName = pg_FieldName ( $Recs, 0 );
  print ( "<p>FieldName: $FieldName</p>" );

  $FieldNum = pg_FieldNum ( $Recs, $FieldName );
  print ( "<p>FieldNum: $FieldNum</p>" );

I get:

  FieldName: ABC
  FieldNum: -1

It seems that no matter what I pass to pg_FieldNum(), I get -1 (error) in 
return.

Anyone spot what I am doing wrong?

I am using PostgreSQL 7.0.2 and PHP 4.0.3 on RH Linux 7.0.

Thanks,

-Brady

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php