Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

Verndale
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Help Module [Le...  Cannot Reorder Categories
Previous Previous
 
Next Next
New Post 11/9/2006 8:26 PM
User is offline Joseph Nelson
14 posts
anySiteHosting.com
10th Ranked


Cannot Reorder Categories 

DNN Help 2.0.4

Manage Categories, View Order - displays the Refresh icon, but no up or down arrows.
The up and down arrows display initially when a single category has been entered, but as soon as you enter a second category, the arrows no longer show?

 
New Post 11/9/2006 9:29 PM
User is offline Philip Beadle
1202 posts
www.philipbeadle.net
6th Ranked








Re: Cannot Reorder Categories 

yep, we found a bug where the parameters were getting switched around.  For a fix do this

 

ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryActiveByParent]

@ModuleID int,
@ParentID int
 
AS
SELECT   [CategoryID],
   [CategoryGUID],
   [Name],
   [Description],
   [Image],
   [KeyWords],
   [ModuleID],
   [Order],
   [Level],
   [Parent],
   [Visible],
   [Deleted]

FROM   {databaseOwner}{objectQualifier}Help_Category

WHERE  [Parent] = @ModuleIDAND [ModuleID] = @ParentID
AND   [Deleted] <> 1
AND   [Visible] <> 0

ORDER BY [Level] ASC,
   [Parent] ASC,
   [Order] ASC
   
GO

 

dont orget 2 carriage returns after the GO

 


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 11/10/2006 5:24 AM
User is offline Joseph Nelson
14 posts
anySiteHosting.com
10th Ranked


Re: Cannot Reorder Categories 

Thanks Philip!

Though... hate to say it but I'm yet a bit of a newbie to the DNN and SQL stuff... where/how do I run this 'script'?

 
New Post 11/18/2006 7:39 PM
User is offline Joseph Nelson
14 posts
anySiteHosting.com
10th Ranked


Re: Cannot Reorder Categories 

Any help Phillip? Please? I don't know where/howTo run this script you are referencing??

 
New Post 11/19/2006 4:03 PM
User is offline Philip Beadle
1202 posts
www.philipbeadle.net
6th Ranked








Re: Cannot Reorder Categories 

Hi Mate, Sorry was away for the weekend.

 

You login as host got to Host/SQL and paste it in there.  Make sure you add 2 carriage returns after the GO and check the Run As Script option.


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Help Module [Le...  Cannot Reorder Categories
 


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.

 


UK DotNetNuke CMS installation, hosting & support
UK based installation, branding, customising, integration, hosting, training, support and maintenance services for DotNetNuke
www.deburca.co.uk
Need Help with your DotNetNuke website?
Jango Studios offers exclusive DotNetNuke Skin Design, Module Development, Web Marketing and Web Hosting.
www.jangostudios.net
Where Every Home is an Investment
Where Every Home is an Investment
www.nestbrokers.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP