insert into tadcampaigns (campaignID,userid,dateCreated, lastupdate,lastupdateBy,name,startDate,endDate,isactive,notes) values ( '#arguments.campaignBean.getcampaignID()#', , #createODBCDateTime(arguments.campaignBean.getDateCreated())#null, #createODBCDateTime(arguments.campaignBean.getLastUpdate())#null, , , #createODBCDateTime(LSDateFormat(arguments.campaignBean.getStartDate(),'mm/dd/yyyy'))#null, #createODBCDateTime(LSDateFormat(arguments.campaignBean.getEndDate(),'mm/dd/yyyy'))#null, #arguments.campaignBean.getIsActive()#, ) Select * from tadcampaigns where campaignID= update tadcampaigns set lastUpdate = #createODBCDateTime(arguments.campaignBean.getLastUpdate())#null, lastupdateBy = , name = , startDate = #createODBCDateTime(LSDateFormat(arguments.campaignBean.getStartDate(),'mm,dd,yyy'))#null, endDate = #createODBCDateTime(LSDateFormat(arguments.campaignBean.getEndDate(),'mm/dd/yyyy'))#null, isActive = #arguments.campaignBean.getIsActive()#, notes = where campaignID = delete from tadcampaigns where campaignID =