Code: Select all
ISFSArray result2 = dbManager.executeQuery(query, new Object[] {userName});
trace(result2);
if( result2.getText(0) == "nochar" && isAdded == false)
{
isAdded = true;
query = "UPDATE tbl_charselect SET char1 = ? WHERE Username = ?";
}
if( result2.getText(1).toString() == "nochar" && isAdded == false)
{
isAdded = true;
query = "UPDATE tbl_charselect SET char2 = ? WHERE Username = ?";
}
if( result2.getText(2).toString() == "nochar" && isAdded == false)
{
isAdded = true;
query = "UPDATE tbl_charselect SET char3 = ? WHERE Username = ?";
}
if( result2.getText(3).toString() == "nochar" && isAdded == false)
{
isAdded = true;
query = "UPDATE tbl_charselect SET char4 = ? WHERE Username = ?";
}
if( result2.getText(4).toString() == "nochar" && isAdded == false)
{
isAdded = true;
query = "UPDATE tbl_charselect SET char5 = ? WHERE Username = ?";
}
dbManager.executeUpdate(query, new Object[] {charName, userName});