ERROR SQL USERS GetUsersAdvancedSearch GetUsersAdvancedSearch

Mar 14, 2015 at 4:07 PM
Edited Mar 14, 2015 at 4: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
Mar 14, 2015 at 4:28 PM
thanks for the heads up, all will be fixed in next version (scheduled to be released within the next 1-2 days)
Mar 23, 2015 at 6:59 PM
fixed in version 0.9.8
Mar 23, 2015 at 7:12 PM
DECLARE @returnStr nvarchar(100) = N''; -------------- !!!!!!!!!!!!!!!!?????
not fixed in declare
Mar 24, 2015 at 1:04 PM
sorry, fixed in version 0.9.8a
Marked as answer by leupold on 3/24/2015 at 5:17 AM