Below is the code for my insert statement, i added the code for duplicate username, it alerts if it is duplicate BUT if it ISN'T duplicate the statement (else) doesn't execute. I know i have to create a new recordset object but i cant get it to work right
Code:
function insertStudentP()
{
var id = document.getElementById("peopleid").value;
var fn = document.getElementById("firstName").value;
var ln = document.getElementById("lastName").value;
var dob = document.getElementById("dob").value;
var role = document.getElementById("role").value;
var usr1 = document.getElementById("usr1").value;
var pswd1 = document.getElementById("pswd1").value;
var strSQL = "insert into Student(fname, lname, dob, role, usr, pswd) select('" + fn + "','" + ln + "','" + dob + "','" + role + "','" + usr1 + "','" + pswd1 + "')";
alert("SQL statement: " + strSQL);
var strSQL1 = "select * from student where usr ='" + usr1 +"'";
var conn = AdoDB("ADODB.Connection");
conn.open(conn_str, "", ""); //open my db connection
// declare my dataset
var dsStudent = new ActiveXObject("ADODB.Recordset");
if(pswd1.length <= 7 || pswd1.length >= 20 && usr1.length <=0 || fn.length<=0 || ln.length<=0 || dob.length<=0 || role=='admin' || role=='Admin' )
{
alert("Doesn't meet Password Requirements(8-20 Characters); Or Fill All The Fields Out");
}
else
{
dsStudent.open(strSQL1, conn, adOpenDynamic, adLockOptimistic);
if(usr1 == dsStudent.fields(5))
{
alert("It Failed;Duplicate Username");
}
else
{
alert("Power Add1");
dsStudent.open(strSQL, conn, adOpenDynamic, adLockOptimistic);
alert("insert completed");
}
}
}// close insertStudent