[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);