[RESOLVED] Why this function "is not a function" ?

This site is best viewed in a modern browser with JavaScript enabled.

[RESOLVED] Why this function "is not a function" ?

Ddurand

Hello :

This function generate an error in Opera (unhandled error : "X" is not a function) and in Chromium (Uncaught TypeError: undefined is not a function) :

db.transaction(function (tx)
	{
	tx.executeSql('insert INTO jointfightspec (name, special) VALUES (?,?)', [j1,jb1], function (tx, data)
		{

	});
})(jb1);

In the two browser, the script stop, but AFTER the Websql command has added one line (on the two expected) in the table.

I need the (jb1) at the end, because without it the value of jb1 is not passed into the function (global or not global).

Ddurand

Okay. Found.

That's because you can't call a function (by the jb1 on the last line) that is on the "transaction". You have to encapsulate it in another function and call this one. Like that :

	(function (jb1,jb2,jb3,jb4,jb5)
		{
		db.transaction(function(tx)
			{
			tx.executeSql('INSERT INTO special (s_id,s_name,s_fatigue,s_screen_name,s_color_menu) VALUES(?,?,?,?,?)',[jb1,jb2,jb3,jb4,jb5]),sql_ended("special table",special.length);
			});
		})(jb1,jb2,jb3,jb4,jb5);