Hi!I am developing an application that will insert users into a database.So,I have the following code:
if(text1 != ""){
for(var j=1;j<=text6.length;j++)
{ SQLstr="INSERT INTO dbo.purchasingb (U_uid, Cost_Center, Initiated_On, Requested_On , Type, Name) VALUES ('"+text1+"','"+text2+"','"+text3+"','"+text4+"',' "+text5[j]+"','"+text6[j]+"')";
ADOrs.Execute(SQLstr);}
}
the problem I'm getting is that the first recording in the SQL Querry is undefined.The rest of the recordings are ok.Any help would be appreciated.