mendenaresh1357 - Thursday, July 9, 2009 3:10 AM:
Hi everyone,
i have two itemtypes say 'A' & 'B'. i added few items to 'A'. now i have a field on the form 'B' say 'X'. it's source is 'A'. when i select 'X'(referring to id of a particular item ) i could populate the values of 'A' in the form B. but i couldnot save to the table.
the code is given below. it is on field 'X' (onchange event)
var myTextField = document.getElementById('enquiry_id');
var innovator = new Innovator();
var results = innovator.applyMethod("GetEnquiryDetails", "<Item></Item><id>" + myTextField.value + "</id>");
document.getElementById('first_name').value = results.getProperty('first_name');
document.getElementById('middle_name').value = results.getProperty('middle_name');
document.getElementById('last_name').value = results.getProperty('last_name');
document.getElementById('permanent_address').value = results.getProperty('permanent_address');
//document.getElementById('enquiry_contactno').value = results.getProperty('enquirer_contactno');
//document.getElementById('enquiry_mode').value = results.getProperty('enquiry_mode');
document.getElementById('enquiry_no').value = results.getProperty('enquiry_no');
//document.getElementById('enquiry_date').value = results.getProperty('enquiry_date');
//document.getElementById('enquirer_name').value = results.getProperty('enquirer_name');
document.getElementById('dob').value = results.getProperty('dob');
document.getElementById('age').value = results.getProperty('age');
document.getElementById('sex').value = results.getProperty('sex');
document.getElementById('identification_marks_1').value = results.getProperty('identification_marks_1');
document.getElementById('identification_marks_2').value = results.getProperty('identification_mark2');
document.getElementById('identification_marks_3').value = results.getProperty('identification_mark3');
document.getElementById('level_of_join_id').value = results.getProperty('joining_class_id');
document.getElementById('level_of_join').value = results.getProperty('joining_class');
document.getElementById('mother_tongue').value = results.getProperty('mother_tongue');
document.getElementById('nationality').value = results.getProperty('nationality');
document.getElementById('passport_no').value = results.getProperty('passport_no');
document.getElementById('present_address').value = results.getProperty('present_address');
document.getElementById('previous_school').value = results.getProperty('previous_school');
document.getElementById('school_representative').value = results.getProperty('school_representative');
document.getElementById('student_state').value = results.getProperty('student_state');
document.getElementById('year_of_admission').value = results.getProperty('year_of_admission');
handleItemChange("first_name", results.getProperty('first_name'));
handleItemChange("middle_name", results.getProperty('middle_name'));
handleItemChange("last_name", results.getProperty('last_name'));
handleItemChange("permanent_address", results.getProperty('permanent_address'));
//handleItemChange("enquiry_contactno", results.getProperty('enquirer_contactno'));
//handleItemChange("enquiry_mode", results.getProperty('enquiry_mode'));
handleItemChange("enquiry_no", results.getProperty('enquiry_no'));
//handleItemChange("enquiry_date", results.getProperty('enquiry_date'));
//handleItemChange("enquirer_name", results.getProperty('enquirer_name'));
handleItemChange("dob", results.getProperty('dob'));
handleItemChange("age", results.getProperty('age'));
handleItemChange("sex", results.getProperty('sex'));
handleItemChange("identification_marks_1", results.getProperty('identification_marks_1'));
handleItemChange("identification_marks_2", results.getProperty('identification_mark2'));
handleItemChange("identification_marks_3", results.getProperty('identification_mark3'));
handleItemChange("level_of_join_id", results.getProperty('joining_class_id'));
handleItemChange("level_of_join", results.getProperty('joining_class'));
handleItemChange("mother_tongue", results.getProperty('mother_tongue'));
handleItemChange("nationality", results.getProperty('nationality'));
handleItemChange("passport_no", results.getProperty('passport_no'));
handleItemChange("present_address", results.getProperty('present_address'));
handleItemChange("previous_school", results.getProperty('previous_school'));
handleItemChange("school_representative", results.getProperty('school_representative'));
handleItemChange("student_state", results.getProperty('student_state'));
handleItemChange("year_of_admission", results.getProperty('year_of_admission'));
if (resultItem.isError())
{
top.aras.AlertError(resultItem.getErrorDetail());
return;
}
from this i can display all the values in the Form 'B'. but i couln't update to the database for that i written a server side method
if (resultItem.isError())
{
top.aras.AlertError(resultItem.getErrorDetail());
return;
}
Item qryItem = this.newItem("Enquiries","get");
string strid = this.getProperty("id");
qryItem.setAttribute("select","first_name, middle_name, last_name, permanent_address, enquiry_no, dob, age, sex, identification_marks_1, identification_mark2, identification_mark3, joining_class_id, joining_class, mother_tongue, nationality, passport_no, present_address, previous_school, school_representative, student_state, year_of_admission");
qryItem.setProperty("id", strid, "eq");
Item results = qryItem.apply();
int count = results.getItemCount();
int i;
Item student_item = null;
for (i=0; i<count; ++i)
{
student_item = results.getItemByIndex(i);
}
return student_item;
what is the problem with the code?
Regards
Naresh
