ActiveDataProvider stays empty..

I did some scaffolding on the paypalpayement extension… and it returns nothing untill i comment out this table

$criteria->compare(‘quantity’,$this->quantity);

quantity int(11) NOT NULL default ‘0’,

Entire table looks like this:




CREATE TABLE IF NOT EXISTS `paypal_payments` (

  `id` int(11) NOT NULL auto_increment,

  `payer_id` varchar(60) default NULL,

  `payment_date` varchar(50) default NULL,

  `txn_id` varchar(50) default NULL,

  `first_name` varchar(50) default NULL,

  `last_name` varchar(50) default NULL,

  `payer_email` varchar(75) default NULL,

  `payer_status` varchar(50) default NULL,

  `payment_type` varchar(50) default NULL,

  `memo` tinytext,

  `item_name` varchar(127) default NULL,

  `item_number` varchar(127) default NULL,

  `quantity` int(11) NOT NULL default '0',

  `mc_gross` decimal(9,2) default NULL,

  `mc_currency` char(3) default NULL,

  `address_name` varchar(255) NOT NULL default '',

  `address_street` varchar(255) NOT NULL default '',

  `address_city` varchar(255) NOT NULL default '',

  `address_state` varchar(255) NOT NULL default '',

  `address_zip` varchar(255) NOT NULL default '',

  `address_country` varchar(255) NOT NULL default '',

  `address_status` varchar(255) NOT NULL default '',

  `payer_business_name` varchar(255) NOT NULL default '',

  `payment_status` varchar(255) NOT NULL default '',

  `pending_reason` varchar(255) NOT NULL default '',

  `reason_code` varchar(255) NOT NULL default '',

  `txn_type` varchar(255) NOT NULL default '',

  `custom` int(11) default NULL,

  `paypal_response` varchar(125) NOT NULL,

  `correct_price` int(1) NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `txn_id` (`txn_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;



Is it a bug or is there something wrong with the table 0_o

if you write


$criteria->compare('quantity',$this->quantity);

the comparison will be done by exact match, so if the field is empty nothing is returned.

You should use


$criteria->compare('quantity',$this->quantity, true);

for partialMatch.