ora_getcolumn (OCI)

mlandin

hey,

I have switched from oracle support to OCI8 - this resulted in me having to rewrite my php code, cause the ora functions differs from the oci ones.. (damn it)

However besides from the whole send-query struct being different, I seem to have a problem finding the equivalent of ora_getcolumn. Anyone know which function to use, to bring the result ?

Thanks..

/mich

Anon

http://www.php.net/manual/en/function.ociresult.php

I think it makes more sense to call OCIFetchInto and get one array for the whole row or even OCIFetchStatement to get all the rows into an array.

You should consider using generic functions or a class to wraps the database calls so there's less chance of having to rewrite code when you change to a new database.

mlandin

hmm.. ok.. - But why does this not work then:

$mylink = OCIlogon(defined here);

$allcompanyq = "SELECT count(salesperson) FROM company WHERE salesperson='$salesperson'";

$lort5 = OCIparse($mylink, $allcompanyq);
OCIexecute($lort5);

$allcompany[$i] = OCIResult($lort5,"COUNT");

When I look manually in the DB, I get this result:

COUNT(SALESPERSON)

409

Any ideas ?

/mich