Posted by Tom van Stiphout on 01/12/08 16:48

On Fri, 11 Jan 2008 22:47:45 -0800 (PST), akk2006@gmail.com wrote:

You don't mention what tool you are developing your application in,
but most tools would allow you to create a dropdown with a hidden
BusinessTypeID and a visible BusinessType column, and then you can
have the users select from that list. No spelling errors possible.

-Tom.


>I have table that stored business types. I use full text search in
>that table . I can find the business type but when user enter the
>worng word or not complete word like 'hosp' for 'hospital', at that
>time I can't handle . if I use " contains(bus_type,'"hosp*"') " its
>ok. But
>for "car" its display "car" ,"care","caraok" and so on .How should I
>do. I want to know how to spell correct the user input string if I can
>get that function it ok.
>
>
>waiting for guru

• Next in forum: Limit use of memory cache
• Prev in forum: Re: Create Delete Trigger on Table1 to Update a filed on Table2
• Thread view: Re: check the word whether correct or not

[Reply to this message]