Displaying records during a search with using ColdFusion

[newbieDev]

I am trying to create a page that while trying to search for a particular record based on what is typed in the search box, results are displayed on the same page -

It will be similar to how the MS Outlook Adress book functions - while typing in the type Name or select from list search box, records that match whatever is typed in the box are diplayed in a table below - If I type a, all records begining with a should be displayed, if I add b to the a, all records begining with ab should be displayed, and so on.

How do I go about creating this? The users are trying to avoid clicking on a search button and would like the page to function like the MS Outlook Address book.

Thanks in advance!
NewbieDev

 

[cfStarlight]

You might take a look at ajax.

This may not be exactly what you want, but here's an example of a "suggest" function.

http://www.robgonda.com/blog/projects/ajaxcfc/examples/suggest/

 

[newbieDev]

Thanks for the reply.

I I checked the example and it is close to what I am looking for . The problem is I don't have the experinece to make it work with a database table. Any suggestions?

Thanks

 

[cfStarlight]

Take a look at the right hand side: Server Side Script. The example code looks very thorough.

 

[imstillatwork]

take a look at the search function on ray camdon's

http://www.RIAForge.com

I believe he built that using CF8 native functionality

Kevin

http://www.lot-o-nothin.com/cfml/

 

[cfStarlight]

Kevin,

Yes, ray camden's stuff is great. Do you know the name of the project? Nothing jumps out at me other than rob gonda's ajaxCFC.

 

[imstillatwork]

RIA forge is running CF8, on the menu there is a search feature, that's an exmaple of how it works - sorry for the confusion - I didn't mean there was project

Kevin

http://www.lot-o-nothin.com/cfml/

 

[cfStarlight]

Thanks. LOL. Duh! Talk about overlooking the obvious... and I even used the "search" feature ;-)

 

[imstillatwork]

now that's funny stuff

Kevin

http://www.lot-o-nothin.com/cfml/