Advanced Dynamic Search

Report · Feb 25, 2008

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?

Report · Feb 26, 2008

Art wrote:
> 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")

This is something I have been planning on doing too, with Stored
Procedures, and I am hoping its not a major headache. If I find anything
I will post it here.

Steve

Report · Feb 26, 2008

Yes, I will too.

I posted above and I hope that Tom Muck responds because his extension
looks like it might be used to create the basic structure and then rig
it to work but until he responds, I don't think I want to spend 30 bucks
for his extension.
>
> This is something I have been planning on doing too, with Stored
> Procedures, and I am hoping its not a major headache. If I find anything
> I will post it here.
>
> Steve

Report · Feb 27, 2008

FYI, I usually post over at Developer Shed too. There are actually a lot
of people that help out there. Unfortunately, they were pretty skeptical
that it could be done easily. They had some good ideas but it didn't
look exactly like what I was looking for. I still may try one of their
suggestions.

http://forums.aspfree.com/ Good resource.