RE: [PEAR] FormBuilder and Datagrid - more questions

From: Date: Sun, 27 Nov 2005 09:29:08 +0000
Subject: RE: [PEAR] FormBuilder and Datagrid - more questions
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-22086@lists.php.net to get a copy of this message
> I've also done this in DB_DO_FB_Frontend. I also don't search on linked fields. You'd have to come up with your own way... OK, did that and it works great for ONE table only..... All the scripts are identical except for the table/columns rendered by SDG. Club is the 'linked to' table with FB linkDisplayFields array, 'name' in its DO. There is a record in this table with 'club_id'= 5 whose 'name' contains the letters '2nd'. Both Clubsfin and Rule tables have a number of records, one (or more) of which has club_id = 5. Using whereAdd, selectAdd and joinAdd, the DO's sent to SDG to fetch contain: DataObjects_Clubsfin Object [_query] => Array ( [condition] => WHERE ( club.name LIKE '%2nd%') OR federation LIKE '%2nd%' OR fedclubno LIKE '%2nd%' OR memyearfrom LIKE '%2nd%' OR memyearto LIKE '%2nd%' [_join] => INNER JOIN club ON club.club_id=clubsfin.club_id DataObjects_Rule Object [_query] => Array ( [condition] => WHERE ( club.name LIKE '%2nd%') OR name LIKE '%2nd%' OR rule LIKE '%2nd%' [_join] => INNER JOIN club ON club.club_id=rule.club_id [_lastError] => ) <br /> <b>Fatal error</b>: Unsupported operand types in <b>PEAR\Structures\DataGrid\Core.php</b> on line <b>152</b><br /> Clubsfin works perfectly every time. The data is returned, the correct page/record count displayed and the sort feature works. Copying the Clubsfin function that builds the query to the Rule script results in the fatal error everytime. Copying the SDG columns-to-render from Rule into the Clubsfin script and renaming as Rule results in the fatal error every time. Removing the new SDG page count feature from the script removes the error but even tho a record exists, no data is returned by Rule. Clubsfin still returns the record with '2nd' in the club.name field but does not display the page count. Please help. What am I missing here? Prue

« previous php.pear.general (#22086) next »