B
Ben Fidge
Hi
I'm working on a site which requires the users to specify a hotel at which
they're staying in London. The complete list of hotels comes to something
like 1600 records. Each record consists of Hotel Name, Street Address and
Postcode.
We need to make it as simple as possible for users to pick their hotel, but
I don't want to put 1600 hotel names in a drop-down list, and we have to
consider the fact that not every user is going to know the full name and
address of their hotel. Furthermore, we have to assume that misspellings
will be common and also the shortening of address elements. For example,
"Road" could be entered as "Rd", "Rd." or "Road"
"Street" could be "St", "St." or "Street"
"Lane" could be "Ln", "Lne" or "Lane" etc
Taking all these scenarios and requirements into hand can anyone suggest a
fool-proof yet easy to use mechanism for providing this sort of search
capability on a web-page?
I'm using ADO.NET to interface to Sql Server 2000 db. Would Full-text
indexing on this table be of any use?
I'm intersted to know how people would go about this themselves.
Thanks
Ben
I'm working on a site which requires the users to specify a hotel at which
they're staying in London. The complete list of hotels comes to something
like 1600 records. Each record consists of Hotel Name, Street Address and
Postcode.
We need to make it as simple as possible for users to pick their hotel, but
I don't want to put 1600 hotel names in a drop-down list, and we have to
consider the fact that not every user is going to know the full name and
address of their hotel. Furthermore, we have to assume that misspellings
will be common and also the shortening of address elements. For example,
"Road" could be entered as "Rd", "Rd." or "Road"
"Street" could be "St", "St." or "Street"
"Lane" could be "Ln", "Lne" or "Lane" etc
Taking all these scenarios and requirements into hand can anyone suggest a
fool-proof yet easy to use mechanism for providing this sort of search
capability on a web-page?
I'm using ADO.NET to interface to Sql Server 2000 db. Would Full-text
indexing on this table be of any use?
I'm intersted to know how people would go about this themselves.
Thanks
Ben