[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]ZeusChicago[/eluser]
Hum, ok using your count($object->all) suggestion the following

Code:

$subModel = new Subscription();
        $subscriptionWhere = ('fa_user_id =' .$this->db_session->userdata('id'));
        $subModel->where($subscriptionWhere);
        $subModel->order_by('startdatetime','DESC');
        $subModel->join_related('subscriptiontypes')->get();
        $this->data['previousSubDataCount'] = count($subModel->all);
        $this->data['previousSubData'] = $subModel->all;
        
        foreach($subModel->all as $test){
            echo $test->subscriptiontype_displayname ."|" . date("m/d/y",strtotime($test->startdatetime)) . "|". date("m/d/y",strtotime($test->enddatetime));
        }

$this->data['previousSubDataCount'] does return 1
$this->data['previousSubData'] does contain 1 record

however, in the profiler window, the following query is returned from the above

Code:

SELECT `subscriptions`.*, `subscriptiontypes`.`ID` AS subscriptiontype_ID, `subscriptiontypes`.`NAME` AS subscriptiontype_NAME, `subscriptiontypes`.`PRICE` AS subscriptiontype_PRICE, `subscriptiontypes`.`displayname` AS subscriptiontype_displayname, `subscriptiontypes`.`description` AS subscriptiontype_description
FROM (`subscriptions`)
LEFT OUTER JOIN `subscriptiontypes` as subscriptiontypes ON `subscriptiontypes`.`id` = `subscriptions`.`subscriptiontype_id`
WHERE `subscriptions`.`fa_user_id` =1
ORDER BY `subscriptions`.`startdatetime` DESC

Which when I copy and run in phpmyadmin does in fact return the two rows I am expecting

Code:

ID    fa_user_id    subscriptiontype_id    startdatetime     enddatetime    paypaldata    subscriptiontype_ID    subscriptiontype_NAME    subscriptiontype_PRICE    subscriptiontype_displayname    subscriptiontype_description
33    1    3    2009-09-11 13:02:40    2009-10-11 13:02:40    mc_gross=4.99^|^protection_eligibility=Eligible^|^...    3    ONETIME    30|15.99    One Time Ad    Select this package if you have just one ad you wo...
32    1    2    2009-08-04 10:59:19    2009-09-04 10:59:19    NA^|^NA    2    TRIAL    30|0|180|0|365|0    30 Day Free Trial    We our offering, for a limited time a 30 day free ...