R – I Need to have a field where you can show an hour in Sharepoint 2007

You should give the Document Rating System of the SharePoint Tool Basket a try.

This project allows authenticated users to rate :

• custom lists, document libraries, picture libraries, issue lists, calendars, links
• discussion boards
• pages.
• Blog posts
• Moderator module
• The system also contains a site definition and is now available in English, French & Dutch

Finally I did the following, i don't know what has worked finally, i have changed the way I ask the Lists and i have included RowLimit:

DataTable dt = null; DataView dv = null;

    SPSiteDataQuery qry = new SPSiteDataQuery();

    qry.Query = "<Where><Eq><FieldRef Name='";
    qry.Query += campo + "'/><Value Type='Boolean'>1</Value></Eq>";
    qry.Query += "</Where><OrderBy><FieldRef Name='Modified' Ascending='false' /></OrderBy>";
    qry.Webs = "<Webs Scope='Recursive'/>";
    qry.Lists = "<Lists ServerTemplate='850' Hidden='FALSE' MaxListsLimit='50'/>";
    qry.RowLimit = 3;

    qry.ViewFields = "<FieldRef Name='Title'/><FieldRef Name='Modified'/><FieldRef Name='FileRef'/>";

    using (SPSite site = new SPSite(CurrentSite.ID, GetSystemToken(CurrentSite)))
    {
        using (SPWeb web = site.OpenWeb(webUrl))
        {   
            dt = web.GetSiteData(qry);

            dv = dt.DefaultView;

        }
    }

    return dv;