Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 


Wednesday, January 07, 2009 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
Forum for discussing Dotnetnuke and asking or answering questions regarding general usage, integration and fundamentals
Subject: Need a feature for Auto-Suggest
You are not authorized to post a reply.
 
Author Messages
nutriCandee
Flyweight
Posts:2

05/21/2008 7:59 PM Alert 
<img src='http://dnn.bi4ce.com/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
Middleweight
Posts:66

05/27/2008 8:57 AM Alert 
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.
nutriCandee
Flyweight
Posts:2

05/29/2008 7:58 PM Alert 
Thank you so much! Will try it and hope it works.
pmanda
Superweight
Posts:267

05/30/2008 9:29 AM Alert 
Let us know if that worked for you.

Praveena Manda
Software Engineer
Bi4ce,Inc
You are not authorized to post a reply.
Forums > Dotnetnuke > General > Need a feature for Auto-Suggest



ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation