In default.asp line 142
strSql = "SELECT CAT_ID, CAT_STATUS, CAT_NAME, CAT_ORDER, CAT_SUBSCRIPTION,
CAT_MODERATION " &_
lines 342, 343
cCAT_NAME = 2
cCAT_ORDER = 3
lines 373, 374
CatName = allCategoryData(cCAT_NAME,iCategory)
CatOrder = allCategoryData(cCAT_NAME,iCategory)
=======================
The CatOrder it is not required anymore, right?
If I delete CAT_ORDER from SELECT
strSql = "SELECT CAT_ID, CAT_STATUS, CAT_NAME, CAT_SUBSCRIPTION, CAT_MODERATION " &_
and I replace
cCAT_ID = 0
cCAT_STATUS = 1
cCAT_NAME = 2
cCAT_ORDER = 3
cCAT_SUBSCRIPTION = 4
cCAT_MODERATION = 5
with
cCAT_ID = 0
cCAT_STATUS = 1
cCAT_NAME = 2
cCAT_SUBSCRIPTION = 3
cCAT_MODERATION = 4
And I replace
CatID = allCategoryData(cCAT_ID,iCategory)
CatStatus = allCategoryData(cCAT_STATUS,iCategory)
CatName = allCategoryData(cCAT_NAME,iCategory)
CatOrder = allCategoryData(cCAT_NAME,iCategory)
CatSubscription = allCategoryData(cCAT_SUBSCRIPTION,iCategory)
CatModeration = allCategoryData(cCAT_MODERATION,iCategory)
with
CatID = allCategoryData(cCAT_ID,iCategory)
CatStatus = allCategoryData(cCAT_STATUS,iCategory)
CatName = allCategoryData(cCAT_NAME,iCategory)
CatSubscription = allCategoryData(cCAT_SUBSCRIPTION,iCategory)
CatModeration = allCategoryData(cCAT_MODERATION,iCategory)
With these changes, the Order of Categories seems to have no affect on the Front Page, right?
<
Posted - 28 September 2007 : 20:28:20
