Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old March 20th, 2007, 01:49 PM
plb plb is offline
Authorized User
 
Join Date: Jan 2007
Location: Oakland, CA, USA.
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is a little ironic. I'm rushing to get out of thr house to go to Reno to teach a couple classes on SQL. In my opening lecture I will say that SQL is a set processing language in which you normally don't need looping.

I look in the .sql scripts jimibt provides and I see a lot of temp tables and loops. I have been tying to resurect a five year old forum I wrote. As I remember all the PROCs were set based.

Sorry gotta go. More later. I will study the PROCs that jimibt provided - maybe that's the way to go.

http://weboperahouse.com
  #12 (permalink)  
Old March 20th, 2007, 02:10 PM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

Quote:
quote:Originally posted by plb
 This is a little ironic. I'm rushing to get out of thr house to go to Reno to teach a couple classes on SQL. In my opening lecture I will say that SQL is a set processing language in which you normally don't need looping.

I look in the .sql scripts jimibt provides and I see a lot of temp tables and loops. I have been tying to resurect a five year old forum I wrote. As I remember all the PROCs were set based.

Sorry gotta go. More later. I will study the PROCs that jimibt provided - maybe that's the way to go.

http://weboperahouse.com
plb - i'd say that it's 'a way' to go, not sure if it's 'the way' to go mind you. likewise, this is prolly the only time that i've used loops in my t-sql 'ever' but can't think of another way to achieve the same result easily. of course, here's hoping that you dig in a bit and optimise it further :)

all the best

jimi

[edit] - i'd also be interested to see any approach that you'd take to promote those sp's up thro' the DAL etc to the UI. that's the end game really...
  #13 (permalink)  
Old March 22nd, 2007, 06:09 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

ok - updated my ForumsUpdate.zip with additional code in the Post.cs class to purge the forums cache on any post action (i.e BizObject.PurgeCacheItems("forums_forums");). [this was to resolve an issue where the posts count and last post values weren't being updated when new posts were added]

all works as expected now and ready to be tweaked by someone else to the next level.

jim

http://www.eventdriventhing.com/sql/ForumsUpdate.zip
  #14 (permalink)  
Old March 23rd, 2007, 01:45 PM
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Hello!
Could not find stored procedure 'tbh_Forums_UnCloseThread'.
jimibt please add code of the stored procedure

And one mistake
It is impossible add new forum on page ManageForums.aspx
even added
      <InsertParameters>
           <asp:Parameter Name="title" Type="String" />
           <asp:Parameter Name="moderated" Type="Boolean" />
           <asp:Parameter Name="importance" Type="Int32" />
           <asp:Parameter Name="description" Type="String" />
           <asp:Parameter Name="imageUrl" Type="String" />
           <asp:Parameter Name="lastpostby" Type="String" />
           <asp:Parameter Name="lastpostdate" Type="DateTime" />
           <asp:Parameter Name="posts" Type="Int32" />
           <asp:Parameter Name="topics" Type="Int32" />
       </InsertParameters>

in base record is added, but on page ManageForums.aspx, ShowForums.aspx no.
And at accompaniment of the new forum is required nonzero field description, earlier so was not
possible, there was add and without description

Sorry for bad english.

  #15 (permalink)  
Old March 23rd, 2007, 02:10 PM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

Quote:
quote:Originally posted by 99mary


Hello!
Could not find stored procedure 'tbh_Forums_UnCloseThread'.
jimibt please add code of the stored procedure

And one mistake
It is impossible add new forum on page ManageForums.aspx
even added
     <InsertParameters>
         <asp:Parameter Name="title" Type="String" />
         <asp:Parameter Name="moderated" Type="Boolean" />
         <asp:Parameter Name="importance" Type="Int32" />
         <asp:Parameter Name="description" Type="String" />
         <asp:Parameter Name="imageUrl" Type="String" />
         <asp:Parameter Name="lastpostby" Type="String" />
         <asp:Parameter Name="lastpostdate" Type="DateTime" />
         <asp:Parameter Name="posts" Type="Int32" />
         <asp:Parameter Name="topics" Type="Int32" />
     </InsertParameters>

in base record is added, but on page ManageForums.aspx, ShowForums.aspx no.
And at accompaniment of the new forum is required nonzero field description, earlier so was not
possible, there was add and without description

Sorry for bad english.

99mary,

no problems with your english - understand perfectly!! :)

ok, i've updated the UpdateForums.zip file, so if you pick it up, the stored proc 'tbh_Forums_UnCloseThread' is there, as are the updated sp's for getforums etc..

the problem that you had was probably due to the initial tbh_Forums_GetForums sp not doing an outer join test on post, therefore, it wasn't showing any rows for forums that contained no posts. i've sorted this now and you'll need to update tbh_Forums_GetForums again and all should work fine.

