Hmm - no suggestions? Or maybe I should have chosen a different title
for this thread...
I realised that the problem is exacerbated when you use forms to add/
change data - the html helper doesn't seem to support strings like
'Merchant/0/id', and 'Merchant/id' is of course ambiguous - does it
refer to the current merchant or one of the related merchants? (I'm
using 1.1 btw).
Surely someone has run into this problem before?
On Aug 9, 5:46 pm, David <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> Yep, another HABTM question I'm afraid... but I haven't been able to
> find the answer to this one on the group, so maybe it hasn't been
> brought up yet :)
>
> My app contains a model merchants, each of which hasAndBelongsToMany
> related merchants. No problem, I just use this code in the merchant
> model:
>
> var $hasAndBelongsToMany =
> array('Merchant'=>array('classname'=>'Merchant',
> 'joinTable'=>'related_merchants', 'foreignKey'=>'merchant1_id',
> 'associationForeignKey'=>'merchant2_id'));
>
> The problem comes when the data is retrieved from the DB. Imagine
> 'merchants' had a conventional HABTM relationship with 'customers'. we
> would have:
>
> $data['Merchant'] (containing the data about the merchant)
> $data['Customer'] (containing an array of the associated customers)
>
> However, with the related merchants their information is put inside
> the $data['Merchant'] array! So we have
>
> $data['Merchant']['id'] (id of the merchant)
> $data['Merchant']['name'] (name of the merchant)
> $data['Merchant'][0] (array containing the info for the first related
> merchant)
> $data['Merchant'][1] (array containing the info for the second related
> merchant)
> etc.
>
> I think this is messy and would prefer to have something like:
>
> $data['Merchant'] (containing the data about the merchant)
> $data['RelatedMerchant'] (containing an array of the related
> merchants)
>
> Does anyone know how to do this?
>
> Thanks!
>
> David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
