More BUGS RRS feed

  • Question

  • User-1137548214 posted

    Hi all. I'm new to this so please help me.


    1.      I have used the guidens in this forum to get my latest news to show first. I went in my Database Explore, clicked on club.mdf and opend up my PagedAnnouncementlist. Here I edit the 

           ORDER BY itemdate ASC, id ASC
           ORDER BY itemdate DESC, id DES 

          But now I get an error.   When I have 10 news on the news site, and I enter number 11, THEN news number 3 disapears and news number 11 is the first news on page 1 AND on page 2 ?

    2.    How can I delete a photo album

    3.    How can I delete a member

    4.    In the news section, I can onley write about 200 - 250 signs, if I write more the news just disaperes. How can I make longer news?

    Please I need help............. With this other than that I'm OK.

    Best regards Jakob[:)] 

    Tuesday, December 12, 2006 4:27 AM

All replies

  • User30603712 posted

    1. You add one news, the item date will be the latest of all, ORDER BY DESC will put this new to the top. Item 3 disappers could be that it is one of the oldest news.

    2. You can't delete a photo album unless you change the code.

    3. Yes, you can delete a member, add membership.delete() ... The club starter kit uses default ASPNET membership library to handle all membership.

    4. The new description in the "Announcement" table has 500 varchar defined. Increase this size in the table will work for you.


    Thursday, December 14, 2006 1:51 AM
  • User-1254660837 posted

    I had the same problem with the news and the order and I found this somewhere in this forum.  It has worked well for me.  Just replace the paged announcement list stored procedure with the following and it should work. 

    ALTER PROCEDURE PagedAnnouncementList


    @pageNum INT = 1,

    @PageSize INT = 10



    -- Set the page bounds

    DECLARE @PageLowerBound int

    DECLARE @PageUpperBound int

    DECLARE @TotalRecords int

    SET @PageLowerBound = @PageSize * (@pageNum - 1)

    SET @PageUpperBound = @PageSize - 1 + @PageLowerBound

    -- Create a temp table to put items in the order we want

    CREATE TABLE #ItemIndex


    IndexId int IDENTITY (0, 1) NOT NULL,

    NewsId int


    -- Insert into temp table

    INSERT INTO #ItemIndex (NewsId)

    SELECT a.id

    FROM announcements a ORDER BY itemdate DESC, id DESC

    -- Get the goodies

    SELECT a.id, a.itemdate, a.title, a.description, a.photo

    FROM Announcements a, #ItemIndex i

    WHERE a.id = i.NewsId

    AND i.IndexId >= @PageLowerBound AND i.IndexId <= @PageUpperBound

    ORDER BY itemdate DESC, id DESC

    -- Return the number of pages

    SELECT @TotalRecords = COUNT(*)

    FROM #ItemIndex

    RETURN CEILING(1+@TotalRecords/@pageSize)

    Friday, December 15, 2006 6:34 PM
  • User-1137548214 posted

    HI bridgetgregory

    This did the trick it works perfet.....


    Please if anyone can solve any of the other problems I would be very happy.[:D]

    Wednesday, December 20, 2006 7:43 AM