let me know how you get on. (also, any errors that you fix and/or optimisations, be sure to pass those on too ;)

jim

http://www.eventdriventhing.com/sql/ForumsUpdate.zip
  #16 (permalink)  
Old March 24th, 2007, 11:22 AM
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
Regrettably in archive no the stored proc 'tbh_Forums_UnCloseThread'.
So can not check possible open subjects anew.

New forum now adds, but requires nonzero field description, url, that not comfortable.

And one error on page ShowForums.aspx:
since I use Russian
field LastPostBy is displayed in wrong coding.
I do not know why. On other page is displayed orderly.


I have added on forum on pages ShowThread.aspx navigation
            <pagersettings mode="NumericFirstLast"
            firstpagetext="first"
            lastpagetext="last"
            pagebuttoncount="3"
            position="TopAndBottom"/>

and on pages BrowseThreads.aspx.cs
            Forum forum = Forum.GetForumByID(int.Parse(forumID));
            this.Title = string.Format(this.Title, forum.Title);
            ddlForums.SelectedValue = forumID;
in lieu thereof
            Forum forum = Forum.GetForumByID(int.Parse(forumID));



Respectfully yours, Mary

  #17 (permalink)  
Old March 24th, 2007, 01:28 PM
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

Quote:
quote:Originally posted by 99mary
 Hi,
Regrettably in archive no the stored proc 'tbh_Forums_UnCloseThread'.
So can not check possible open subjects anew.

New forum now adds, but requires nonzero field description, url, that not comfortable.

And one error on page ShowForums.aspx:
since I use Russian
field LastPostBy is displayed in wrong coding.
I do not know why. On other page is displayed orderly.


I have added on forum on pages ShowThread.aspx navigation
            <pagersettings mode="NumericFirstLast"
            firstpagetext="first"
            lastpagetext="last"
            pagebuttoncount="3"
            position="TopAndBottom"/>

and on pages BrowseThreads.aspx.cs
            Forum forum = Forum.GetForumByID(int.Parse(forumID));
            this.Title = string.Format(this.Title, forum.Title);
            ddlForums.SelectedValue = forumID;
in lieu thereof
            Forum forum = Forum.GetForumByID(int.Parse(forumID));



Respectfully yours, Mary

hi again mary,

the proc 'tbh_Forums_UnCloseThread' is actually in the archive. i think you may have to clear your browser cache and then click the download link again. otherwise if you're having issues getting the latest version, i'll rename it and then you may have more success.

let me know how you get on, and i'll try your additions too ;)

cheers

jmi

  #18 (permalink)  
Old March 25th, 2007, 02:58 PM
plb plb is offline
Authorized User
 
Join Date: Jan 2007
Location: Oakland, CA, USA.
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bug in Forum ?

I can't really tell because I've made so many changes to the forum that it may be a bug that only exists in my implimentation.

In TBH forum's data design a thread is identified as a post with ParentPostID of 0. If you are logged on as the administrator and you try to delete a regular posting you get a warning message asking you to verify the deletion of post. The deletion of a single post works fine as far as can tell. However if from the ShowThread page you delete a thread (parentID = 0) you get a nasty error message.

Deleting a thread from the BrowseThreads page works OK. I think I see what's happening with the deletion bug but I won't bother to fix it myself if its part of the Starter Kit code.


http://weboperahouse.com
  #19 (permalink)  
Old March 25th, 2007, 03:10 PM
plb plb is offline
Authorized User
 
Join Date: Jan 2007
Location: Oakland, CA, USA.
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
Default

My forum extentions so far have been reserved for cosmetics not functionality. In an effort to make my forum look more like the popular PHP forum software vBulletin, I have emulated their UI. Instead of text links I have substituted graphic buttons. I'm only at down to the BrowseThread level but I will work my way down through all the pages.



http://weboperahouse.com
  #20 (permalink)  
Old March 26th, 2007, 09:18 AM
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When viewing the page ShowThread.aspx is changed number of the users in network - time their last activity, possible somehow this avoid, so in network from users only I?

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
AJAX Extensions ilegend .NET Framework 3.5 1 September 19th, 2008 03:32 AM
Some Extensions plb BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 July 29th, 2008 11:57 AM
PHP Extensions Dnigma Pro PHP 0 June 22nd, 2006 12:41 AM
File Extensions nbnelson C# 2 August 25th, 2003 12:09 PM
converting Forum.aspx to Forum.ascx (help) drfunkie BOOK: ASP.NET Website Programming Problem-Design-Solution 1 July 11th, 2003 12:27 PM



All times are GMT -4. The time now is 10:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.