DKK

Hi, one of my fields contain data with semi-colon such as: apple;ball;cat apple;ball Within the PHP page, I added a search criterion using astericks such as: $findcom->addFindCriterion('field1', '*' . $search . '*'); ...but this doesn't seemed to work. The return page says no record found but using the find command within the fat filemaker client, I can see the records. Anyone can help? I'm stucked big time. Thanks.

Hi, I tried using "!=" as the not equal operator for finding records via php pages, however, it doesn't seemed to work. My code is as follows: $findCom = $fm->newFindCommand('abcLayout'); $criterion = "!=" . "testvalue"; $findCom->addFindCriterion("field", $criterion); $result=$findCom->execute() All other operators such as "begin with", "contains" etc worked, except "not equal". I have also tried the following but it didn't work either. $criteron = "omit, "; Would someone be able to advise? Thanks a lot.

Hi, I have a set of checkboxes in a HTML that I post to a PHP page. I can strip out the individual values. These values need to be passed to a PHP filemaker for searches? The question is, how do I create a multiple value FIND on a single field? $findCommand = $fm->newFindCommand('layout'); $findCommad->addFindCriterion('Field1', $value1); $findCommad->addFindCriterion('Field1', $value2); $result = $findCommand->execute(); $records = $result->getRecords(); The script above doesn't seemed to work as $value2 will overwrite $value1. I also tried using CompoundFind but kept getting the error : [color:red]Notice: Undefined property: FileMaker_Command_FindRequest_Implementation::$_omit in /Library/FileMaker Server/Web Publishing/publishing-engine/php/lib/php/FileMaker/Implementation/Command/CompoundFindImpl.php on line 27 Can anyone advise? Thanks.