insert into tadplacements (placementID,campaignID,adZoneID,creativeID,dateCreated, lastupdate,lastupdateBy ,startDate,endDate, costPerImp,costPerClick,isExclusive,budget, isActive, notes,billable ) values ( '#arguments.placementBean.getPlacementID()#', '#arguments.placementBean.getCampaignID()#', '#arguments.placementBean.getAdZoneID()#', '#arguments.placementBean.getCreativeID()#', #createODBCDateTime(arguments.placementBean.getDateCreated())#null, #createODBCDateTime(arguments.placementBean.getLastUpdate())#null, , #createODBCDateTime(LSDateFormat(arguments.placementBean.getStartDate(),'mm/dd/yyyy'))#null, #createODBCDateTime(LSDateFormat(arguments.placementBean.getEndDate(),'mm/dd/yyyy'))#null, #arguments.placementBean.getCostPerImp()#, #arguments.placementBean.getCostPerClick()#, #arguments.placementBean.getIsExclusive()#, #arguments.placementBean.getBudget()#, #arguments.placementBean.getIsActive()#, , 0 ) Select * from tadplacements where placementID= update tadplacements set campaignID = '#arguments.placementBean.getCampaignID()#', adZoneID = '#arguments.placementBean.getAdZoneID()#', creativeID = '#arguments.placementBean.getCreativeID()#', lastUpdate = #createODBCDateTime(arguments.placementBean.getLastUpdate())#null, lastUpdateBy = , startDate = #createODBCDateTime(LSDateFormat(arguments.placementBean.getStartDate(),'mm/dd/yyyy'))#null, endDate = #createODBCDateTime(LSDateFormat(arguments.placementBean.getEndDate(),'mm/dd/yyyy'))#null, costPerImp = #arguments.placementBean.getCostPerImp()#, costPerClick = #arguments.placementBean.getCostPerClick()#, isExclusive = #arguments.placementBean.getIsExclusive()#, budget = #arguments.placementBean.getBudget()#, isActive = #arguments.placementBean.getIsActive()#, notes = , billable= #getBillable(arguments.placementBean.getPlacementID(),arguments.placementBean.getCostPerImp(),arguments.placementBean.getCostPerClick())# where placementID = delete from tadplacements where placementID = delete from tadplacements where campaignID = delete from tadplacementdetails where placementID = update tadplacements set isExclusive=0 where adzoneID = select sum(counter) as total from tadstats where placementID='#arguments.placementID#' and Type='Impression' select sum(counter) as Total from tadstats where placementID='#arguments.placementID#' and Type='Click' insert into tadplacementdetails (placementid,placementType,placementValue) values( '#arguments.placementBean.getPlacementID()#', 'hour', #h# ) insert into tadplacementdetails (placementid,placementType,placementValue) values( '#arguments.placementBean.getPlacementID()#', 'weekday', #wd# ) select PlacementValue from tadplacementdetails where placementID = '#arguments.placementID#' and placementType='#arguments.placementType#'