package IssueBot::Channels;
use base 'IssueBot::DBI';
__PACKAGE__->table( "channel_prefs" );
__PACKAGE__->columns( ALL => qw(idno channel channelpass loginon greeton active subscriber_ids server_id) );
__PACKAGE__->add_searcher( search  => "Class::DBI::Search::Basic" );

##</code><code>##

use DBD::SQLite;      
use Class::DBI;
use IssueBot::DBI;
use IssueBot::db_functions;
IssueBot->connection("dbi:$db_type:$db_name");

my $true='true';
my $channel_it = IssueBot::Channels->search( active => $true, subscriber_ids => '10000' );

##</code><code>##

DBD::SQLite::db prepare_cached failed: near "FROM": syntax error(1) at dbdimp.c line 271 [for Statement "SELECT 
FROM   channel_prefs
WHERE  active = ? AND subscriber_ids = ?
"] at /usr/local/lib/perl5/site_perl/5.8.8/Ima/DBI.pm line 398.

##</code><code>##

my @active_channels = IssueBot::Channels->retrieve_from_sql(qq{
    active = 'true' AND
    subscriber_ids like "%10000%"
  });

##</code><code>##

DBD::SQLite::db prepare_cached failed: near "FROM": syntax error(1) at dbdimp.c line 271 [for Statement "SELECT 
FROM   channel_prefs
WHERE  
    active = 'true' AND
    subscriber_ids like "%10000%"
  
"] at /usr/local/lib/perl5/site_perl/5.8.8/Ima/DBI.pm line 398.