insert into tmailinglist (mlid,name,lastupdate,siteid,isPublic,description,ispurge) values (,, #createodbcdatetime(now())#,,#arguments.listBean.getisPublic()#, ,0) Select * from tmailinglist where mlid= and siteid= update tmailinglist set name=, lastupdate=#createodbcdatetime(now())#, isPublic=, description= where mlid= and siteid= delete from tmailinglist where mlid= and siteid= delete from tcontentobjects where objectid= and object='mailing_list' and siteid= delete from tmailinglistmembers where mlid= and siteid=