[cvs] commit: whups/lib/Driver sql.php

[Jon Parise]

jon         2004/03/16 00:16:35 PST

  Modified files:
    lib/Driver           sql.php 
  Log:
  In getUserSearches(), we don't want to pass 'false' or an empty string to
  the database (especially PostgreSQL, which will return a type operator
  error), so return an empty array immediately if $user is empty.
  
  This can happen because we pass the result of Auth::getAuth() directly to
  getUserSearches(), and that may be 'false'.
  
  Under PostgreSQL, this would result in an error such as (note the
  'user_uid = FALSE' in the predicate):
  
  DB Error: unknown error: SELECT search_name, search_getvars  FROM
  whups_users_searches WHERE user_uid = FALSE [nativecode=ERROR:
  operator does not exist: character varying = boolean HINT:  No
  operator matches the given name and argument type(s). You may need to
  add explicit type casts.
  
  Revision  Changes    Path
  1.150     +11 -2     whups/lib/Driver/sql.php

  Chora Links:
  http://cvs.horde.org/diff.php/whups/lib/Driver/sql.php?r1=1.149&r2=1.150&ty=u