I'm having an issue when paging against a SQL 05 database. One of my columns is a Nvarchar(MAX). I'm using LLBLGE ver2.0, Self-servicing, SQL Server Driver and SD.TemplateBindings.SqlServerSpecif.NET20
This issue is exactly the same as this thread. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5635
Am I missing a patch somewhere?
-- Sean
exec sp_executesql N'CREATE TABLE #TempTable ([__rowcnt][int] IDENTITY (1,1) NOT NULL,[CommentID][Int] NULL,[OrganizationId][Int]
NULL,[Comment][NVarChar](2147483647) NULL,[FirstName][NVarChar](50) NULL,[LastName][NVarChar](50) NULL,[CreateDate][DateTime] NULL);INSERT
INTO #TempTable ([CommentID],[OrganizationId],[Comment],[FirstName],[LastName],[CreateDate]) SELECT DISTINCT TOP 11 [FormTracking].[Form].[FormComment].[CommentID], [FormTracking].[Form].[FormComment].[OrganizationID] AS [OrganizationId],
[FormTracking].[Form].[FormComment].[Comment], [Services].[dbo].[UserInfo].[FirstName], [Services].[dbo].[UserInfo].[LastName], FormTracking].[Form].[FormComment].[CreateDate] FROM ( [Services].[dbo].[UserInfo] INNER JOIN [FormTracking].[Form].[FormComment] ON
[Services].[dbo].[UserInfo].[UserID]=[FormTracking].[Form].[FormComment].[UserID]) WHERE ( ( [FormTracking].[Form].[FormComment].[WorkflowInstanceID] = @WorkflowInstanceId3 AND [FormTracking].[Form].[FormComment].[IsPublic] =
@IsPublic4)) ORDER BY [FormTracking].[Form].[FormComment].[CreateDate] DESC;SELECT
[CommentID],[OrganizationId],[Comment],[FirstName],[LastName],[CreateDate] FROM #TempTable WHERE [__rowcnt] > @__rownoStart AND [__rowcnt]
<= @__rownoEnd ORDER BY [__rowcnt] ASC;DROP TABLE #TempTable',N'@WorkflowInstanceId3 uniqueidentifier,@IsPublic4 bit,@__rownoStart
int,@__rownoEnd int',@WorkflowInstanceId3='505D2E5A-DBE2-4C53-94AA-68C72967C783',@IsPublic4=1,@__rownoStart=5,@__rownoEnd=10]
