SELECT iNewsIDPK, sNewsTitle, sNewsDescription, tbl_news.iNewsCategoryIDFK, iNewsSubCategoryIDFK, sH1, sMetaTitle, sMetaDescription, sLink, sLinkTitle FROM tbl_news , tbl_news_subcategory WHERE tbl_news.iNewsCategoryIDFK = #ARGUMENTS.iNewsCategoryIDPK# AND tbl_news_subcategory.iNewsSubCategoryIDPK = #ARGUMENTS.iNewsSubCategoryIDPK# ORDER BY dDate DESC SELECT iNewsIDPK, sNewsTitle, sNewsDescription, iNewsCategoryIDFK, iNewsSubCategoryIDFK, sH1, sMetaTitle, sMetaDescription, dDate, sLink, sLinkTitle FROM tbl_news WHERE iNewsIDPK = #ARGUMENTS.iNewsIDPK# ORDER BY dDate DESC INSERT INTO tbl_news_category (sNewsCategoryTitle, iSortOrder) VALUES ('#ARGUMENTS.sNewsCategoryTitle#', #ARGUMENTS.iSortOrder#) UPDATE tbl_news_category SET sNewsCategoryTitle = '#ARGUMENTS.sNewsCategoryTitle#', iSortOrder = #ARGUMENTS.iSortOrder# WHERE iNewsCategoryIDPK = #ARGUMENTS.iNewsCategoryIDPK# UPDATE tbl_news_subcategory SET sNewsSubCategoryTitle = '#ARGUMENTS.sNewsSubCategoryTitle#', iNewsCategoryIDFK = #ARGUMENTS.iNewsCategoryIDPK#, iSortOrder = #ARGUMENTS.iSortOrder# WHERE iNewsSubCategoryIDPK = #ARGUMENTS.iNewsSubCategoryIDPK# SELECT iNewsCategoryIDPK, sNewsCategoryTitle FROM tbl_news_category ORDER BY iSortOrder SELECT iNewsCategoryIDPK AS ParentID, iNewsSubCategoryIDPK, sNewsSubCategoryTitle, tbl_news_subcategory.iSortOrder FROM tbl_news_category, tbl_news_subcategory WHERE tbl_news_category.iNewsCategoryIDPK = tbl_news_subcategory.iNewsSubCategoryIDPK ORDER BY tbl_news_subcategory.iSortOrder SELECT iNewsSubCategoryIDPK, sNewsSubCategoryTitle, tbl_news_subcategory.iSortOrder, iNewsCategoryIDFK FROM tbl_news_subcategory WHERE iNewsCategoryIDFK = #ARGUMENTS.iNewsCategoryIDPK# ORDER BY tbl_news_subcategory.iSortOrder INSERT INTO tbl_news_subcategory (sNewsSubCategoryTitle, iNewsCategoryIDFK, iSortOrder) VALUES ('#ARGUMENTS.sNewsSubCategoryTitle#', #ARGUMENTS.iNewsCategoryIDPK#, #ARGUMENTS.iSortOrder#) SELECT sEmbeddedMedia FROM tbl_embedded_media WHERE sType = '#ARGUMENTS.sType#' AND id = #ARGUMENTS.id# ORDER BY iEmbeddedMediaIDPK INSERT INTO tbl_news (sNewsTitle, sNewsDescription, iNewsCategoryIDFK, iNewsSubCategoryIDFK, sH1, sMetaTitle, sMetaDescription, dDate, sLink, sLinkTitle) VALUES ('#ARGUMENTS.sNewsTitle#', '#ARGUMENTS.sNewsDescription#', #ARGUMENTS.iNewsCategoryIDPK#, #ARGUMENTS.iNewsSubCategoryIDPK#, '#ARGUMENTS.sH1#', '#ARGUMENTS.sMetaTitle#', '#ARGUMENTS.sMetaDescription#', #CreateODBCDate(LSParseDateTime(LSDateFormat(now(), "dd/mm/yyyy")))#, '#ARGUMENTS.sLink#', '#ARGUMENTS.sLinkTitle#') SELECT iNewsIDPK FROM tbl_news ORDER BY iNewsIDPK DESC INSERT INTO tbl_embedded_media (sEmbeddedMedia, id, sType) VALUES ('#this_media#', #get_id.iNewsIDPK#, 'News') UPDATE tbl_news SET sNewsTitle = '#ARGUMENTS.sNewsTitle#', sNewsDescription = '#ARGUMENTS.sNewsDescription#', iNewsCategoryIDFK = #ARGUMENTS.iNewsCategoryIDPK#, iNewsSubCategoryIDFK = #ARGUMENTS.iNewsSubCategoryIDPK#, sH1 = '#ARGUMENTS.sH1#', sMetaTitle = '#ARGUMENTS.sMetaTitle#', sMetaDescription = '#ARGUMENTS.sMetaDescription#', dDate = #CreateODBCDate(LSParseDateTime(LSDateFormat(now(), "dd/mm/yyyy")))#, sLink = '#ARGUMENTS.sLink#', sLinkTitle = '#ARGUMENTS.sLinkTitle#' WHERE iNewsIDPK = #ARGUMENTS.iNewsIDPK# DELETE FROM tbl_embedded_media WHERE id = #ARGUMENTS.iNewsIDPK# AND sType = 'News' INSERT INTO tbl_embedded_media (sEmbeddedMedia, id, sType) VALUES ('#this_media#', #ARGUMENTS.iNewsIDPK#, 'News') DELETE FROM tbl_news WHERE iNewsIDPK = #ARGUMENTS.iNewsIDPK# DELETE FROM tbl_news_category WHERE iNewsCategoryIDPK = #ARGUMENTS.iNewsCategoryIDPK# DELETE FROM tbl_news_subcategory WHERE iNewsSubCategoryIDPK = #ARGUMENTS.iNewsSubCategoryIDPK# SELECT iNewsCategoryIDPK, sNewsCategoryTitle, iSortOrder FROM tbl_news_category WHERE iNewsCategoryIDPK = #ARGUMENTS.iNewsCategoryIDPK# SELECT iNewsSubCategoryIDPK, sNewsSubCategoryTitle, iSortOrder, iNewsCategoryIDFK FROM tbl_news_subcategory WHERE iNewsSubCategoryIDPK = #ARGUMENTS.iNewsSubCategoryIDPK#