RE: [PHP-DB] OCI Binding problem

Sorry, trigger happy.  Also try ":postalcode" in uppercase.

Neil

-----Original Message-----
From: Juffermans, Jos [mailto:jjuffermans@chellomedia.com]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Binding problem

Hi,

Imagine this code:

<?php
$database_connection = ocilogon("username", "password", "connection
string");
// the actual connection code is slightly different but that is not
relevant to my problem

$postalcode = "3055";

// option 1: paste the postalcode into the query:
$rowset1 = array();
$statement1 = ociparse($database_connection, "SELECT services FROM
location WHERE postalcode='" . $postalcode . "'");
ociexecute($statement1);
ocifetchstatement($statement1, &$rowset1, 0, 100, OCI_ASSOC |
OCI_FETCHSTATEMENT_BY_ROW);
// at this stage $rowset1 contains some records from the table

// option 2: use namebinding:
$rowset2 = array();
$statement2 = ociparse($database_connection, "SELECT services FROM
location WHERE postalcode=:postalcode");
ocibindbyname($statement2, ":postalcode", &$postalcode, 4);
ociexecute($statement2);
ocifetchstatement($statement2, &$rowset2, 0, 100, OCI_ASSOC |
OCI_FETCHSTATEMENT_BY_ROW);
// at this stage $rowset2 is still an empty array ?>

Both queries should result in the same data but as soon as I use the binding
no rows are returned. I can't see what I'm doing wrong here. Can someone
help me?

Jos

--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php