Last post May 11, 2006 10:47 AM by Sponge_Bob
May 10, 2006 07:16 PM|Sponge_Bob|LINK
I am creating a DotNetNuke module and I am using some of the way cool atlas controls. I want to use the auto complete for a textbox to filter a list but I seem to have a problem [:|] Because this is a module that will be on several different pages with different
data in the list for each I need to pass another parameter into the autocomplete function such as this
Public Function GetSearchTerms(ByVal PrefixText As String, ByVal Count As Integer, ByVal ModuleID As Integer) As String()
' Lookup list based on moduleid from database
If I do not pass in ModuleID then I will end up getting a list for all the different modules and of course this would not work for my filter.
Is there any way to pass this or any other parameters using the autocomplete?
May 11, 2006 09:20 AM|rodneyjoyce|LINK
May 11, 2006 10:47 AM|Sponge_Bob|LINK
In My database each module which there can be more that one per page stores the information for each module based on the Module ID. My stored Proc would look like this:
CREATE PROCEDURE [dbo].[GetListItemsNames]
Select Distinct [Name] from dbo.GG_ListItems
where ModuleID = @ModuleID
AND [Name] like @Filter + '%'
Order By [Name] Asc