Search with results as you type...

Question

I am working on writing a search feature for an intranet
application to search on records. We really would like to use some
functioanlity like the Adobe.com website uses where it seems to
search the database as you type each letter, showing you results
real time as you search. Obviously I can write some javascript and
CF code to run against the database as each letter is typed using a
SQL Like statement. But Im concerned over performance as our DB
grows. Are there other tactics I should think about other than just
going this method? Something I should use instead to make it run
faster and more efficiently.

Newsgroup_User · Answer

Using autosuggest text input fieldshttp://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=ajaxui_7.html#1126821Like that?-- Ken FordAdobe Community Expert Dreamweaver/ColdFusionAdobe Certified Expert - Dreamweaver CS3Adobe Certified Expert - ColdFusion 8Fordwebs, LLChttp://www.fordwebs.com"MWGrace" <webforumsuser@macromedia.com> wrote inmessage news:gc2qr3$chs$1@forums.macromedia.com...>I am working on writing a search feature for an intranetapplication to >search> on records. We really would like to use somefunctioanlity like the > Adobe.com> website uses where it seems to search the database asyou type each > letter,> showing you results real time as you search. Obviously Ican write some> javascript and CF code to run against the database aseach letter is typed> using a SQL Like statement. But Im concerned overperformance as our DB > grows.> Are there other tactics I should think about other thanjust going this > method?> Something I should use instead to make it run faster andmore efficiently.>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded