Re: Handling data returned by multi-select box

Hi, you can use the implode function, you have 2 options.

1. Modify app_model.php , the save() function:
Modify the line: list($fields[], $values[]) = array($x, $y);

into

function save($data = null, $validate = true, $fieldList = array()) {
....
foreach ($this->data as $n => $v) {
....
foreach ($v as $x => $y) {
if ($this->hasField($x) && (empty($this->whitelist) ||
in_array($x, $this->whitelist))) {
if(!empty($y) && is_array($y)) {
list($fields[], $values[]) = array($x, implode(",",$y));
} else {
list($fields[], $values[]) = array($x, $y);
}

....
}

This will apply for all tables and all columns

2. Modify inside individual controller classes, specify which fields
need to apply the change:

<?php
class CatalogueMenusController extends AppController {

var $multiples = array('fiedl1','field2);
var $formName = "CatalogueMenu";

.....
function edit($id = null) {
.....
if (!empty($this->data)) {
foreach($this->multiples as $m) {
$this->data[$this->formName][$m] =
implode(",", $this->data[$this->formName][$m]);
}

if ($this->CatalogueMenu->save($this->data)) {
...
}
}

On Feb 25, 4:11 am, autnoc <aut...@gmail.com> wrote:
> If I dump out the array, it returns the correct values within the
> array - just integers.
>
> Problem is, I don't know how to process the values of the array to
> pass into the update query.  So, if I have an array being generated
> that looks like Array (1,3,4), how do I insert it into the update
> query as UPDATE ... WHERE ... VALUES (id, '1,3,4') instead of ...
> VALUES (id, Array) which is being returned now.
>
> Sorry, if I'm being unclear here, I can answer any other specific
> questions if you have any.
> Thanks for the reply!
>

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

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