[phplib] Problem getting sequence value From: Jensen Tim-TAJENS1 (Tim.Jensen <email protected>)
Date: 08/24/00

I'm trying to obtain a valid sequence number from an oracle 8.1.6 database.
I'm using the PHPLIB 7.2c and db_odbc.inc. I've created the following
query:

$q = "select PEER_REVIEW.NEXTVAL from DUAL ";
$this->db->query($q);
$val = $this->db->f("NEXTVAL");

where db is an instance of DB_sql (actually UPR_sql which extends DB_sql);

My problem is that the code appears to work but $this->db->f("NEXTVAL")
never returns the value even though the query succeeded and the sequence has
been incremented.

Is there a problem with db_odbc.inc that it wouldn't return this value?
Other ODBC applications don't seem to have a problem with executing this
statement and returning the value.

Before anyone suggests using db_oci8 I have tried it and doesn't return the
value either.

Any help would be greatly appreciated!

Thanks,

    --Tim

"Not everything that can be counted counts and
 Not everything that counts can be counted"
                                               * Albert Einstein

 <<Tim Jensen (E-mail).vcf>>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>