RE: [PEAR] FormBuilder and Datagrid - more questions
| From: | Prue | 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