select * from tclassextendattributes where tclassextendattributes.ExtendSetID= order by tclassextendattributes.orderno,tclassextendattributes.name select extendSetID,subTypeID,categoryID,siteID,name,orderno,isActive from tclassextendsets where ExtendSetID= select ExtendSetID from tclassextendsets where ExtendSetID= update tclassextendsets set siteID=, name=, subtypeID=, categoryID=, isActive=#getIsActive()#, orderno=#getOrderno()# where ExtendSetID= Insert into tclassextendsets (ExtendSetID,siteID,name,subtypeid,isActive,orderno,categoryID) values( , , , , #getIsActive()#, #getOrderno()#, ) delete from tclassextendsets where extendSetID=