I have used the implode menu extension on a page to insert multiple records into a single database field with a comma and space as the delimiter - works great!
My problem lies in retrieving the records on a search results page. Users select an area in which to search and a category, but I am not getting any results in my test.
On my results page do I need to 'explode' the stored values? If so can you point me in the right direction as to how to do this?
It depends on your search, if you are searching one of the imploded items, assume that this will be a string, you will have to use a correct query for this, in such a case in the query you should use something like:
mycolumn = '%mydata%'
If you are not serching some of the imploded data a normal query will return the entire string.
You will use the Get Dynamic Multi Selection when you must retrieve the imploded selection on a list/menu.