RE: OCI Binding problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Since flags are normally bitmaps, FLAG1 | FLAG2 should have the same result
as FLAG1 + FLAG2. I've tried your suggestion anyway but it had no result.

I've also tried to uppercase :postalcode (in the query and in the bindbyname
call) but that didn't help either.

Jos


-----Original Message-----
From: N.A.Morgan@xxxxxxxxxx [mailto:N.A.Morgan@xxxxxxxxxx]
Sent: 20 April 2005 13:40
To: jjuffermans@xxxxxxxxxxxxxxx; php-db@xxxxxxxxxxxxx
Subject: RE:  OCI Binding problem


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

Neil 

-----Original Message-----
From: Juffermans, Jos [mailto:jjuffermans@xxxxxxxxxxxxxxx] 
Sent: 20 April 2005 12:18
To: 'php-db@xxxxxxxxxxxxx'
Subject:  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

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux