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  |  

PortalWebHosting
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  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

Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Help Module [Le...  category view order buttons
Previous Previous
 
Next Next
New Post 6/26/2006 4:22 AM
User is offline ziwar ziwar
5 posts
10th Ranked


category view order buttons 

can anyone tell me plz why category editor is not showing view order buttons???

it only shows them if there is no categories at all!!!!

 
New Post 6/27/2006 12:18 AM
User is offline ziwar ziwar
5 posts
10th Ranked


Re: category change order buttons 

 ziw wrote

sorry

can anyone tell me plz why category editor is not showing [Change] order buttons???

it only shows them if there is no categories at all!!!!

 
New Post 6/27/2006 2:44 PM
User is offline Philip Beadle
1142 posts
www.philipbeadle.net
6th Ranked








Re: category change order buttons 

Run this script.  Thre was a dyslexic mistake I had the Parent and moduleid around the wrong way.

 

ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryActiveByParent]

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

FROM   {databaseOwner}{objectQualifier}Help_Category

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

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


 


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 7/14/2006 1:17 AM
User is offline Leroux Michelson
2 posts
10th Ranked


Re: category change order buttons 
System.Data.SqlClient.SqlException: Line 30: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[Help_ListCategoryActiveByParent] @ParentID int, @ModuleID int AS SELECT [CategoryID], [CategoryGUID], [Name], [Description], [Image], [KeyWords], [ModuleID], [Order], [Level], [Parent], [Visible], [Deleted] FROM dbo.Help_Category WHERE [Parent] = @ParentID AND [ModuleID] = @ModuleID AND [Deleted] <> 1 AND [Visible] <> 0 ORDER BY [Level] ASC, [Parent] ASC, [Order] ASC GO

I get this error while trying to run the script, any suggestions?
 
New Post 9/14/2006 8:22 PM
User is offline Marc Drescher
28 posts
www.mynox.com
10th Ranked


Re: category change order buttons 
I get the same error. Does this mean no is actually using this module?
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Help Module [Le...  category view order buttons
 


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.

 


DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com
Integral Hosting | DNN only $14.95/month
Experienced .NET hosting on Windows 2003, ASP.NET 1.1 & 2.0, MSSQL with real technical support.
www.integralhosting.com
Aricie
Aricie is one of the French pioneers and experts in DotNetNuke technology.
www.aricie.com

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