[FX.php List] search on a number field with text

Someone someone at gagayaya.com
Thu Mar 9 16:03:02 MST 2006


Hi,
It's been awhile since if posted. Just started a new project.
Not sure if this has come up.

During testing by accident a added some text to a number  
(searchone.php?arin_invnum=204587aaa)

And did an equal search.
$FXQuery->AddDBParam('arin_invnum', $_GET['arin_invnum'],'eq');
$ReturnedData = $FXQuery->FMFind();

Strange result. It found the record where the field  
'arin_invnum' (number field) is 204587

So I decided to test the find with the field 'arin_invnum'  as a text  
field and got a different result. Found Count ZERO.

Interesting.

Frank




More information about the FX.php_List mailing list