Need a feature for Auto-Suggest - DotNetNuke (DNN) Skins | DNN Modules | Consulting | R2i - DNN Forum | Discuss DNN Skins, DNN Modules, Troubleshooting

R2i DotNetNuke^® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke^® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke^® modules and services; please feel free to ask us anything.

Unanswered Active Topics

Forums Search Members

Forums > DotNetNuke > General

Need a feature for Auto-Suggest

Last Post 12 Jul 2006 04:06 AM by jepper. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

nutriCandee User is Offline

New Member
Posts:2

22 May 2008 12:59 AM
<img src='desktopmodules/ntforums/images/emoticons/unsure.gif' height='20' width='20' border='0' title='Unsure' align='absmiddle'> Hi! I'm looking for a way to make this function offer suggestions even when the entry does not match the first word in the phrase but matches the second or subsequent word. For example, if my customer types in "Henry," our auto-suggest currently offers Henry Altman, Henry Boyd, Henry Cruise. HOWEVER, we also want it to offer other names like John Henry, Mary Grace Henry, etc.. Can this be done? Will really appreciate any help/suggestion anyone can offer. Thanks!

wlevy

New Member
Posts:66

27 May 2008 01:57 PM
If you're using a SQL statement such as SELECT SuggestedName FROM tblAllNames WHERE SuggestedName LIKE '@InputName%' you could change it to ... LIKE '%@InputName%' The leading percent sign turns this into a "CONTAINS" lookup.