Question about Text Suggestion - Data Springs Inc. - DotNetNuke Modules - DotNetNuke Module Product Forums - Product Discussion - DotNetNuke Modules

Question about Text Suggestion

Last Post 10-31-2012 06:24 AM by Michael Man. 1 Replies.

Author

Messages

Michael Man User is Offline

river guide
Posts:152
Avatar

10-31-2012 05:34 AM
I followed this demo http://www.datasprings.com/products...ms-demo-29 and it worked just fine as the demo on my site. However, instead of the box suggesting just the username, I like to have the box suggests both Firstname and Lastname. For example: instead of me typing first 3 characters of username, I like to type first 3 characters of firstname then the box will show a list of matched Firstname + Lastname Can someone show me how to do that? Thanks

Michael Man User is Offline

river guide
Posts:152
Avatar

10-31-2012 06:24 AM
Just found my solution. I did not know that I could do this is the SQL statement SELECT firstname + ' ' + lastname AS NAME