Search boxes with database driven prompts

Report · Sep 25, 2008

I have seen some search box text fields on websites that display a drop-down list based on what text I have typed in the search box.

For example, if I am looking for chicken soup recipe, by the time I have typed chicken, the list will display options like chicken legs, chicken soup recipe, chicken little, chicken run and so on. All of this is drawn from content within a database. How is this done? Is there any tutorials for it, or even plugins just to make my life easier?

I am fairly sure that this is AJAX because I am certain I saw this in the labs part of adobes website. but I can't find it now!

Report · Sep 25, 2008

matthew stuart wrote:
> I have seen some search box text fields on websites that display a drop-down
> list based on what text I have typed in the search box.
>
> For example, if I am looking for chicken soup recipe, by the time I have typed
> chicken, the list will display options like chicken legs, chicken soup recipe,
> chicken little, chicken run and so on. All of this is drawn from content within
> a database. How is this done? Is there any tutorials for it, or even plugins
> just to make my life easier?
>
> I am fairly sure that this is AJAX because I am certain I saw this in the labs
> part of adobes website. but I can't find it now!

I think it might be called auto-complete, no doubt each ajax framework
has its own implementation. What server-side programming language are
you using?

Dooza

Report · Sep 25, 2008

I found what I was looking for here:

http://labs.adobe.com/technologies/spry/samples/data_region/SuggestSample.html

BUT, this is for xml I think, so, how can I get this to work with a recordset in ASP VB?

If there is any plugin people know of that is useful, I'd still be interested in taking a look.

Thanks.

Mat

Report · Sep 25, 2008

matthew stuart wrote:
> I found what I was looking for here:
>
> http://labs.adobe.com/technologies/spry/samples/data_region/SuggestSample.html
>
> BUT, this is for xml I think, so, how can I get this to work with a recordset
> in ASP VB?
>
> If there is any plugin people know of that is useful, I'd still be interested
> in taking a look.
>
> Thanks.
>
> Mat

You would have to turn your recordset into XML, but I am not sure CS3
can do this, I could be wrong.

Dooza