搜索文本框中给出的多个单词，并在Bing MAP上显示结果 [英] Search Multiple Words given in the textbox and show the result on Bing MAP

问题描述

朋友，

我有一个文本框，我必须在其中输入一个单词(例如Red)或多个单词(Mark Red Elk)来搜索属性.

问题是，当我搜索单个单词(如标记")时，它会在MAP上显示该属性.

但是当我输入多个单词时，例如-Mark Red Elk(其中Mark是名称，Red是颜色，Elk是制造商.它不会显示任何结果.

谁能帮我找出多个单词的结果.

我已经在STORED PROCEDURE中使用了LIKE关键字，但是它搜索单个单词.

忘记MAP了，只帮助我找出文本框值的结果........


谢谢，
S SAXENA

Hi Friends,

I have a Textbox in which i have to type a word(like Red) or multiple words (Mark Red Elk) for searching the property.

Problem is that when i search a single word like-Mark it display the property on the MAP.

But when i type Multiple words like- Mark Red Elk (where Mark is name, Red is color and Elk is manufacturer. It will not showing any result.

Can anybody help me to find out the result for multiple words.

I already used LIKE keyword in the STORED PROCEDURE but it search single word.

Forget the MAP and just help me to find out the result of the textbox value........


Thanks,
S SAXENA

推荐答案

like关键字将进行完全的术语匹配，这不是模糊搜索.

解决这个问题的方法可能更好，但这是其中的一种.

1)在存储的proc (在此处起作用) [ ^ ]和将它们放在临时表中
2)创建一个临时表来保存您的最终搜索结果
3)遍历临时表中的搜索词，并为每个搜索词将搜索结果添加到最终结果表中.
4)选择并返回最终结果表

干杯.

The like keyword will do a complete term match, it''s not a fuzzy search.

There are likely better ways to tackle this, but here''s one.

1) Split the string in the stored proc (function here)[^] and put them in a temp table
2) Create a temp table to hold your final search results
3) Loop through the temp table with the search terms and for each one, add the search results to the final results table
4) Select and return the final results table

Cheers.

这篇关于搜索文本框中给出的多个单词，并在Bing MAP上显示结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！