On Sat, Feb 24, 2001 at 05:43:58PM +0100, Sven Voigt wrote:
> On Friday 23 February 2001 17:03, you wrote:
> > I suppose the authors never concieved a replacement parameter for select
> >
> > specification.
> >
> > try:
> > > $sql =3D "select foo, bar, rid from masterdata WHERE rid=3D:rid"
> >
> >
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 how
On Friday 23 February 2001 17:03, you wrote:
> I suppose the authors never concieved a replacement parameter for select
>
> specification.
>
> try:
> > $sql =3D "select foo, bar, rid from masterdata WHERE rid=3D:rid"
>
> You need to loose the colon ":" or place it to the right of a where cla
> use
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
F114C0EF28F3D211B7E8400061
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);
OCIBindByName($stmt,":
