FX.php -- find fails when searching for e-mail

[DanBrill]

I'm using FX.php and I'm trying to perform a find by an e-mail address submitted on a form. But it isn't working.

For example:

<?php

$validate = new FX($FMAddress, $FMPort);

$validate -> setDBUserPass('User' , $FMPassword);

$validate -> setDBData('CabiNet.fp7' , 'WebLogin');

$validate -> AddDBParam('UserEmail' , $userEmail);

$validate -> AddDBParam('Password' , $password);

$validateResult = $validate -> FMFind();

echo "<pre>nn";

print_r ($validateResult);

echo "</pre>nn";

?>

This fails to find any matches. There seems to be a problem with the @ sign. If I change my email to danatmydomain.com it works. But [email protected] fails.

If I use FMFindAll() the e-mail address shows up in the array with the @ symbol I'd expect.

Any ideas?

Thanks,

Dan

[surwoop]

The @ symbol is a reserved character (used for searching for 1 character). Indexing the field with unicode works in FileMaker, not sure about over the web.

[DanBrill]

Hey, thanks for your reply. I switched the indexing to unicode and it works just right! Thanks a million!

Dan