Hi,
How do you use executeUpdate or executeCachedQuery with parameters?
I tried to feed the function with an array but it seems to expect a java.util.List. I don't know how to do that in javascript.
here is my non working code:
var patientData=new Array();
patientData.push($('LRN'));
patientData.push($('SSN'));
patientData.push($('Te_Id'));
patientData.push($('Id_Patient'));
patientData.push($('Id_User'));
patientData.push($('BirthDate'));
patientData.push($('Sex'));
patientData.push($('Title'));
patientData.push($('Nationality'));
patientData.push($('InCountry'));
patientData.push($('DeathDate'));
patientData.push($('Dead'));
patientData.push($('Create_Date'));
patientData.push($('Last_Update'));
patientData.push($('lname'));
patientData.push($('lname'));
patientData.push($('fname'));
patientData.push($('ygname'));
patientData.push($('Address'));
patientData.push($('City'));
patientData.push($('Region'));
patientData.push($('PhoneHome'));
patientData.push($('PhoneWork'));
var result = dbConn.executeUpdate('INSERT IGNORE INTO patients (your_id,eurosid,te_id,id_patient,id_user,birth_da te,sex,title,nationality,incountry,death_date,dead ,create_date,last_update,lname,fname,ygname,adress ,city,region,phone1,phone2) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);'
,patientData);
Thank you
How do you use executeUpdate or executeCachedQuery with parameters?
I tried to feed the function with an array but it seems to expect a java.util.List. I don't know how to do that in javascript.
here is my non working code:
var patientData=new Array();
patientData.push($('LRN'));
patientData.push($('SSN'));
patientData.push($('Te_Id'));
patientData.push($('Id_Patient'));
patientData.push($('Id_User'));
patientData.push($('BirthDate'));
patientData.push($('Sex'));
patientData.push($('Title'));
patientData.push($('Nationality'));
patientData.push($('InCountry'));
patientData.push($('DeathDate'));
patientData.push($('Dead'));
patientData.push($('Create_Date'));
patientData.push($('Last_Update'));
patientData.push($('lname'));
patientData.push($('lname'));
patientData.push($('fname'));
patientData.push($('ygname'));
patientData.push($('Address'));
patientData.push($('City'));
patientData.push($('Region'));
patientData.push($('PhoneHome'));
patientData.push($('PhoneWork'));
var result = dbConn.executeUpdate('INSERT IGNORE INTO patients (your_id,eurosid,te_id,id_patient,id_user,birth_da te,sex,title,nationality,incountry,death_date,dead ,create_date,last_update,lname,fname,ygname,adress ,city,region,phone1,phone2) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);'
,patientData);
Thank you
Comment