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;
}
}
}