Hi,

I just tried to install version 2.0 of this module on DNN 5.4.2
and received the following error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create Procedure dbo.[myqualifier_DataSprings_DynamicViews_LoadDynamicForms] @PortalID Int AS Select A.ModuleID, ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from dbo.[myqualifier_Modules] A Inner Join dbo.[myqualifier_TabModules] B on A.ModuleID = B.ModuleID Where ModuleDefID In (Select ModuleDefID from dbo.[myqualifier_ModuleDefinitions] where FriendlyName like '%Dynamic Forms%') AND PortalID = 0 AND A.IsDeleted =0

When I try to drop it on a page I get the following error:

DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.myqualifier_DataSprings_DynamicViews_LoadDynamicForms' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.myqualifier_DataSprings_DynamicViews_LoadDynamicForms' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicViews.Data.SqlDataProvider.GetDynamicForms(Int32 PortalID) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.GetDynamicForms(Int32 PortalId) at DataSprings.DNN.Modules.DynamicViews.Settings.RefreshDynamicForms() at DataSprings.DNN.Modules.DynamicViews.Settings.LoadMySettings() --- End of inner exception stack trace ---

Please advise ... I'm hoping to use it to create a custom search mechanism for the site that I'm working on ...

Thanks!

Hi Shemeka,
There is a blog post for dynamic views common questions that should help you: http://www.datasprings.com/news/blog/postid/22

From Host> SQL you will be able to run these queries and will probably fix your problem.

Thanks

Thank you so much Don ...