Building a multiple-parameter search feature

This article describes how to give users the ability to conduct database searches with two or more different search words, or "search parameters." The first half of the article outlines how to generate search results based on more than one search parameter.

George Petrov

George Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. The most popular for its over high-quality Dreamweaver extensions and templates.

George is also the founder of Wappler.io - the most Advanced Web & App Builder

See All Postings From George Petrov >>

Comments

UD and dynamic SQL strings

May 23, 2001 by Andrew Jocelyn

I'd love to know how I can create a dynamic SQL WHERE statement that can work with the UD server behaviours. E.g. If you have 5 text fields to enter search criteria then sometimes you'll post values to a results page and sometimes you won't. The answer is to have a WHERE statement that is created on the fly. I have a script that works but it's not UD friendly and doesn’t work with the other server behaviours. Surely there's a demand out there for this kind of search functionality. Is it outside the scope of UD or perhaps someone could write a clever behaviour? I've trawled newsgroups and web sites but as a UD and ASP beginner I'm stuck until someone develops some code for UD that can generate flexible SQL statements on the fly.

Regards

Andrew Jocelyn

The link is broken

January 31, 2002 by evan hughes

Hey guys, I really want to get to that page, but MM seem to have taken it down, or moved it... can anyone shed some light on this topic? Anyone have an offline version of the page?

Thanks, Evan

RE: The link is broken

January 31, 2002 by Waldo Smeets

Thanks they moved that page. I fixed the link: www.macromedia.com/support/ultradev/building/multiple_param_search/index.html

RE: RE: The link is broken

January 31, 2002 by evan hughes

No, I've read that one... I thought there must have been another. What I really want to know is how to have multiple keyword searches on my page. I have a search now to the sort of level as described in that technote, but I want multiple keywords with space a delimeter or similar.

If anyone can point me in the right direction...

Evan

You must me logged in to write a comment.