Merging to fields together > DotNetNuke Module Product Forums > Data Springs Inc.

Unanswered Active Topics

Forums Search

Subject: Merging to fields together

Email me when someone replies to this thread.

You are not authorized to post a reply.

Page 3 of 3

Author

Messages

gdecuir
Posts:60

river guide

06/18/2009 10:36 AM
Hi David/Chad Chad per our conversation, here is the message from the host/sql query. System.Data.SqlClient.SqlException: Could not find stored procedure 'usp_certinsert'. 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) usp_certinsert 1,'','MCTS,BCPIP,PMP,SAS', 'MPS'

gdecuir
Posts:60

river guide

06/18/2009 11:03 AM
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'LastUpdatedDate', table 'C7917_gpct.dbo.UserProfile'; column does not allow nulls. INSERT fails. The statement has been terminated. 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) usp_certsinsert 1,'','MCTS,BCPIP,SAS,RHCE', 'test'

David To
Posts:2121

river guide

06/18/2009 11:19 AM
Okay, in the store procedure I posted earlier, I left out the "LastUpdatedDate" column which cannot be left empty. Here's the final store procedure that does work with the "LastUpdatedDate" included: create procedure usp_certsinsert(@userid int, @allcerts nvarchar(500),@cert nvarchar(50),@certother nvarchar(50)) as begin declare @allcertsVar nvarchar(500) If (@allcerts = '') set @allcertsVar = (@cert + ' , ' + @certother) else set @allcertsVar = @allcerts declare @allcertsID int set @allcertsID = (select PropertyDefinitionID from ProfilePropertyDefinition where PropertyName = 'allcerts') -- if record doesn't exist, insert a new record if not exists(select userid from UserProfile where userid = @UserID and PropertyDefinitionID = @allcertsID) begin insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate) values(@UserID,@allcertsID,@allcertsVar,2,getdate()) end else -- record exists, update it instead begin update UserProfile set PropertyValue = @allcertsVar, LastUpdatedDate = getdate() where UserId = @UserID and PropertyDefinitionID = @allcertsID end end

Thomas Born
Posts:70

river guide

06/30/2009 4:34 AM
It is almost working, I believe I discovered a bug in Dynamic Registration, please check the tickets in Snowcovered. I would love to get some feedback on this in the morning (Australian time) Thanks Thomas

You are not authorized to post a reply.

Page 3 of 3