The the colon has special meaning.
Look up the OCI man page, specifically - look up the OCIBindByName
function.
http://www.php.net/manual/en/ref.oci8.php
It may give you a hint for the use of the colon and it's use in positioning
bound variables.
--
Without knowing your table structure and
Hi there!
I am using the following code on SuSE 6.4, Apache 1.3.14 and PHP 4.0.4:
# $sql is dyanmically built, e.g.
$sql = "select foo, bar, :rid from masterdata";
$db = OCILogOn("picht","picht");
$stmt = OCIParse($db, $sql);
$rowid = OCINewDescriptor($db,OCI_D_ROWID);
I suppose the authors never concieved a replacement parameter for select
specification.
try:
$sql = "select foo, bar, rid from masterdata WHERE rid=:rid"
You need to loose the colon ":" or place it to the right of a where clause.
[EMAIL PROTECTED] wrote in message