A "Gotcha" with Auto Suggestions in ColdFusion 8

A reader just sent me a bug report where he noticed that his autosuggestions didn’t seem to work right in ColdFusion 8. The same dataset was returned from two things he typed into the box. One worked - and one did not.

Turns out he had typed, for example, “cat”, and expected to see suggestions with the word cat anywhere in the result. He had written his back end SQL that way. He saw words with “cat” in the middle being returned, but they refused to show up as suggestions.

Turns out CF’s autosuggest will ignore any result that doesn’t start the letters you typed in the box. This is a reasonable choice as it is what most folks want. Spry works the same way, but does have an option to do internal matching as well. I’ve filed an ER with Adobe, but wanted to blog the issue in case others run into it as well.

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA https://www.raymondcamden.com

Comments