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.

what is in the $search variable?

You'll need to make sure it's an exact search, just as when you search for an email address.

I've used this in FX.php many times, and I would imagine the same will work in the API as well:

EXAMPLE:

$search = 'apple;pear;orange';

$findcom->addFindCriterion('field1',"==" $search);

Bob Patin

Longterm Solutions

[email protected]

615-333-6858

http://www.longtermsolutions.com

Member of FileMaker Business Alliance and FileMaker TechNet

CONTACT US VIA INSTANT MESSAGING:

AIM or iChat: longterm1954

Yahoo: longterm_solutions

MSN: [email protected]

ICQ: 159333060

--------------------------

Contact us for FileMaker hosting for all versions of FileMaker

PHP • CDML • Full email services • Free DNS hosting • Colocation • Consulting

I don't think that's the issue here.

There are NO records being returned. An exact search would return fewer records in any case.