insert into tcontentcategories (categoryID,siteid,parentID,dateCreated,lastupdate,lastupdateBy, name,notes,isInterestGroup,isActive,isOpen,sortBy,sortDirection,restrictgroups,path) values ( '#arguments.categoryBean.getCategoryID()#', , , #createODBCDateTime(arguments.categoryBean.getDateCreated())#null, #createODBCDateTime(arguments.categoryBean.getLastUpdate())#null, , , , #arguments.categoryBean.getIsInterestGroup()#, #arguments.categoryBean.getIsActive()#, #arguments.categoryBean.getIsOpen()#, , , , ) Select * from tcontentcategories where categoryID= insert Into tcontentcategoryassign (categoryID,contentID,contentHistID,isFeature,orderno,siteid, featureStart,featureStop) values (, , , , , , #createodbcdatetime(arguments.featurestart)#null, #createodbcdatetime(arguments.featureStop)#null) update tcontentcategories set lastUpdate = #createODBCDateTime(arguments.categoryBean.getLastUpdate())#null, lastupdateBy = , name = , isActive = #arguments.categoryBean.getIsActive()#, isOpen = #arguments.categoryBean.getIsOpen()#, parentID = , isInterestGroup = #arguments.categoryBean.getIsInterestGroup()#, notes= , sortBy = , sortDirection = , restrictGroups = , path= where categoryID = update tcontentcategories set parentID= where parentID = delete from tcontentcategories where categoryID = delete from tcontentcategoryassign where categoryID = update tcontentcategoryassign set orderno= where contentID = and categoryID= and siteid= select distinct tcontentcategoryassign.orderno from tcontentcategoryassign inner join tcontent ON (tcontentcategoryassign.contentid=tcontent.contentid and tcontentcategoryassign.siteid=tcontent.siteid) where tcontent.contentID = and categoryID= and tcontent.siteID= and tcontent.active=1 update tcontentcategoryassign set orderno=OrderNo+1 where categoryid= and siteid=