FileMaker is more than happy to set users up with “value lists,” which coyly store multiple values in a field — a concept that’s pretty much anathema to “real” databases. Values in the list are separated by a weird ascii character. To forge a bridge b/w MySQL and FileMaker, wrote a routine to grab each element in a form array and insert this weird character between each. If all elements were named perfectly, FM would show the proper boxes checked upon data import. In a prior incarnation of this system, data was output from MySQL to a web page, then imported into FM. But now that this weird ascii character is present, we were getting inconsistent results. After much sleuthing, turned out that some browsers (Make 7 Up Yours, IE/Mac) were conveniently discarding the special character, so nothing matched on import. Rewrote the app to write the export to a text file on the server, the offer the file for download, taking browser discrepancies out of the mix.
Music: Black Cat Orchestra :: Sanfonando