qurymultiselect

Hi,

I have a querymultiselect which is causing some issues when the innerhtml of the select is updated from Ajax.

I first start with a blank select, and when the user enters a value in a different field there is a trigger to update the dropdown which works fine, the contents on the <select is basic no grouping, only two rows with values 1,2

After I make a select and save there is no change to the profile, I see the _POST from comprofiler.class.php so confirm that the multiselect values were selected.

However, on the admin/saveSafely function 'edit' the values have been removing and so when the record is saved the field is now blank.

Anyone got any ideas as to why I can not save and updated select.

I have added as a default 2 rows testa,testb with values 1,2 If I go a head and Ajax the content and update the list keep if I set a value to the same as the default this works fine, as soon as I change the 'value' nothing is saved, really struggling on this.

I was looking for the actial save 'from when I edit' so I can see the exact sql query to see its contents.

Via joomla debug I see the query which the value ''.

If I can find the UPDATE #__com... sql then I can work backwards to see why the values are being dropped.

Received into saveSafely ( [cb_companylink] => Array ( [0] => 5 [1] => 2 )
and $this [cb_companylink] => - from library/cb/cb.tables.php

CB has protection against injections like that. You can't just add options with jQuery and they store otherwise anyone could easily edit the DOM and add whatever they want. CB runs prepareFieldDataSave (field save function), which checks that the values sent in the POST actually exist in the field. Your ajax usage needs to be properly built into CB Query Field using the Ajax response endpoint (fieldClass field function) to properly rebuild the list of options.