Register | Log In
Store Download Support Blogs Forums Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsBlogBlogquery to give entries of blogquery to give entries of blog
Previous
 
Next
New Post
5/10/2009 3:27 AM
 
User is offline S.Nathan

Joined: 3/2/2009
Posts: 121

I need the query from the code that runs to give the entries of a particular blog

In my blog website, in individual blog pages, posts from other blog is also coming. I checked my database(hosted in shared web server) in blog_entries table,all blog posts from are correctly entered in corresponding blog ids only.

I  guess it is probably due to  some overlap in time on the entries

Awaiting your suggestion asap.

Thanks,

Swaminathan,

Web Application Engineer,

www.steadfastglobal.com
 
New Post
5/10/2009 11:26 PM
 
User is offline Dario Rossa

www.dariorossa.it
Joined: 11/4/2006
Posts: 799

Hi Swaminathan,

are you saying that when browsing to a particular blog you receive also entries that have a different BlogID field? When you browse to a particular blog, you should see a BlogID parameter into the querystring, and the stored procedure that is triggered is Blog_ListEntriesByBlog.

Best regards,
Dario Rossa
 
New Post
5/11/2009 1:41 AM
 
User is offline S.Nathan

Joined: 3/2/2009
Posts: 121

Hi Dario,

Even in the query string, corresponding blog id and  and name of the blog is coming correct.

but view blog shows post from all blogs.

i might have recreate the blogs to solve this problem.

If you have alternate solutions or suggestions. pls reply asap.

Regards,

Swaminathan.
 
New Post
5/11/2009 3:02 AM
 
User is offline Dario Rossa

www.dariorossa.it
Joined: 11/4/2006
Posts: 799

Hi Swaminathan,

the blog's name should not be listed in the querystring. However, could you confirm that the entries have been added on blogs that are different from the blog that you are browsing? Try executing this SQL command:

SELECT EntryID, Title, BlogID FROM {databaseOwner}{objectQualifier}Blog_Entries WHERE PortalID = 'xxx'

Replace xxx with your portal ID. Let me know if you need further help.

Best regards,
Dario Rossa
 
New Post
5/11/2009 9:34 AM
Accepted Answer 
User is offline mamlin


eguanasolutions.com
Joined: 3/28/2006
Posts: 730

The following link includes a query to generate a list of the "most-commented" blog entries.  You might find it of interest-
 
  Create a "Most-Commented Blogs" module
  http://www.eguanasolutions.com/DNN_Blog/EntryID/13.aspx

 
-mamlin
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsBlogBlogquery to give entries of blogquery to give entries of blog


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.
Copyright © 2002-2012 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP