Emaze Auction: Category SELECT categoryID FROM Category WHERE categoryName1 = '#Form.categoryName#'

Category #Form.categoryName# is already being used as a primary category. Please choose another category name.

INSERT INTO Category (categoryName1, categoryDescription, categoryNameX, categoryName, categoryDateTimeCreated, categoryDateTimeLastEdited, categoryLotCount, categoryViewCount, templateFile, categoryImage, categoryLogo, categoryID1, categoryID2, categoryID3, categoryID4, categorySubLotCount, categoryMarketCount, categorySubMarketCount, categoryProcureCount, categorySubProcureCount, forumID, categoryType) VALUES ('#Form.categoryName#', NULL, '#Form.categoryDescription#', '#Form.categoryName#', '#storeName#', #nowDateTime#, #nowDateTime#, 0, 0, '#Form.templateFile#', NULL, '#categoryImage#', NULL, '#categoryLogo#', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, #Form.categoryType#) SELECT categoryID FROM Category WHERE categoryDateTimeCreated = #nowDateTime# UPDATE Category SET categoryID1 = #categoryID# WHERE categoryID = #categoryID#

Category #Form.categoryName# created as a primary category.

 SELECT categoryName1, categoryID1 FROM Category WHERE categoryID = #ListGetAt(Form.catID,1)# SELECT categoryID FROM Category WHERE categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#Form.categoryName#'

Category #Form.categoryName# is already being used in the #getSubcategoryNames.categoryName1# category. Please choose another category name.

INSERT INTO Category (categoryName1, categoryName2, categoryDescription, categoryNameX, categoryName, categoryDateTimeCreated, categoryDateTimeLastEdited, categoryLotCount, categoryViewCount, templateFile, categoryImage, categoryLogo, categoryID1, categoryID2, categoryID3, categoryID4, categorySubLotCount, categoryMarketCount, categorySubMarketCount, categoryProcureCount, categorySubProcureCount, forumID, categoryType) VALUES ('#getSubcategoryNames.categoryName1#', '#Form.categoryName#', NULL, '#Form.categoryDescription#', '#Form.categoryName#', '#storeName#', #nowDateTime#, #nowDateTime#, 0, 0, '#Form.templateFile#', NULL, '#categoryImage#', NULL, '#categoryLogo#', #getSubcategoryNames.categoryID1#, 0, 0, 0, 0, 0, 0, 0, 0, 0, #Form.categoryType#) SELECT categoryID FROM Category WHERE categoryDateTimeCreated = #nowDateTime# UPDATE Category SET categoryID2 = #categoryID# WHERE categoryID = #categoryID#

Category #Form.categoryName# created in
#getSubcategoryNames.categoryName1#.

 SELECT categoryName1, categoryName2, categoryID1, categoryID2 FROM Category WHERE categoryID = #ListGetAt(Form.catID,1)# SELECT categoryID FROM Category WHERE categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#getSubcategoryNames.categoryName2#' AND categoryName3 = '#Form.categoryName#'

Category #Form.categoryName# is already being used in the #getSubcategoryNames.categoryName1##subCategorySeparator##getSubcategoryNames.categoryName2# category. Please choose another category name.

INSERT INTO Category (categoryName1, categoryName2, categoryName3, categoryDescription, categoryNameX, categoryName, categoryDateTimeCreated, categoryDateTimeLastEdited, categoryLotCount, categoryViewCount, templateFile, categoryImage, categoryLogo, categoryID1, categoryID2, categoryID3, categoryID4, categorySubLotCount, categoryMarketCount, categorySubMarketCount, categoryProcureCount, categorySubProcureCount, forumID, categoryType) VALUES ('#getSubcategoryNames.categoryName1#', '#getSubcategoryNames.categoryName2#', '#Form.categoryName#', NULL, '#Form.categoryDescription#', '#Form.categoryName#', '#storeName#', #nowDateTime#, #nowDateTime#, 0, 0, '#Form.templateFile#', NULL, '#categoryImage#', NULL, '#categoryLogo#', #getSubcategoryNames.categoryID1#, #getSubcategoryNames.categoryID2#, 0, 0, 0, 0, 0, 0, 0, 0, #Form.categoryType#) SELECT categoryID FROM Category WHERE categoryDateTimeCreated = #nowDateTime# UPDATE Category SET categoryID3 = #categoryID# WHERE categoryID = #categoryID#

Category #Form.categoryName# created in
#getSubcategoryNames.categoryName1##subCategorySeparator##getSubcategoryNames.categoryName2#.

 SELECT categoryName1, categoryName2, categoryName3, categoryID1, categoryID2, categoryID3 FROM Category WHERE categoryID = #ListGetAt(Form.catID,1)# SELECT categoryID FROM Category WHERE categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#getSubcategoryNames.categoryName2#' AND categoryName3 = '#getSubcategoryNames.categoryName3#' AND categoryName4 = '#Form.categoryName#'

Category #Form.categoryName# is already being used in the #getSubcategoryNames.categoryName1##subCategorySeparator##getSubcategoryNames.categoryName2##subCategorySeparator##getSubcategoryNames.categoryName3# category. Please choose another category name.

INSERT INTO Category (categoryName1, categoryName2, categoryName3, categoryName4, categoryDescription, categoryNameX, categoryName, categoryDateTimeCreated, categoryDateTimeLastEdited, categoryLotCount, categoryViewCount, templateFile, categoryImage, categoryLogo, categoryID1, categoryID2, categoryID3, categoryID4, categorySubLotCount, categoryMarketCount, categorySubMarketCount, categoryProcureCount, categorySubProcureCount, forumID, categoryType) VALUES ('#getSubcategoryNames.categoryName1#', '#getSubcategoryNames.categoryName2#', '#getSubcategoryNames.categoryName3#', '#Form.categoryName#', NULL, '#Form.categoryDescription#', '#Form.categoryName#', '#storeName#', #nowDateTime#, #nowDateTime#, 0, 0, '#Form.templateFile#', NULL, '#categoryImage#', NULL, '#categoryLogo#', #getSubcategoryNames.categoryID1#, #getSubcategoryNames.categoryID2#, #getSubcategoryNames.categoryID3#, 0, 0, 0, 0, 0, 0, 0, #Form.categoryType#) SELECT categoryID FROM Category WHERE categoryDateTimeCreated = #nowDateTime# UPDATE Category SET categoryID4 = #categoryID# WHERE categoryID = #categoryID#

Category #Form.categoryName# created in
#getSubcategoryNames.categoryName1##subCategorySeparator##getSubcategoryNames.categoryName2##subCategorySeparator##getSubcategoryNames.categoryName3#.

 UPDATE Category SET categoryDescription = NULL, '#Form.categoryDescription#', categoryImage = NULL, '#categoryImage#', categoryLogo = NULL, '#categoryLogo#', templateFile = '#Form.templateFile#', categoryType = #Form.categoryType# WHERE categoryID = #Form.categoryID#

Category information updated.

SELECT categoryID FROM Category WHERE categoryID <> #Form.categoryID# AND categoryName1 = '#Form.categoryName#' UPDATE Category SET categoryName1 = '#Form.categoryName#' WHERE categoryID1 = #Form.categoryID# UPDATE Category SET categoryName = '#storeName#', categoryName1 = '#Form.categoryName#', categoryNameX = '#Form.categoryName#' WHERE categoryID = #Form.categoryID# SELECT categoryID, categoryName1, categoryName2, categoryName3, categoryName4, categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryID1 = #Form.categoryID# AND categoryID <> #Form.categoryID# UPDATE Category SET categoryName = '#storeName##subCategorySeparator##storeName2#', categoryName1 = '#Form.categoryName#' WHERE categoryID = #getUpCat.categoryID# ">

Category #Form.oldCategoryName# updated to #Form.categoryName# as a primary category.

Category #Form.categoryName# is already being used as a primary category. Please choose another name.

 UPDATE Category SET categoryDescription = NULL, '#Form.categoryDescription#', categoryImage = NULL, '#categoryImage#', categoryLogo = NULL, '#categoryLogo#', templateFile = '#Form.templateFile#', categoryType = #Form.categoryType# WHERE categoryID = #Form.categoryID#

Category information updated.

SELECT categoryName1, categoryID1 FROM Category WHERE categoryID = #Form.categoryID# SELECT categoryID FROM Category WHERE categoryID <> #Form.categoryID# AND categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#Form.categoryName#' UPDATE Category SET categoryName2 = '#Form.categoryName#' WHERE categoryID1 = #getSubcategoryNames.categoryID1# AND categoryID2 = #Form.categoryID# UPDATE Category SET categoryName = '#storeName#', categoryNameX = '#Form.categoryName#' WHERE categoryID = #Form.categoryID# SELECT categoryID, categoryName1, categoryName2, categoryName3, categoryName4, categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#Form.categoryName#' AND categoryID <> #Form.categoryID# UPDATE Category SET categoryName = '#storeName##subCategorySeparator##storeName2#', categoryName2 = '#Form.categoryName#' WHERE categoryID = #getUpCat.categoryID# ">

Category #Form.oldCategoryName# updated to #Form.categoryName# in #getSubcategoryNames.categoryName1#..

Category #Form.categoryName# is already being used in #getSubcategoryNames.categoryName1# Please choose another name..

 UPDATE Category SET categoryDescription = NULL, '#Form.categoryDescription#', categoryImage = NULL, '#categoryImage#', categoryLogo = NULL, '#categoryLogo#', templateFile = '#Form.templateFile#', categoryType = #Form.categoryType# WHERE categoryID = #Form.categoryID#

Category information updated.

SELECT categoryName1, categoryName2, categoryID1, categoryID2 FROM Category WHERE categoryID = #Form.categoryID# SELECT categoryID FROM Category WHERE categoryID <> #Form.categoryID# AND categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#getSubcategoryNames.categoryName2#' AND categoryName3 = '#Form.categoryName#' UPDATE Category SET categoryName3 = '#Form.categoryName#' WHERE categoryID1 = #getSubcategoryNames.categoryID1# AND categoryID2 = #getSubcategoryNames.categoryID2# AND categoryID3 = #Form.categoryID# UPDATE Category SET categoryName = '#storeName#', categoryNameX = '#Form.categoryName#' WHERE categoryID = #Form.categoryID# SELECT categoryID, categoryName1, categoryName2, categoryName3, categoryName4, categoryID1, categoryID2, categoryID3, categoryID4 FROM Category WHERE categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#getSubcategoryNames.categoryName2#' AND categoryName3 = '#Form.categoryName#' AND categoryID <> #Form.categoryID# UPDATE Category SET categoryName = '#storeName##subCategorySeparator##getUpCat.categoryName4#' WHERE categoryID = #getUpCat.categoryID# ">

Category #Form.oldCategoryName# updated to #Form.categoryName# in #getSubcategoryNames.categoryName1##subCategorySeparator# #getSubcategoryNames.categoryName2#.

Category #Form.categoryName# is already being used in #getSubcategoryNames.categoryName1##subCategorySeparator# #getSubcategoryNames.categoryName2# Please choose another name..

 UPDATE Category SET categoryDescription = NULL, '#Form.categoryDescription#', categoryImage = NULL, '#categoryImage#', categoryLogo = NULL, '#categoryLogo#', templateFile = '#Form.templateFile#', categoryType = #Form.categoryType# WHERE categoryID = #Form.categoryID#

Category information updated.

SELECT categoryName1, categoryName2, categoryName3 FROM Category WHERE categoryID = #Form.categoryID# SELECT categoryID FROM Category WHERE categoryID <> #Form.categoryID# AND categoryName1 = '#getSubcategoryNames.categoryName1#' AND categoryName2 = '#getSubcategoryNames.categoryName2#' AND categoryName3 = '#getSubcategoryNames.categoryName3#' AND categoryName4 = '#Form.categoryName#' UPDATE Category SET categoryName4 = '#Form.categoryName#', categoryName = '#storeName#', categoryNameX = '#Form.categoryName#' WHERE categoryID = #Form.categoryID#

Category #Form.oldCategoryName# updated to #Form.categoryName# in #getSubcategoryNames.categoryName1##subCategorySeparator# #getSubcategoryNames.categoryName2##subCategorySeparator##getSubcategoryNames.categoryName3#.

Category #Form.categoryName# is already being used in #getSubcategoryNames.categoryName1##subCategorySeparator# #getSubcategoryNames.categoryName2##subCategorySeparator##getSubcategoryNames.categoryName3# Please choose another name..

 SELECT categoryName, categoryName1, categoryName2, categoryName3, categoryName4, categoryID, categoryID1, categoryID2, categoryID3, categoryID4, templateFile, categoryImage, categoryLogo, categoryNameX, categoryType FROM Category WHERE categoryID = #categoryID# ">
New Category

Edit Category - #categoryID#

SELECT categoryName1, categoryName2, categoryName3, categoryName4, categoryID1, categoryID2, categoryID3, categoryID4, categoryNameX, categoryDescription, templateFile, categoryImage, categoryLogo, categoryType FROM Category WHERE categoryID = #categoryID# SELECT templateName, templateFile FROM Template WHERE templateType = 'category' ORDER BY templateName
Name:
Subcategory: SELECT categoryID, categoryName1, categoryName2, categoryName3, categoryID1, categoryID2, categoryID3 FROM Category WHERE categoryID = #ListFirst(Form.catID)# (primary category) #categoryName1# #categoryName1##subCategorySeparator##categoryName2# #categoryName1##subCategorySeparator##categoryName2##subCategorySeparator##categoryName3# SELECT categoryID, categoryName1, categoryName2, categoryName3, categoryName4, categoryID2, categoryID3, categoryID4 FROM Category ORDER BY categoryName1, categoryName2, categoryName3, categoryName4
Type:
Button Image:  File:
URL:
Page Logo:  File:
URL:
Template:
Description:
Header:
Footer:
Special: