Re: [phplib] Problem getting sequence value From: Mikhail Avrekh (ami <email protected>)
Date: 08/24/00

>

 $q = "select whatever from DUAL ";

> $this->db->query($q);

$this->db->next_record();

$val = $this->db->f("whatever"); <<<<<<<<<<<< whatever in lowercase !!

 
> 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>