Following SQL get what I need:
 SELECT TOP (50) [nodeId] 
 FROM [dbo].[cmsContentXml] 
 WHERE [xml] like '%creatorID="29"%'    
   AND [xml] like '%nodeType="1086"%' 
 ORDER BY [nodeId] DESC
I need to pass in the numbers as parameters, so I have follows:
exec sp_executesql N'SELECT TOP (@max) [nodeId] FROM [dbo].[cmsContentXml] WHERE...
            
           
          
            
            Hi,
As been requested, I wrote some code which basically change the document's date (the document of umbraco blog).
I have changed every place I can find the date, and makes all the date displays fine, and I have adjusted the path to make it correct.
Now, the url indicated in the umbraco.library.NiceUrl(id) is not working, but previou...
            
           
          
            
            I am very interesting in the dynamic language runtime of .net, and saw IronRuby/IronPython is built on top of it. I cannot find some example which utilize the dynamic of Ruby/Python from within c#, which is what I realy interested.
I saw videos from Microsoft which call JavaScript from within Silverlight using the dynamic of c# 4, just ...
            
           
          
            
            I have a website that is using Umbraco as it's CMS.  Everything is working great on a PC.  Am able to use Windows Live Writer to create blogs with no problems at all.  My problem comes when the Macintosh users try to blog.  I have tried loads of different software packages, MarsEdit, Bloggo etc. but none seem to work.  Has anyone had any...
            
           
          
            
            Hi all,
The question regarding the Umbraco CMS:
I have to setup public access for particular document (a blog, for example) programmatically - using web services exposed by Umbraco (Document service, Member service, etc.). I suppose that services are suitable for CRUD operations only, but I am not sure, as they let setting document pro...