function GetContactHelpdeskCase (ContactCaseId,ContactId)
{
    var HelpdeskDefer = $.Deferred();
    var db = GetDatabase();
    db.transaction(function (tx) {
        var statement;
        var param;
        if(ContactId==0){
             if (ContactCaseId == null)
             {
                 // all
                 statement = GetAllContactHelpdeskCaseSql;
                 param = [];
             }
             else
             {
                 // filter by contact
                 statement = GetContactHelpdeskCaseSql;
                 param = [ContactCaseId];
             }
        }
        else{
             if (ContactCaseId == null)
                 {
                     // all
                     statement = GetAllContactHelpdeskCaseSql;
                     param = [];
                 }
                 else
                 {
                     // filter by contact
                     statement = GetContactHelpdeskCaseByContactIdSql;
                     param = [ContactId];
                 }
        }             tx.executeSql(statement, param, function (tx, results) {
                 if (results.rows.length <= 0)
                 {
                     HelpdeskDefer.resolve(null);
                     return;
                 }                 var list = new Array ();
                 for (var i = 0; i < results.rows.length; i++){
                         list[i] = results.rows.item(i);
                     }
                 HelpdeskDefer.resolve(list);
             }, HelpdeskCaseErrorHandler);
    }, HelpdeskCaseErrorHandler);
    return HelpdeskDefer.promise();
}表示ContactId==0时没问题。有数据、不等于0的时候也能查出数据
但是在HelpdeskDefer.resolve(list);这一步貌似除了问题、err信息为undefined、为什么?PhoneGap行业数据jqm