Re: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-22 Thread Thies C. Arntzen 

On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote:
 
 On Mon, 21 May 2001 16:39:05 +0200
 Thies C. Arntzen [EMAIL PROTECTED] wrote:
 
  On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
   Hi;
 Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
 
 I use the following lines to get a result from database;
   But It give me result 0, it is incorrect;
   
   $sql=Select count(*) From member where email=:email;
   $sth=OCIParse($dbh,$sql);
   OCIBindByName($sth,email,$email,64);
   // with or without ':' is same, and use reference or not is also same here.
   OCIExecute($sth);
   OCIFetchInto($sth,$data);
  
  have you set $email in your script (before OCIExecute)?
 
 I have set the $email before OCIParse().
 
 Is there any problem about the varchar2 data type in bind operation?

it works for me - could you send me a _short_ but complete
testcase that reproduces your problem?

tc

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung 

Hi;
Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.

I use the following lines to get a result from database;
But It give me result 0, it is incorrect;

$sql=Select count(*) From member where email=:email;
$sth=OCIParse($dbh,$sql);
OCIBindByName($sth,email,$email,64);
// with or without ':' is same, and use reference or not is also same here.
OCIExecute($sth);
OCIFetchInto($sth,$data);

but when I directly use the $email in sql, without OCIBindByName, like the
following, it give me result 5, it is correct.

$sql=Select count(*) From member where email='$email';
$sth=OCIParse($dbh,$sql);
OCIExecute($sth);
OCIFetchInto($sth,$data);

email is char(64) in database.

where is the problem?

Thanks in advance.

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Thies C. Arntzen 

On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
 Hi;
   Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
   
   I use the following lines to get a result from database;
 But It give me result 0, it is incorrect;
 
 $sql=Select count(*) From member where email=:email;
 $sth=OCIParse($dbh,$sql);
 OCIBindByName($sth,email,$email,64);
 // with or without ':' is same, and use reference or not is also same here.
 OCIExecute($sth);
 OCIFetchInto($sth,$data);

have you set $email in your script (before OCIExecute)?

tc

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re[2]: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung 


On Mon, 21 May 2001 16:39:05 +0200
Thies C. Arntzen [EMAIL PROTECTED] wrote:

 On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
  Hi;
  Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
  
  I use the following lines to get a result from database;
  But It give me result 0, it is incorrect;
  
  $sql=Select count(*) From member where email=:email;
  $sth=OCIParse($dbh,$sql);
  OCIBindByName($sth,email,$email,64);
  // with or without ':' is same, and use reference or not is also same here.
  OCIExecute($sth);
  OCIFetchInto($sth,$data);
 
 have you set $email in your script (before OCIExecute)?

I have set the $email before OCIParse().

Is there any problem about the varchar2 data type in bind operation?

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]