[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