单击视图时的应用器范围问题

我在这里疯了，试图弄清楚为什么我的变量的作用域不会从我的 Appcelerator 项目中的数据库中的 60 个项目的循环中获取正确的值。

我的地图标记显示正确的标签，但是当我单击它时，无论我尝试哪种范围组合，我都无法在警报中获得正确的值。它每次只返回第 60 个条目。

可能是小学生的错误，但这让我发疯了。

这是我的职能

function loadAnimals() {
var db = Ti.Database.open('myDB');
var getSpecies = db.execute('select * from species');
while (getSpecies.isValidRow()) {
    var speciesID = getSpecies.fieldByName('speciesnid');
    var speciesName = getSpecies.fieldByName('speciesname');
    var speciesDesc = getSpecies.fieldByName('speciesdescription');
    var speciesLatitude = getSpecies.fieldByName('specieslatitude');
    var speciesLongitude = getSpecies.fieldByName('specieslongitude');
    var speciesConStatus = getSpecies.fieldByName('speciesconservationstatus');
    var speciesMarkerFilename = getSpecies.fieldByName('speciesiconfilename'); 
    var speciesMarkerIcon = getSpecies.fieldByName('speciesmapicon');
    var speciesMarkerURI = getSpecies.fieldByName('speciesmapiconurl');
    var speciesImageFullPath = speciesMarkerURI.replace("public://", "http://myurl.com/");
    var speciesImageFullPath = speciesImageFullPath.replace(" ", "%20");
    var imageFile = Ti.Filesystem.getFile(Ti.Filesystem.applicationDataDirectory, speciesMarkerIcon);
    var iconFile = Ti.Filesystem.getFile(Ti.Filesystem.applicationDataDirectory, speciesMarkerFilename);

        var annotationView = Ti.UI.createView({
            backgroundColor: '#222222',
            width: 150,
            height: 75,
            layout:'vertical'
        });
        var addtoTourView = Ti.UI.createView({
            height:20,
            backgroundColor:'#6ea108'
        });

        var addtoTourTitle = Ti.UI.createLabel({
            color: '#FFF',
            text: 'ADD TO TOUR',
            width: 150,
            height: 15,
            top:3,
            textAlign: 'center',
            font: {
                fontSize: 14,
                fontWeight: 'bold'
            }
        });
        var annotationTitle = Ti.UI.createLabel({
            color: '#FFF',
            text: 'test',
            width: 150,
            height:15,
            top:0,
            textAlign: 'center',
            font: {
                fontSize: 14,
                fontWeight: 'normal'
            }
        });
        var blankView = Ti.UI.createView({
            backgroundColor: '#222222',
            width: 1,
            height: 73,
            borderRadius: 0
        });
        annotationView.add(addtoTourView);
        addtoTourView.add(addtoTourTitle);
        annotationView.add(annotationTitle);
        annotations.push(Map.createAnnotation({
            latitude: speciesLatitude,
            longitude: speciesLongitude,
            title: ' ',
            //pincolor: Map.ANNOTATION_RED,
            image: iconFile,
            animate: true,
            myid: speciesID,
            rightView: annotationView,
            leftView: blankView
        }));
        addtoTourView.addEventListener('click', function(e) {
            //alert(speciesName + ' has dded to Tour');
            var dialog = Ti.UI.createAlertDialog({
                message: 'Added to your Tour',
                ok: 'Continue',
                title: speciesName //this is the 60th entry, not the correct one
              });
              dialog.show();
            // do the insert into the DB
            var db = Ti.Database.open('myDB');
            db.execute('INSERT INTO tour (speciesnid) VALUES (?)', speciesID); // same with this ID, needs to the correct ID
            db.close();
        });
        annotationTitle.text = speciesName;

    //load up the next record
    getSpecies.next();
}; 
// close the database
getSpecies.close();
// add markers to map
mapview.annotations = annotations;

};//加载结束动物功能

谁能建议我做错了什么？