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  |  

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


  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

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


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
1165 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.

 


Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com
Jetkey Smart Map
Smart Map is an AJAX powered Google Map module that displays driving directions, proximity search results and data from your own databases. Smart Map reads GPX (GPS data) files, GeoRSS feeds, and KML data. You can pass any querystring parameter to Smart Map and into your own custom queries to control what data displays on the map.
smartmap.jetkey.com
DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com

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