[Tickets #606] Typecasting required in whups/lib/Driver/sql.php on Oracle

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=606
-----------------------------------------------------------------------
 Ticket     | 606
 Updated By | rvs at angara.ru
 Summary    | Typecasting required in whups/lib/Driver/sql.php on Oracle
 Queue      | Whups
 State      | Feedback
 Priority   | 2. Medium
 Type       | Bug
 Owners     | Chuck Hagenbuch
-----------------------------------------------------------------------


rvs at angara.ru (2004-09-24 02:07) wrote:

Hmm, I just have one idea - using LIKE operator here instead of comparison.
This causes implicit conversion to char type for ID fields,
and probably is much more portable than explicit typecasting.
For example (whups/lib/Driver/sql.php, line 822):

        $join .= 'LEFT JOIN whups_queues ON whups_logs.log_type = \'queue\'
AND whups_logs.log_value LIKE whups_queues.queue_id ';

I don't pretend that this idea is clever enough, however it may be a
solution :-)