Inserting multiple records into a database from a table

i have dynamic table rows upto 10. trying insert records in these rows database ( msaccess)
table name: table1 ( in form )
database table : movies_comments ( posted in stefan's forums ).
table columns: username, movieid, comments

i using following code.
database.execsql() function posted in stefcamerons forums.

var tlength = xfa.resolvenode("form1.#subform[0].table1.row1[*]").length;
xfa.host.messagebox("tlength :" +tlength);

for ( var = 1; <= tlength; i++)
{
var username = xfa.resolvenode("form1.#subform[0].table1.row1["+i+"].user_name").rawvalue;
var movieid = xfa.resolvenode("form1.#subform[0].table1.row1["+i+"].movie_id").rawvalue;
var comments = xfa.resolvenode("form1.#subform[0].table1.row1["+i+"].comment_").rawvalue;

database.execsql("insert movie_comments (username, movieid, comment) values ('username','movieid', 'comments');");
}

i trying insert multiple records using code above. getting error
generalerror: operation failed.
xfaobject.resolvenode:1:xfa:form1[0]:#subform[0]:button1[0]:click
som expression returned list when single result expected

suggest me alternate way insert multiple records table database.

thank q

More discussions in LiveCycle pre-ES (6.x and 7.x) discussions

adobe