Question
Advanced Dynamic Search
I use ASP VBscript.. SQL2000
And I'm trying to allow customers to search our database for products:
Dynamic Query... It's easy for me to create a basic search where the
exact phrase is returned or something relatively similar is returned.
For example, if I use the wildcard, I can extend my ability to give the
customer what they want but it would be nice to offer more.
I need the customers to be able to search for something more
complex...:' Since I don't know how many words the customer will use,
I'm not sure how to do it.
(one, two, three)
or (one two three)
or ("one two three")
Basically, something like what you would find on google's search or Tom
Muck offers an extension and I'm trying to contact him about
functionality with stored procedures. He's basically created an
extension that does almost exactly what I want but since I use stored
procedures, I would need to rig it to work. Link to his extension below.
http://www.tom-muck.com/extensions/help/dynamicsearchasp/
Anyone have an idea if I something like this is possible without too
much bone-crunching effort?
And I'm trying to allow customers to search our database for products:
Dynamic Query... It's easy for me to create a basic search where the
exact phrase is returned or something relatively similar is returned.
For example, if I use the wildcard, I can extend my ability to give the
customer what they want but it would be nice to offer more.
I need the customers to be able to search for something more
complex...:' Since I don't know how many words the customer will use,
I'm not sure how to do it.
(one, two, three)
or (one two three)
or ("one two three")
Basically, something like what you would find on google's search or Tom
Muck offers an extension and I'm trying to contact him about
functionality with stored procedures. He's basically created an
extension that does almost exactly what I want but since I use stored
procedures, I would need to rig it to work. Link to his extension below.
http://www.tom-muck.com/extensions/help/dynamicsearchasp/
Anyone have an idea if I something like this is possible without too
much bone-crunching effort?
AdChoices