getColumns = function( oSelect ){ if ( oSelect.value != "?") { $.ajax({ url:"ajax/ajax_getTableColumns.cfm?table=" + oSelect.value, success: function( oHtml ){ $("#ownerIdColumn").html(oHtml); $("#ownerTypeColumn").html(oHtml); // Loop through values and select "best guess" $("#ownerIdColumn > option").each(function() { if ( this.value == "OWNERID" ) this.selected = true; }); // Loop through values and select "best guess" $("#ownerTypeColumn > option").each(function() { if ( this.value == "OWNERTYPE" || this.value == "FSL_TABLECODE" || this.value == "FSLTABLECODE" ) this.selected = true; }); } }); } else { $("#ownerIdColumn").html(""); $("#ownerTypeColumn").html(""); } } checkOwnerId = function ( oSelect ) { var ownerType = oSelect.value; if ( ownerType == "*" ) document.getElementById("addRuleOwnerId").value = 0; } deleteTable = function ( tableName, databaseName ) { if ( confirm("Are you sure you want to remove " + tableName + " from the archiver?") ){ $.ajax({ method: "POST", url: "act/act_deleteTable.cfm", data: {'tableName':tableName,'databaseName':databaseName}, success: function(){ location.reload(); }, error: function(xhr, status, error) { alert(error); } }); return true; } else { return false; } }