Re: [phplib] 7.2c Problem with oci8 and sessions From: M. Brian Akins (bakins <email protected>)
Date: 07/19/00

I replaced
    $squery = sprintf("select count(*) from %s where val='%s' and changed='%s' and sid='%s' and name='%s'",
      $this->database_table,
      $str,
      $now,
      $id,
      $name);

with

   $squery = sprintf("select count(*) from %s where changed='%s' and sid='%s' and name='%s'",
      $this->database_table,
      $now,
      $id,
      $name);

in ct_sql.inc

Oracle doesn't like doing equaities on longs. I hope this doesn't break too
much. Any suggestions?

On Wed, 19 Jul 2000, M. Brian Akins wrote:
> The first time a user hits a page they get the following error:
>
>
>
> ORA-00997: illegal use of LONG datatype
> Query :"select count(*) from active_sessions where
> val='U29sb19TZXNzaW9uOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy0+cHRbJ2F1dGgnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBTb2xvX0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA9ICdmb3JtJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnMjE0NzQ4MzY0Nyc7IA=='
> and changed='20000719100726' and sid='1b36a7a7f8b1d0a303a6220cef6989c0' and name='Solo_Session'"
>
> When the log in or refresh it's fine.
>
> Thanks.
>
> --
> M. Brian Akins
> Senior Development Engineer
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected> 

-- 
M. Brian Akins
Senior Development Engineer

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>