fpcgi

[Nancy Palmquist]

Steven Waters wrote:
> Hello,
> Is there a command that can be used with fpcgi
> to get a fuzzy type search. I am searching by Part Number
> currently. If someone searches by 123-001 they find the P/N.
> If they search by 123001 no records are found. Can someone
> point me in the right direction for a solution.
> Thanks,
> Steve
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 

Steven,

This is a programming issue and using edits and indexing it should be 
solvable.

You have to make the data predictable.  I had a system where the data 
included claim numbers and it was sometimes typed with spaces, dashes or 
periods at given points in the numbers.  To insure that no matter what, 
we could find the claim, I remove all puncuation and replace it with a 
space. It is still readable, but is much more predictable.

I use the same edit on the data before applying it to the index.  It has 
made the use of an index to find a claim by number much more reliable.

Part Numbers and other unique identifiers must be made predictable and 
they must be controlled sufficiently to provide an exact, unique match 
when an item is required.

FilePro does sell a product that will allow you to apply the filePro 
edits to web page data entry.  It is called jPedits.  It might be of 
interest to you, but might not be necessary if you apply a filePro side 
solution.

I have a second thought, you could store the item number in two forms, 
one with the puncutation and one without, building an index on both.  If 
you do not match the first, then try the second.  That might just do the 
trick.  The item number would only be assigned once so the addition of 
a second field would not be a big programming issue.

Nancy

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com