gistfile1.js

//do we have existing objects in the db we can upload?
db.transaction(function(trans) {
	trans.executeSql("select * from sighting", [], function(trans,result) {
		//do we have rows?
		if(result.rows.length > 0) {
			console.log("Ok, we need to push stuff up");
			for(var i=0, len=result.rows.length; i<len; i++) {
				var row = result.rows.item(i);

				(function(row) {
					//Parse will try to save everything, including ID, so make a quick new ob
					var report = {};
					report.numufos = row.numufos;
					report.yourname = row.yourname;
					report.description = row.description;

					saveToParse(report, function() { 
						console.log("i need to delete row "+row.id);
						db.transaction(function(trans) {
							trans.executeSql("delete from sighting where id = ?", [row.id]);
						}, errorCB);
					});
				}(row));

			}
		}
	},errorCB);
}, errorCB, function() {
	console.log("Done uploading the old rows");
});