[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