select tcontent.*, tfiles.fileSize, tfiles.contentType, tfiles.contentSubType, tfiles.fileExt from tcontent left join tfiles on (tcontent.fileid=tfiles.fileid) where tcontent.contenthistid= and tcontent.siteid= select tcontent.*, tfiles.fileSize, tfiles.contentType, tfiles.contentSubType, tfiles.fileExt from tcontent left join tfiles on (tcontent.fileid=tfiles.fileid) where tcontent.contentid= and tcontent.active=1 and tcontent.siteid= and type in ('Page','Portal','File','Calendar','Link','Gallery','Component','Form') select tcontent.*, tfiles.fileSize, tfiles.contentType, tfiles.contentSubType, tfiles.fileExt from tcontent left join tfiles on (tcontent.fileid=tfiles.fileid) where tcontent.remoteID= and tcontent.active=1 and tcontent.siteid= and type in ('Page','Portal','File','Calendar','Link','Gallery','Component','Form') select tcontent.*, tfiles.fileSize, tfiles.contentType, tfiles.contentSubType, tfiles.fileExt from tcontent left join tfiles on (tcontent.fileid=tfiles.fileid) where tcontent.filename= tcontent.filename is null and tcontent.active=1 and tcontent.type in('Page','Portal','Calendar','Gallery') and tcontent.siteid= INSERT INTO tcontent (ContentHistID, ContentID, Active, OrderNo, approved, DisplayStart, displaystop, MetaDesc, MetaKeyWords, Body, Summary, path, tags, responseMessage, responseDisplayFields, Title, menuTitle, filename, LastUpdate, Display, ParentID, Type, subType,LastUpdateBy, LastUpdateByID, siteid, moduleid, isnav, restricted, target, restrictgroups,template, responseChart,responseSendTo,moduleAssign,notes,inheritObjects,isFeature, releaseDate,targetParams,isLocked,nextN,sortBy,sortDirection,featureStart,featureStop,fileID,forceSSL, remoteID,remoteURL,remotePubDate,remoteSource,RemoteSourceURL,Credits, audience,keyPoints,searchExclude,displayTitle) VALUES ( , , #arguments.contentBean.getActive()#, #arguments.contentBean.getOrderNo()#, #arguments.contentBean.getApproved()#, #createodbcdatetime(createDateTime(year(arguments.contentBean.getDisplayStart()),month(arguments.contentBean.getDisplayStart()),day(arguments.contentBean.getDisplayStart()),hour(arguments.contentBean.getDisplayStart()),minute(arguments.contentBean.getDisplayStart()),0))#null, #createodbcdatetime(createDateTime(year(arguments.contentBean.getDisplayStop()),month(arguments.contentBean.getDisplayStop()),day(arguments.contentBean.getDisplayStop()),hour(arguments.contentBean.getDisplayStop()),minute(arguments.contentBean.getDisplayStop()),0))#null, , , , , , , , , , , , , , , , , , , , #createodbcdatetime(now())#, #arguments.contentBean.getDisplay()#, , , , , , , , #arguments.contentBean.getisnav()#, #arguments.contentBean.getrestricted()#, , , , #arguments.contentBean.getresponseChart()#, , , , , #arguments.contentBean.getisfeature()#, #createodbcdatetime(LSDateFormat(arguments.contentBean.getReleaseDate(),'mm/dd/yyyy'))#null, Null , #arguments.contentBean.getIsLocked()#, , , , #createodbcdatetime(createDateTime(year(arguments.contentBean.getFeatureStart()),month(arguments.contentBean.getFeatureStart()),day(arguments.contentBean.getFeatureStart()),hour(arguments.contentBean.getFeatureStart()),minute(arguments.contentBean.getFeatureStart()),0))#null, #createodbcdatetime(createDateTime(year(arguments.contentBean.getFeatureStop()),month(arguments.contentBean.getFeatureStop()),day(arguments.contentBean.getFeatureStop()),hour(arguments.contentBean.getFeatureStop()),minute(arguments.contentBean.getFeatureStop()),0))#null, , , , , , , , , , , #arguments.contentBean.getSearchExclude()#, #arguments.contentBean.getDisplayTitle()# ) select lastupdate from tcontent where active = 1 and siteid= and contentid= select contenthistid from tcontent where siteid= and contentid= and lastupdate < #createodbcdatetime(rsdate.lastupdate)# Delete from tcontent where siteid= and contentid= and lastupdate < #createodbcdatetime(rsdate.lastupdate)# delete from tcontentobjects where siteid= and contenthistid in (,) delete from tcontentcategoryassign where siteid= and contenthistid in (,) delete from tcontentrelated where siteid= and contenthistid in ( ,) delete from tcontenttags where siteid='#arguments.siteid#' and contenthistid in ( ,) select contenthistid from tcontent where siteid= and contentid= and approved=0 delete from tcontentobjects where siteid= and contenthistid in (,) delete from tcontentcategoryassign where siteid='#arguments.siteid#' and contenthistid in ('#rslist.contenthistid#',) delete from tcontentrelated where siteid= and contenthistid in ('#rslist.contenthistid#',) delete from tcontenttags where siteid= and contenthistid in ( ,) Delete from tcontent where siteid= and contentid= and approved=0 update tcontent set active=0 where contentid= and active=1 and siteid= insert into tcontentobjects (contentid,contenthistid,object,name,objectid,orderno,siteid,columnid) values( , , , , , , , ) insert into tcontentobjects (contentid,contenthistid,object,name,objectid,orderno,siteid,columnid) values( , , , , , , , ) insert into tcontenttags (contentid,contenthistid,siteid,tag) values( , , , ) select * from tcontentobjects where contenthistid= and columnid= order by orderno delete from tcontentobjects where contentid= and siteid= delete from tcontenttags where contentid= and siteid= delete from tcontentobjects where contenthistid= and siteid= delete from tcontenttags where contenthistid= and siteid= DELETE FROM tcontent where siteid= and ContentHistID= DELETE FROM tcontentcategoryassign where siteid= and contentHistID= update tcontent set parentID='#arguments.contentBean.getParentID()#' where siteid= and parentID= select contentHistID FROM tcontent where siteid= and ContentID= DELETE FROM tcontent where siteid= and ContentID= DELETE FROM tpermissions where siteid= and ContentID= DELETE FROM tcontentobjects where contentID= AND siteID= DELETE FROM tcontenttags where contentID= AND siteID= DELETE FROM tcontenteventreminders where contentID= AND siteID= DELETE FROM tcontentcategoryassign where contentID= AND siteID= DELETE FROM tcontentratings where contentID= AND siteID= DELETE FROM tcontentrelated where (contentID= or relatedID=) AND siteID= DELETE FROM tusersfavorites where favorite= AND siteID= DELETE FROM tsessiontracking where contentID= AND siteID= DELETE FROM tcontentcomments where contentID= AND siteID= DELETE FROM tcontentobjects where objectID= AND siteID= DELETE FROM tformresponsequestions where formID= DELETE FROM tformresponsepackets where formID= insert into tcontentrelated (contentID,contentHistID,relatedID,siteid) values ( , , , ) insert into tcontentrelated (contentID,contentHistID,relatedID,siteid) values ( , , , ) delete from tcontentrelated where contentHIstID = select relatedID from tcontentrelated where contentHistID= and siteid = delete from tcontentassignments where contentID = and siteID = insert into tcontentassignments (contentID,contentHistID,siteID,UserID) values( , , , ) select * from tcontentcomments where contentid= and siteid= and isApproved=1 order by entered #arguments.sortOrder# select count(*) TotalComments from tcontentcomments where contentid= and siteid= and isApproved=1