function toggle(element) { if(document.getElementById(element.value).disabled) { document.getElementById(element.value).disabled = false; } else { document.getElementById(element.value).disabled = true; } } function fixSlashes(element) { element.value = element.value.replace(/\\/g, '/'); lastchar = element.value.length; lastchar--; if(element.value.charAt(lastchar) != '/') { element.value = element.value + '/'; } } function automateFields(element) { //lower case the first character if needed if(element.value.charAt(0) >= 'A') { firstletter = element.value.charAt(0); firstletter = firstletter.toLowerCase(); element.value = firstletter + element.value.substr(1, element.value.length); } var tableName = element.value; var alias = ''; var resultset = ''; var override = false; var removeCharacters = new Array("----", "____", "---", "___", "--", "__", "-", "_"); //get the nasty ass characters out of the name for(i = 0; i < removeCharacters.length; i++) { if(tableName.search(removeCharacters[i]) != -1) { override = true; words = tableName.split(removeCharacters[i]); resultset = ''; for(a = 0; a < words.length; a++) { words[a] = words[a].substr(0,1).toUpperCase() + words[a].substr(1, words[a].length); resultset = resultset + words[a]; } tableName = resultset; } } //we form the alias in this loop for(i = 0; i < tableName.length; i++) { if(((tableName.charAt(i) >= 'A') && (tableName.charAt(i) <= 'Z')) || tableName.charAt(i) == '_') { override = true; if(tableName.charAt(i) == '_') { underscore = true; alias = alias + tableName.charAt(i + 1); i = i + 2; } else { alias = alias + tableName.charAt(i); } } } if(override) { alias = alias.toLowerCase(); document.getElementById('resultset-name').innerHTML = "$rsSelect_[query name]"; document.getElementById('alias-name').innerHTML = "FROM table AS "; document.mainform.select_rs_default.value = resultset; document.mainform.select_short_name.value = alias; } else { alias = tableName.charAt(0); alias = alias.toLowerCase(); resultset = tableName.substr(0,1).toUpperCase() + tableName.substr(1, tableName.length); document.getElementById('resultset-name').innerHTML = '$rsSelect' + resultset + '_[query name]'; document.getElementById('alias-name').innerHTML = 'FROM table AS ' + alias; } } function removeDollarSign(element) { if(element.value[0] == '$') { valueLength = element.value.length; element.value = element.value.substr(1, valueLength); } } function validate(form) { var formHealth = true; if(form.circuitname.value == '') { formHealth = false; form.circuitname.style.border = '2px solid red'; form.circuitname.focus(); } return formHealth; } function checkIfChecked(element, names) { if(element.checked) { for(a = 0; a < names.length; a++) { document.getElementById(names[a]).checked = true; } } }