RE: [PEAR] DB_DO_FB and fields in crossTables
| From: | Sönke Ruempler | Date: | Fri, 26 Nov 2004 14:08:34 +0000 |
| Subject: | RE: [PEAR] DB_DO_FB and fields in crossTables | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-15834@lists.php.net to get a copy of this message | ||
Sönke Ruempler wrote on Thursday, November 25, 2004 1:43 PM:
> Hi,
>
> I'm exploring DB_DataObject_FormBuilder and there occured a
> question to me:
>
> Is it possible to have more fields thea the 2 Ids in the
> Crosslink-Table. Example:
>
> [user]
> user_id
> name
>
> [user_products]
> user_id
> prod_id
> vote
>
> [products]
> prod_id
> title
> ...
>
> Here is the field 'vote' how a user voted for a product (maybe a silly
> example but it shows what I mean). Any ideas?
Ok, a new problem occured to me:
I noticed that FormBuilder deletes all old crossLinks and adds the new on
update. So every additional data in the cross-table is lost on update.
I think FB should notice which fields are added/deleted and not the quick
and dirty way.
--
soenke