Monday, April 5, 2010

Yet another HABTM multiple checkbox query, cakePHP 1.3 RC3

I'll apologise now! There seems to be loads of advice about HABTM in
cake, but I still can't quite get the answer to my particular problem.

I have two tables and a join_table. On my view, I have created a
form, which has a multiple checkbox. The problem I am having is that
this is not returned in a format that I can save it in.

Using debug($this->data), I get this returned to my edit action:

Array
(
[PortfolioEntry] => Array
(
[id] => 78
[when] => Array
(
[day] => 04
[month] => 04
[year] => 2010
)

[title] => Another test
[description] => Hmmmm, will this work I wonder? It
might, although if you do not include full stops it doesn't!
[benefit] => Hello mucker.
[activity_id] => 2
)

[KsfDimensionsPortfolioEntry] => Array
(
[portfolio_entry_id] => 78
[ksf_dimension_id] => Array
(
[0] => 36
[1] => 37
[2] => 38
[3] => 39
)

)

)

The PortfolioEntry bit is saved absolutely fine, however, when I try
to update the join_table with the KsfDimensionsPortfolioEntry part, I
get an SQL error, since the ksf_dimension_id is an array.
I am pretty sure that this array should be something like:

[KsfDimensionsPortfolioEntry] => Array
(
[0] => array(
[portfolio_entry_id] => 78
[ksf_dimension_id] => 36
(
[1] => array(
[portfolio_entry_id] => 78
[ksf_dimension_id] => 36
)
etc....

but I can't for the life of me come up with a 'cake' way of doing it!
Any assistance would be gratefully received.

Cheers.

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

To unsubscribe, reply using "remove me" as the subject.

No comments: