Hi All,

I am trying to use the reports module to pull the last 5 blog entries from a particular blog (something the recent entries module as part of the blog suite does not) The issue arrises when I try to grab the description (or summary) I get "The data types ntext and varchar are incompatible in the add operator"

This is what I have a the moment which gives me the title and a read more link.

select top 5
ble.Title+'<a href="'+PermaLink+'">'+'Read More'+'</a>'
as [Latest Blog Entries]
from blog_entries ble
inner join blog_blogs bb on bb.Blogid = ble.Blogid
where ble.Published = 1
and bb.Portalid = @portalID
and bb.BlogID = 24
order by ble.AddedDate desc

What I want is to includ ble.Description but when I do I get the error above. I am only a basic user of the reports module and would appreciate any pointers.

TIA.

You can do something like this...
select top 5
CAST(ble.Description as nvarchar(max))+'Read More'
as [Latest Blog Entries] 
from blog_entries ble
inner join blog_blogs bb on bb.Blogid = ble.Blogid
where ble.Published = 1
and bb.Portalid = @portalID
and bb.BlogID = 24
order by ble.AddedDate desc

---

Will Morgenweck
VP, Product Management
DotNetNuke Corp.