ERROR SQL USERS GetUsersAdvancedSearch GetUsersAdvancedSearch

Mar 14, 2015 at 3:07 PM
Edited Mar 14, 2015 at 3:18 PM
FUNCTIon [dbo].[UserRelationFilter]

return nVarChar(100) !!!!! length --- >>> 130 ----- recommend 500

PROCEDURE [dbo].[GetUsersAdvancedSearch]

SET @strFieldList = dbo.[GetProfileFieldSql](__dbo.[GetProfileFieldSql](__@PortalID__, N''); !!!!!! replace in @MasterPortalID

PROCEDURE [dbo].[GetUsersBasicSearch]

SET @strFieldList = dbo.[GetProfileFieldSql](__dbo.[GetProfileFieldSql](__@PortalId__, N'') !!!!!!!!!!! replace in @MasterPportalId
Coordinator
Mar 14, 2015 at 3:28 PM
thanks for the heads up, all will be fixed in next version (scheduled to be released within the next 1-2 days)
Coordinator
Mar 23, 2015 at 5:59 PM
fixed in version 0.9.8
Mar 23, 2015 at 6:12 PM
DECLARE @returnStr nvarchar(100) = N''; -------------- !!!!!!!!!!!!!!!!?????
not fixed in declare
Coordinator
Mar 24, 2015 at 12:04 PM
sorry, fixed in version 0.9.8a
Marked as answer by leupold on 3/24/2015 at 5:17 AM