function QCLOSEDPLOTS(){
    var PlotID = null;
 var selectNoBlob = 'PlotID';
};
    QCLOSEDPLOTS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QCLOSEDPLOTS.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        return retVal;
    };
var QCLOSEDPLOTSDAO = function(){
};
QCLOSEDPLOTSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QCLOSEDPLOTS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QCLOSEDPLOTSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QCLOSEDPLOTS...");
        object.PlotID = resultset.fieldByName('PlotID');
    };
QCLOSEDPLOTSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID from QCLOSEDPLOTS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDPLOTSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID from QCLOSEDPLOTS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDPLOTSDAO.getUsing = function(where) {
        sqlstring = 'select PlotID from QCLOSEDPLOTS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QDRWGS(){
    var DrwgID = null;
    var ImageFilename = null;
    var DrwgTitle = null;
    var Photo = null;
    var PlottedPhoto = null;
    var srt = null;
    var LocID = null;
    var NotCurr = null;
    var EdgeNav = null;
    var GridNo = null;
    var Across = null;
    var Down = null;
    var TL = null;
    var T = null;
    var TR = null;
    var R = null;
    var BR = null;
    var B = null;
    var BL = null;
    var L = null;
 var selectNoBlob = 'DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L';
};
    QDRWGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QDRWGS.prototype.getImageFilename = function() {
        return this.ImageFilename;
    };
    QDRWGS.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QDRWGS.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QDRWGS where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QDRWGS.prototype.getPlottedPhoto = function() {
         if (this.PlottedPhoto == null) {
            result = db.getConnection().execute('select PlottedPhoto from QDRWGS where ');
            this.PlottedPhoto = result.field(0);
         }
        return this.PlottedPhoto;
    };
    QDRWGS.prototype.getsrt = function() {
        return this.srt;
    };
    QDRWGS.prototype.getLocID = function() {
        return this.LocID;
    };
    QDRWGS.prototype.getNotCurr = function() {
        return this.NotCurr;
    };
    QDRWGS.prototype.getEdgeNav = function() {
        return this.EdgeNav;
    };
    QDRWGS.prototype.getGridNo = function() {
        return this.GridNo;
    };
    QDRWGS.prototype.getAcross = function() {
        return this.Across;
    };
    QDRWGS.prototype.getDown = function() {
        return this.Down;
    };
    QDRWGS.prototype.getTL = function() {
        return this.TL;
    };
    QDRWGS.prototype.getT = function() {
        return this.T;
    };
    QDRWGS.prototype.getTR = function() {
        return this.TR;
    };
    QDRWGS.prototype.getR = function() {
        return this.R;
    };
    QDRWGS.prototype.getBR = function() {
        return this.BR;
    };
    QDRWGS.prototype.getB = function() {
        return this.B;
    };
    QDRWGS.prototype.getBL = function() {
        return this.BL;
    };
    QDRWGS.prototype.getL = function() {
        return this.L;
    };
    QDRWGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[ImageFilename][" + this.ImageFilename + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[PlottedPhoto][" + this.PlottedPhoto + "]";
        retVal += "[srt][" + this.srt + "]";
        retVal += "[LocID][" + this.LocID + "]";
        retVal += "[NotCurr][" + this.NotCurr + "]";
        retVal += "[EdgeNav][" + this.EdgeNav + "]";
        retVal += "[GridNo][" + this.GridNo + "]";
        retVal += "[Across][" + this.Across + "]";
        retVal += "[Down][" + this.Down + "]";
        retVal += "[TL][" + this.TL + "]";
        retVal += "[T][" + this.T + "]";
        retVal += "[TR][" + this.TR + "]";
        retVal += "[R][" + this.R + "]";
        retVal += "[BR][" + this.BR + "]";
        retVal += "[B][" + this.B + "]";
        retVal += "[BL][" + this.BL + "]";
        retVal += "[L][" + this.L + "]";
        return retVal;
    };
var QDRWGSDAO = function(){
};
QDRWGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QDRWGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QDRWGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QDRWGS...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.ImageFilename = resultset.fieldByName('ImageFilename');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.srt = resultset.fieldByName('srt');
        object.LocID = resultset.fieldByName('LocID');
        object.NotCurr = resultset.fieldByName('NotCurr');
        object.EdgeNav = resultset.fieldByName('EdgeNav');
        object.GridNo = resultset.fieldByName('GridNo');
        object.Across = resultset.fieldByName('Across');
        object.Down = resultset.fieldByName('Down');
        object.TL = resultset.fieldByName('TL');
        object.T = resultset.fieldByName('T');
        object.TR = resultset.fieldByName('TR');
        object.R = resultset.fieldByName('R');
        object.BR = resultset.fieldByName('BR');
        object.B = resultset.fieldByName('B');
        object.BL = resultset.fieldByName('BL');
        object.L = resultset.fieldByName('L');
    };
QDRWGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingImageFilename = function(ImageFilename) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where ImageFilename = ? ',ImageFilename);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingPlottedPhoto = function(PlottedPhoto) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where PlottedPhoto = ? ',PlottedPhoto);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingsrt = function(srt) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where srt = ? ',srt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingLocID = function(LocID) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where LocID = ? ',LocID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingNotCurr = function(NotCurr) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where NotCurr = ? ',NotCurr);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingEdgeNav = function(EdgeNav) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where EdgeNav = ? ',EdgeNav);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingGridNo = function(GridNo) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where GridNo = ? ',GridNo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingAcross = function(Across) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where Across = ? ',Across);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingDown = function(Down) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where Down = ? ',Down);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingTL = function(TL) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where TL = ? ',TL);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingT = function(T) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where T = ? ',T);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingTR = function(TR) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where TR = ? ',TR);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingR = function(R) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where R = ? ',R);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingBR = function(BR) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where BR = ? ',BR);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingB = function(B) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where B = ? ',B);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingBL = function(BL) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where BL = ? ',BL);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsingL = function(L) {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where L = ? ',L);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,ImageFilename,DrwgTitle,srt,LocID,NotCurr,EdgeNav,GridNo,Across,Down,TL,T,TR,R,BR,B,BL,L from QDRWGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QDRWGSNAGS(){
    var DrwgID = null;
    var CountofDrwgSnags = null;
 var selectNoBlob = 'DrwgID,CountofDrwgSnags';
};
    QDRWGSNAGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QDRWGSNAGS.prototype.getCountofDrwgSnags = function() {
        return this.CountofDrwgSnags;
    };
    QDRWGSNAGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[CountofDrwgSnags][" + this.CountofDrwgSnags + "]";
        return retVal;
    };
var QDRWGSNAGSDAO = function(){
};
QDRWGSNAGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QDRWGSNAGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QDRWGSNAGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QDRWGSNAGS...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.CountofDrwgSnags = resultset.fieldByName('CountofDrwgSnags');
    };
QDRWGSNAGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,CountofDrwgSnags from QDRWGSNAGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDAO.getUsingCountofDrwgSnags = function(CountofDrwgSnags) {
        var resultset =  db.getConnection().execute('select DrwgID,CountofDrwgSnags from QDRWGSNAGS where CountofDrwgSnags = ? ',CountofDrwgSnags);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,CountofDrwgSnags from QDRWGSNAGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,CountofDrwgSnags from QDRWGSNAGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPS(){
    var GroupID = null;
    var Groupname = null;
    var GroupInits = null;
    var Email = null;
 var selectNoBlob = 'GroupID,Groupname,GroupInits,Email';
};
    QGROUPS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QGROUPS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QGROUPS.prototype.getEmail = function() {
        return this.Email;
    };
    QGROUPS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[Email][" + this.Email + "]";
        return retVal;
    };
var QGROUPSDAO = function(){
};
QGROUPSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.Email = resultset.fieldByName('Email');
    };
QGROUPSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QGROUPS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QGROUPS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QGROUPS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSDAO.getUsingEmail = function(Email) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QGROUPS where Email = ? ',Email);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QGROUPS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,Groupname,GroupInits,Email from QGROUPS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGDRWGS(){
    var GroupID = null;
    var DrwgID = null;
    var CountOfSnagID = null;
    var GroupInits = null;
 var selectNoBlob = 'GroupID,DrwgID,CountOfSnagID,GroupInits';
};
    QGROUPSNAGDRWGS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGDRWGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QGROUPSNAGDRWGS.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QGROUPSNAGDRWGS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QGROUPSNAGDRWGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        return retVal;
    };
var QGROUPSNAGDRWGSDAO = function(){
};
QGROUPSNAGDRWGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGDRWGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGDRWGS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
        object.GroupInits = resultset.fieldByName('GroupInits');
    };
QGROUPSNAGDRWGSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,DrwgID,CountOfSnagID,GroupInits from QGROUPSNAGDRWGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGS(){
    var GroupID = null;
    var CountOfSnagID = null;
 var selectNoBlob = 'GroupID,CountOfSnagID';
};
    QGROUPSNAGS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGS.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QGROUPSNAGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        return retVal;
    };
var QGROUPSNAGSDAO = function(){
};
QGROUPSNAGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
    };
QGROUPSNAGSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,CountOfSnagID from QGROUPSNAGS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select GroupID,CountOfSnagID from QGROUPSNAGS where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,CountOfSnagID from QGROUPSNAGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,CountOfSnagID from QGROUPSNAGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QLINKS(){
    var SnagID = null;
    var DrwgID = null;
    var Status = null;
    var ShortDescrip = null;
    var Location = null;
    var Xcoord = null;
    var YCoord = null;
    var Priority = null;
    var Datestamp = null;
    var DrwgLink = null;
    var Photo = null;
    var DoBy = null;
    var PPCGUID = null;
    var GroupID = null;
    var GroupInits = null;
    var DateClosed = null;
    var BigPhoto = null;
    var SCID = null;
    var Lat = null;
    var Lng = null;
    var Owner = null;
    var SDCode = null;
    var SDID = null;
    var PlotID = null;
    var TradeCode = null;
    var MPGUID = null;
 var selectNoBlob = 'SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID';
};
    QLINKS.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QLINKS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QLINKS.prototype.getStatus = function() {
        return this.Status;
    };
    QLINKS.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QLINKS.prototype.getLocation = function() {
        return this.Location;
    };
    QLINKS.prototype.getXcoord = function() {
        return this.Xcoord;
    };
    QLINKS.prototype.getYCoord = function() {
        return this.YCoord;
    };
    QLINKS.prototype.getPriority = function() {
        return this.Priority;
    };
    QLINKS.prototype.getDatestamp = function() {
        return this.Datestamp;
    };
    QLINKS.prototype.getDrwgLink = function() {
        return this.DrwgLink;
    };
    QLINKS.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QLINKS where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QLINKS.prototype.getDoBy = function() {
        return this.DoBy;
    };
    QLINKS.prototype.getPPCGUID = function() {
        return this.PPCGUID;
    };
    QLINKS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QLINKS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QLINKS.prototype.getDateClosed = function() {
        return this.DateClosed;
    };
    QLINKS.prototype.getBigPhoto = function() {
         if (this.BigPhoto == null) {
            result = db.getConnection().execute('select BigPhoto from QLINKS where ');
            this.BigPhoto = result.field(0);
         }
        return this.BigPhoto;
    };
    QLINKS.prototype.getSCID = function() {
        return this.SCID;
    };
    QLINKS.prototype.getLat = function() {
        return this.Lat;
    };
    QLINKS.prototype.getLng = function() {
        return this.Lng;
    };
    QLINKS.prototype.getOwner = function() {
        return this.Owner;
    };
    QLINKS.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QLINKS.prototype.getSDID = function() {
        return this.SDID;
    };
    QLINKS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QLINKS.prototype.getTradeCode = function() {
        return this.TradeCode;
    };
    QLINKS.prototype.getMPGUID = function() {
        return this.MPGUID;
    };
    QLINKS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[Xcoord][" + this.Xcoord + "]";
        retVal += "[YCoord][" + this.YCoord + "]";
        retVal += "[Priority][" + this.Priority + "]";
        retVal += "[Datestamp][" + this.Datestamp + "]";
        retVal += "[DrwgLink][" + this.DrwgLink + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[DoBy][" + this.DoBy + "]";
        retVal += "[PPCGUID][" + this.PPCGUID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[DateClosed][" + this.DateClosed + "]";
        retVal += "[BigPhoto][" + this.BigPhoto + "]";
        retVal += "[SCID][" + this.SCID + "]";
        retVal += "[Lat][" + this.Lat + "]";
        retVal += "[Lng][" + this.Lng + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[SDID][" + this.SDID + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[TradeCode][" + this.TradeCode + "]";
        retVal += "[MPGUID][" + this.MPGUID + "]";
        return retVal;
    };
var QLINKSDAO = function(){
};
QLINKSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QLINKS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QLINKSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QLINKS...");
        object.SnagID = resultset.fieldByName('SnagID');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Status = resultset.fieldByName('Status');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.Xcoord = resultset.fieldByName('Xcoord');
        object.YCoord = resultset.fieldByName('YCoord');
        object.Priority = resultset.fieldByName('Priority');
        object.Datestamp = resultset.fieldByName('Datestamp');
        object.DrwgLink = resultset.fieldByName('DrwgLink');
        object.DoBy = resultset.fieldByName('DoBy');
        object.PPCGUID = resultset.fieldByName('PPCGUID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.DateClosed = resultset.fieldByName('DateClosed');
        object.SCID = resultset.fieldByName('SCID');
        object.Lat = resultset.fieldByName('Lat');
        object.Lng = resultset.fieldByName('Lng');
        object.Owner = resultset.fieldByName('Owner');
        object.SDCode = resultset.fieldByName('SDCode');
        object.SDID = resultset.fieldByName('SDID');
        object.PlotID = resultset.fieldByName('PlotID');
        object.TradeCode = resultset.fieldByName('TradeCode');
        object.MPGUID = resultset.fieldByName('MPGUID');
    };
QLINKSDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingXcoord = function(Xcoord) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Xcoord = ? ',Xcoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingYCoord = function(YCoord) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where YCoord = ? ',YCoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingPriority = function(Priority) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Priority = ? ',Priority);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingDatestamp = function(Datestamp) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Datestamp = ? ',Datestamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingDrwgLink = function(DrwgLink) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where DrwgLink = ? ',DrwgLink);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingDoBy = function(DoBy) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where DoBy = ? ',DoBy);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingPPCGUID = function(PPCGUID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where PPCGUID = ? ',PPCGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingDateClosed = function(DateClosed) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where DateClosed = ? ',DateClosed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingBigPhoto = function(BigPhoto) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where BigPhoto = ? ',BigPhoto);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingSCID = function(SCID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where SCID = ? ',SCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingLat = function(Lat) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Lat = ? ',Lat);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingLng = function(Lng) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Lng = ? ',Lng);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingSDID = function(SDID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where SDID = ? ',SDID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingTradeCode = function(TradeCode) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where TradeCode = ? ',TradeCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsingMPGUID = function(MPGUID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where MPGUID = ? ',MPGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLINKSDAO.getUsing = function(where) {
        sqlstring = 'select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID from QLINKS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QPASSEDPLOTS(){
    var PlotID = null;
    var SumOfPasses = null;
    var CountOfSCID = null;
 var selectNoBlob = 'PlotID,SumOfPasses,CountOfSCID';
};
    QPASSEDPLOTS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QPASSEDPLOTS.prototype.getSumOfPasses = function() {
        return this.SumOfPasses;
    };
    QPASSEDPLOTS.prototype.getCountOfSCID = function() {
        return this.CountOfSCID;
    };
    QPASSEDPLOTS.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[SumOfPasses][" + this.SumOfPasses + "]";
        retVal += "[CountOfSCID][" + this.CountOfSCID + "]";
        return retVal;
    };
var QPASSEDPLOTSDAO = function(){
};
QPASSEDPLOTSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QPASSEDPLOTS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QPASSEDPLOTSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QPASSEDPLOTS...");
        object.PlotID = resultset.fieldByName('PlotID');
        object.SumOfPasses = resultset.fieldByName('SumOfPasses');
        object.CountOfSCID = resultset.fieldByName('CountOfSCID');
    };
QPASSEDPLOTSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID,SumOfPasses,CountOfSCID from QPASSEDPLOTS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QPASSEDPLOTSDAO.getUsingSumOfPasses = function(SumOfPasses) {
        var resultset =  db.getConnection().execute('select PlotID,SumOfPasses,CountOfSCID from QPASSEDPLOTS where SumOfPasses = ? ',SumOfPasses);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QPASSEDPLOTSDAO.getUsingCountOfSCID = function(CountOfSCID) {
        var resultset =  db.getConnection().execute('select PlotID,SumOfPasses,CountOfSCID from QPASSEDPLOTS where CountOfSCID = ? ',CountOfSCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QPASSEDPLOTSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID,SumOfPasses,CountOfSCID from QPASSEDPLOTS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QPASSEDPLOTSDAO.getUsing = function(where) {
        sqlstring = 'select PlotID,SumOfPasses,CountOfSCID from QPASSEDPLOTS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDPLOTTOTS(){
    var PlotID = null;
    var Passed = null;
    var TotChks = null;
    var Failed = null;
    var NotCheckd = null;
 var selectNoBlob = 'PlotID,Passed,TotChks,Failed,NotCheckd';
};
    QSCHEDPLOTTOTS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDPLOTTOTS.prototype.getPassed = function() {
        return this.Passed;
    };
    QSCHEDPLOTTOTS.prototype.getTotChks = function() {
        return this.TotChks;
    };
    QSCHEDPLOTTOTS.prototype.getFailed = function() {
        return this.Failed;
    };
    QSCHEDPLOTTOTS.prototype.getNotCheckd = function() {
        return this.NotCheckd;
    };
    QSCHEDPLOTTOTS.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[Passed][" + this.Passed + "]";
        retVal += "[TotChks][" + this.TotChks + "]";
        retVal += "[Failed][" + this.Failed + "]";
        retVal += "[NotCheckd][" + this.NotCheckd + "]";
        return retVal;
    };
var QSCHEDPLOTTOTSDAO = function(){
};
QSCHEDPLOTTOTSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDPLOTTOTS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDPLOTTOTS...");
        object.PlotID = resultset.fieldByName('PlotID');
        object.Passed = resultset.fieldByName('Passed');
        object.TotChks = resultset.fieldByName('TotChks');
        object.Failed = resultset.fieldByName('Failed');
        object.NotCheckd = resultset.fieldByName('NotCheckd');
    };
QSCHEDPLOTTOTSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getUsingPassed = function(Passed) {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where Passed = ? ',Passed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getUsingTotChks = function(TotChks) {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where TotChks = ? ',TotChks);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getUsingFailed = function(Failed) {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where Failed = ? ',Failed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getUsingNotCheckd = function(NotCheckd) {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where NotCheckd = ? ',NotCheckd);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTTOTSDAO.getUsing = function(where) {
        sqlstring = 'select PlotID,Passed,TotChks,Failed,NotCheckd from QSCHEDPLOTTOTS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSELCOMMENTS(){
    var Comment = null;
 var selectNoBlob = 'Comment';
};
    QSELCOMMENTS.prototype.getComment = function() {
        return this.Comment;
    };
    QSELCOMMENTS.prototype.toString = function() {
        var retVal = "";
        retVal += "[Comment][" + this.Comment + "]";
        return retVal;
    };
var QSELCOMMENTSDAO = function(){
};
QSELCOMMENTSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSELCOMMENTS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSELCOMMENTSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSELCOMMENTS...");
        object.Comment = resultset.fieldByName('Comment');
    };
QSELCOMMENTSDAO.getUsingComment = function(Comment) {
        var resultset =  db.getConnection().execute('select Comment from QSELCOMMENTS where Comment = ? ',Comment);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELCOMMENTSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select Comment from QSELCOMMENTS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELCOMMENTSDAO.getUsing = function(where) {
        sqlstring = 'select Comment from QSELCOMMENTS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSELDRWGS(){
    var DrwgTitle = null;
    var DrwgID = null;
 var selectNoBlob = 'DrwgTitle,DrwgID';
};
    QSELDRWGS.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QSELDRWGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSELDRWGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        return retVal;
    };
var QSELDRWGSDAO = function(){
};
QSELDRWGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSELDRWGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSELDRWGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSELDRWGS...");
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.DrwgID = resultset.fieldByName('DrwgID');
    };
QSELDRWGSDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select DrwgTitle,DrwgID from QSELDRWGS where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgTitle,DrwgID from QSELDRWGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgTitle,DrwgID from QSELDRWGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSDAO.getUsing = function(where) {
        sqlstring = 'select DrwgTitle,DrwgID from QSELDRWGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSELDRWGSETS(){
    var DSID = null;
    var DSname = null;
 var selectNoBlob = 'DSID,DSname';
};
    QSELDRWGSETS.prototype.getDSID = function() {
        return this.DSID;
    };
    QSELDRWGSETS.prototype.getDSname = function() {
        return this.DSname;
    };
    QSELDRWGSETS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DSID][" + this.DSID + "]";
        retVal += "[DSname][" + this.DSname + "]";
        return retVal;
    };
var QSELDRWGSETSDAO = function(){
};
QSELDRWGSETSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSELDRWGSETS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSELDRWGSETSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSELDRWGSETS...");
        object.DSID = resultset.fieldByName('DSID');
        object.DSname = resultset.fieldByName('DSname');
    };
QSELDRWGSETSDAO.getUsingDSID = function(DSID) {
        var resultset =  db.getConnection().execute('select DSID,DSname from QSELDRWGSETS where DSID = ? ',DSID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSETSDAO.getUsingDSname = function(DSname) {
        var resultset =  db.getConnection().execute('select DSID,DSname from QSELDRWGSETS where DSname = ? ',DSname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSETSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DSID,DSname from QSELDRWGSETS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELDRWGSETSDAO.getUsing = function(where) {
        sqlstring = 'select DSID,DSname from QSELDRWGSETS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSELGROUPS(){
    var GroupID = null;
    var Groupname = null;
 var selectNoBlob = 'GroupID,Groupname';
};
    QSELGROUPS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QSELGROUPS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QSELGROUPS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        return retVal;
    };
var QSELGROUPSDAO = function(){
};
QSELGROUPSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSELGROUPS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSELGROUPSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSELGROUPS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
    };
QSELGROUPSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname from QSELGROUPS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELGROUPSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname from QSELGROUPS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELGROUPSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,Groupname from QSELGROUPS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELGROUPSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,Groupname from QSELGROUPS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSUBCONS(){
    var GroupID = null;
    var Groupname = null;
    var GroupInits = null;
    var Email = null;
 var selectNoBlob = 'GroupID,Groupname,GroupInits,Email';
};
    QSUBCONS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QSUBCONS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QSUBCONS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QSUBCONS.prototype.getEmail = function() {
        return this.Email;
    };
    QSUBCONS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[Email][" + this.Email + "]";
        return retVal;
    };
var QSUBCONSDAO = function(){
};
QSUBCONSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSUBCONS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSUBCONSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSUBCONS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.Email = resultset.fieldByName('Email');
    };
QSUBCONSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QSUBCONS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSUBCONSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QSUBCONS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSUBCONSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QSUBCONS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSUBCONSDAO.getUsingEmail = function(Email) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QSUBCONS where Email = ? ',Email);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSUBCONSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,Email from QSUBCONS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSUBCONSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,Groupname,GroupInits,Email from QSUBCONS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGSDRWGGROUPCNT(){
    var DrwgID = null;
    var GroupID = null;
    var Groupname = null;
    var UserID = null;
    var CountOfSnagID = null;
 var selectNoBlob = 'DrwgID,GroupID,Groupname,UserID,CountOfSnagID';
};
    QUSERSNAGSDRWGGROUPCNT.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QUSERSNAGSDRWGGROUPCNT.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QUSERSNAGSDRWGGROUPCNT.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QUSERSNAGSDRWGGROUPCNT.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGSDRWGGROUPCNT.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QUSERSNAGSDRWGGROUPCNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        return retVal;
    };
var QUSERSNAGSDRWGGROUPCNTDAO = function(){
};
QUSERSNAGSDRWGGROUPCNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGSDRWGGROUPCNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGSDRWGGROUPCNT...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.UserID = resultset.fieldByName('UserID');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDRWGGROUPCNTDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,GroupID,Groupname,UserID,CountOfSnagID from QUSERSNAGSDRWGGROUPCNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGSGROUPCNT(){
    var UserID = null;
    var GroupID = null;
    var Groupname = null;
    var CountOfSnagID = null;
 var selectNoBlob = 'UserID,GroupID,Groupname,CountOfSnagID';
};
    QUSERSNAGSGROUPCNT.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGSGROUPCNT.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QUSERSNAGSGROUPCNT.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QUSERSNAGSGROUPCNT.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QUSERSNAGSGROUPCNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        return retVal;
    };
var QUSERSNAGSGROUPCNTDAO = function(){
};
QUSERSNAGSGROUPCNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGSGROUPCNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGSGROUPCNT...");
        object.UserID = resultset.fieldByName('UserID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
    };
QUSERSNAGSGROUPCNTDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPCNTDAO.getUsing = function(where) {
        sqlstring = 'select UserID,GroupID,Groupname,CountOfSnagID from QUSERSNAGSGROUPCNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGSGROUPDRWGCNT(){
    var DrwgID = null;
    var DrwgTitle = null;
    var CountOfSnagID = null;
    var GroupID = null;
    var UserID = null;
 var selectNoBlob = 'DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID';
};
    QUSERSNAGSGROUPDRWGCNT.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QUSERSNAGSGROUPDRWGCNT.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QUSERSNAGSGROUPDRWGCNT.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QUSERSNAGSGROUPDRWGCNT.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QUSERSNAGSGROUPDRWGCNT.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGSGROUPDRWGCNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[UserID][" + this.UserID + "]";
        return retVal;
    };
var QUSERSNAGSGROUPDRWGCNTDAO = function(){
};
QUSERSNAGSGROUPDRWGCNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGSGROUPDRWGCNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGSGROUPDRWGCNT...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.UserID = resultset.fieldByName('UserID');
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSGROUPDRWGCNTDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,DrwgTitle,CountOfSnagID,GroupID,UserID from QUSERSNAGSGROUPDRWGCNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGSOWNERCNT(){
    var UserID = null;
    var Owner = null;
    var Fullname = null;
    var CountOfSnagID = null;
 var selectNoBlob = 'UserID,Owner,Fullname,CountOfSnagID';
};
    QUSERSNAGSOWNERCNT.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGSOWNERCNT.prototype.getOwner = function() {
        return this.Owner;
    };
    QUSERSNAGSOWNERCNT.prototype.getFullname = function() {
        return this.Fullname;
    };
    QUSERSNAGSOWNERCNT.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QUSERSNAGSOWNERCNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[Fullname][" + this.Fullname + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        return retVal;
    };
var QUSERSNAGSOWNERCNTDAO = function(){
};
QUSERSNAGSOWNERCNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGSOWNERCNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGSOWNERCNT...");
        object.UserID = resultset.fieldByName('UserID');
        object.Owner = resultset.fieldByName('Owner');
        object.Fullname = resultset.fieldByName('Fullname');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
    };
QUSERSNAGSOWNERCNTDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.getUsingFullname = function(Fullname) {
        var resultset =  db.getConnection().execute('select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT where Fullname = ? ',Fullname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERCNTDAO.getUsing = function(where) {
        sqlstring = 'select UserID,Owner,Fullname,CountOfSnagID from QUSERSNAGSOWNERCNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGSOWNERDRWGCNT(){
    var DrwgID = null;
    var DrwgTitle = null;
    var CountOfSnagID = null;
    var Owner = null;
    var UserID = null;
 var selectNoBlob = 'DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID';
};
    QUSERSNAGSOWNERDRWGCNT.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QUSERSNAGSOWNERDRWGCNT.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QUSERSNAGSOWNERDRWGCNT.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QUSERSNAGSOWNERDRWGCNT.prototype.getOwner = function() {
        return this.Owner;
    };
    QUSERSNAGSOWNERDRWGCNT.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGSOWNERDRWGCNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[UserID][" + this.UserID + "]";
        return retVal;
    };
var QUSERSNAGSOWNERDRWGCNTDAO = function(){
};
QUSERSNAGSOWNERDRWGCNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGSOWNERDRWGCNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGSOWNERDRWGCNT...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
        object.Owner = resultset.fieldByName('Owner');
        object.UserID = resultset.fieldByName('UserID');
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSOWNERDRWGCNTDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,DrwgTitle,CountOfSnagID,Owner,UserID from QUSERSNAGSOWNERDRWGCNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPDRWGS(){
    var GroupID = null;
    var Groupname = null;
    var GroupInits = null;
    var DrwgID = null;
    var DrwgTitle = null;
    var srt = null;
 var selectNoBlob = 'GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt';
};
    QGROUPDRWGS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPDRWGS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QGROUPDRWGS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QGROUPDRWGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QGROUPDRWGS.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QGROUPDRWGS.prototype.getsrt = function() {
        return this.srt;
    };
    QGROUPDRWGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[srt][" + this.srt + "]";
        return retVal;
    };
var QGROUPDRWGSDAO = function(){
};
QGROUPDRWGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPDRWGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPDRWGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPDRWGS...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.srt = resultset.fieldByName('srt');
    };
QGROUPDRWGSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsingsrt = function(srt) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where srt = ? ',srt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPDRWGSDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,Groupname,GroupInits,DrwgID,DrwgTitle,srt from QGROUPDRWGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QDRWGSNAGSDDL(){
    var DrwgID = null;
    var DrwgTitleCntr = null;
    var DrwgSnags = null;
 var selectNoBlob = 'DrwgID,DrwgTitleCntr,DrwgSnags';
};
    QDRWGSNAGSDDL.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QDRWGSNAGSDDL.prototype.getDrwgTitleCntr = function() {
        return this.DrwgTitleCntr;
    };
    QDRWGSNAGSDDL.prototype.getDrwgSnags = function() {
        return this.DrwgSnags;
    };
    QDRWGSNAGSDDL.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitleCntr][" + this.DrwgTitleCntr + "]";
        retVal += "[DrwgSnags][" + this.DrwgSnags + "]";
        return retVal;
    };
var QDRWGSNAGSDDLDAO = function(){
};
QDRWGSNAGSDDLDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QDRWGSNAGSDDL();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QDRWGSNAGSDDLDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QDRWGSNAGSDDL...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitleCntr = resultset.fieldByName('DrwgTitleCntr');
        object.DrwgSnags = resultset.fieldByName('DrwgSnags');
    };
QDRWGSNAGSDDLDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitleCntr,DrwgSnags from QDRWGSNAGSDDL where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDDLDAO.getUsingDrwgTitleCntr = function(DrwgTitleCntr) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitleCntr,DrwgSnags from QDRWGSNAGSDDL where DrwgTitleCntr = ? ',DrwgTitleCntr);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDDLDAO.getUsingDrwgSnags = function(DrwgSnags) {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitleCntr,DrwgSnags from QDRWGSNAGSDDL where DrwgSnags = ? ',DrwgSnags);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDDLDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,DrwgTitleCntr,DrwgSnags from QDRWGSNAGSDDL');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QDRWGSNAGSDDLDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,DrwgTitleCntr,DrwgSnags from QDRWGSNAGSDDL where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGSCOUNT(){
    var GroupID = null;
    var groupname = null;
 var selectNoBlob = 'GroupID,groupname';
};
    QGROUPSNAGSCOUNT.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGSCOUNT.prototype.getgroupname = function() {
        return this.groupname;
    };
    QGROUPSNAGSCOUNT.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[groupname][" + this.groupname + "]";
        return retVal;
    };
var QGROUPSNAGSCOUNTDAO = function(){
};
QGROUPSNAGSCOUNTDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGSCOUNT();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGSCOUNTDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGSCOUNT...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.groupname = resultset.fieldByName('groupname');
    };
QGROUPSNAGSCOUNTDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,groupname from QGROUPSNAGSCOUNT where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSCOUNTDAO.getUsinggroupname = function(groupname) {
        var resultset =  db.getConnection().execute('select GroupID,groupname from QGROUPSNAGSCOUNT where groupname = ? ',groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSCOUNTDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,groupname from QGROUPSNAGSCOUNT');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSCOUNTDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,groupname from QGROUPSNAGSCOUNT where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGDRWGSDDL(){
    var GroupID = null;
    var Groupname = null;
    var DrwgID = null;
    var DrwgTitle = null;
    var CountOfSnagID = null;
 var selectNoBlob = 'GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID';
};
    QGROUPSNAGDRWGSDDL.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGDRWGSDDL.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QGROUPSNAGDRWGSDDL.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QGROUPSNAGDRWGSDDL.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QGROUPSNAGDRWGSDDL.prototype.getCountOfSnagID = function() {
        return this.CountOfSnagID;
    };
    QGROUPSNAGDRWGSDDL.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[CountOfSnagID][" + this.CountOfSnagID + "]";
        return retVal;
    };
var QGROUPSNAGDRWGSDDLDAO = function(){
};
QGROUPSNAGDRWGSDDLDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGDRWGSDDL();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGDRWGSDDL...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.CountOfSnagID = resultset.fieldByName('CountOfSnagID');
    };
QGROUPSNAGDRWGSDDLDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getUsingCountOfSnagID = function(CountOfSnagID) {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where CountOfSnagID = ? ',CountOfSnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGDRWGSDDLDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,Groupname,DrwgID,DrwgTitle,CountOfSnagID from QGROUPSNAGDRWGSDDL where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGSUSER(){
    var GroupID = null;
    var groupname = null;
    var UserID = null;
 var selectNoBlob = 'GroupID,groupname,UserID';
};
    QGROUPSNAGSUSER.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGSUSER.prototype.getgroupname = function() {
        return this.groupname;
    };
    QGROUPSNAGSUSER.prototype.getUserID = function() {
        return this.UserID;
    };
    QGROUPSNAGSUSER.prototype.toString = function() {
        var retVal = "";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[groupname][" + this.groupname + "]";
        retVal += "[UserID][" + this.UserID + "]";
        return retVal;
    };
var QGROUPSNAGSUSERDAO = function(){
};
QGROUPSNAGSUSERDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGSUSER();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGSUSERDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGSUSER...");
        object.GroupID = resultset.fieldByName('GroupID');
        object.groupname = resultset.fieldByName('groupname');
        object.UserID = resultset.fieldByName('UserID');
    };
QGROUPSNAGSUSERDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select GroupID,groupname,UserID from QGROUPSNAGSUSER where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSUSERDAO.getUsinggroupname = function(groupname) {
        var resultset =  db.getConnection().execute('select GroupID,groupname,UserID from QGROUPSNAGSUSER where groupname = ? ',groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSUSERDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select GroupID,groupname,UserID from QGROUPSNAGSUSER where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSUSERDAO.getall = function() {
        var resultset =  db.getConnection().execute('select GroupID,groupname,UserID from QGROUPSNAGSUSER');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGSUSERDAO.getUsing = function(where) {
        sqlstring = 'select GroupID,groupname,UserID from QGROUPSNAGSUSER where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSNAGGROUPSDDL(){
    var UserID = null;
    var GroupID = null;
    var Groupname = null;
    var DrwgID = null;
 var selectNoBlob = 'UserID,GroupID,Groupname,DrwgID';
};
    QGROUPSNAGGROUPSDDL.prototype.getUserID = function() {
        return this.UserID;
    };
    QGROUPSNAGGROUPSDDL.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSNAGGROUPSDDL.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QGROUPSNAGGROUPSDDL.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QGROUPSNAGGROUPSDDL.prototype.toString = function() {
        var retVal = "";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        return retVal;
    };
var QGROUPSNAGGROUPSDDLDAO = function(){
};
QGROUPSNAGGROUPSDDLDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSNAGGROUPSDDL();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSNAGGROUPSDDL...");
        object.UserID = resultset.fieldByName('UserID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.DrwgID = resultset.fieldByName('DrwgID');
    };
QGROUPSNAGGROUPSDDLDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSNAGGROUPSDDLDAO.getUsing = function(where) {
        sqlstring = 'select UserID,GroupID,Groupname,DrwgID from QGROUPSNAGGROUPSDDL where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QMDRPDFS(){
    var DrwgID = null;
    var MDRcode = null;
    var Descrip = null;
    var PDFname = null;
    var MDRCateg = null;
 var selectNoBlob = 'DrwgID,MDRcode,Descrip,PDFname,MDRCateg';
};
    QMDRPDFS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QMDRPDFS.prototype.getMDRcode = function() {
        return this.MDRcode;
    };
    QMDRPDFS.prototype.getDescrip = function() {
        return this.Descrip;
    };
    QMDRPDFS.prototype.getPDFname = function() {
        return this.PDFname;
    };
    QMDRPDFS.prototype.getMDRCateg = function() {
        return this.MDRCateg;
    };
    QMDRPDFS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[MDRcode][" + this.MDRcode + "]";
        retVal += "[Descrip][" + this.Descrip + "]";
        retVal += "[PDFname][" + this.PDFname + "]";
        retVal += "[MDRCateg][" + this.MDRCateg + "]";
        return retVal;
    };
var QMDRPDFSDAO = function(){
};
QMDRPDFSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QMDRPDFS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QMDRPDFSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QMDRPDFS...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.MDRcode = resultset.fieldByName('MDRcode');
        object.Descrip = resultset.fieldByName('Descrip');
        object.PDFname = resultset.fieldByName('PDFname');
        object.MDRCateg = resultset.fieldByName('MDRCateg');
    };
QMDRPDFSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getUsingMDRcode = function(MDRcode) {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where MDRcode = ? ',MDRcode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getUsingDescrip = function(Descrip) {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where Descrip = ? ',Descrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getUsingPDFname = function(PDFname) {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where PDFname = ? ',PDFname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getUsingMDRCateg = function(MDRCateg) {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where MDRCateg = ? ',MDRCateg);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QMDRPDFSDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,MDRcode,Descrip,PDFname,MDRCateg from QMDRPDFS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDPLOTSTATS(){
    var SchedID = null;
    var Schedname = null;
    var DrwgID = null;
    var DrwgTitle = null;
    var PlotID = null;
    var ShortDescrip = null;
    var Status = null;
    var Passed = null;
    var Failed = null;
    var NotCheckd = null;
    var Total = null;
    var ClosedCnt = null;
    var OpenCnt = null;
    var TotCnt = null;
 var selectNoBlob = 'SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt';
};
    QSCHEDPLOTSTATS.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QSCHEDPLOTSTATS.prototype.getSchedname = function() {
        return this.Schedname;
    };
    QSCHEDPLOTSTATS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSCHEDPLOTSTATS.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QSCHEDPLOTSTATS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDPLOTSTATS.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSCHEDPLOTSTATS.prototype.getStatus = function() {
        return this.Status;
    };
    QSCHEDPLOTSTATS.prototype.getPassed = function() {
        return this.Passed;
    };
    QSCHEDPLOTSTATS.prototype.getFailed = function() {
        return this.Failed;
    };
    QSCHEDPLOTSTATS.prototype.getNotCheckd = function() {
        return this.NotCheckd;
    };
    QSCHEDPLOTSTATS.prototype.getTotal = function() {
        return this.Total;
    };
    QSCHEDPLOTSTATS.prototype.getClosedCnt = function() {
        return this.ClosedCnt;
    };
    QSCHEDPLOTSTATS.prototype.getOpenCnt = function() {
        return this.OpenCnt;
    };
    QSCHEDPLOTSTATS.prototype.getTotCnt = function() {
        return this.TotCnt;
    };
    QSCHEDPLOTSTATS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[Schedname][" + this.Schedname + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[Passed][" + this.Passed + "]";
        retVal += "[Failed][" + this.Failed + "]";
        retVal += "[NotCheckd][" + this.NotCheckd + "]";
        retVal += "[Total][" + this.Total + "]";
        retVal += "[ClosedCnt][" + this.ClosedCnt + "]";
        retVal += "[OpenCnt][" + this.OpenCnt + "]";
        retVal += "[TotCnt][" + this.TotCnt + "]";
        return retVal;
    };
var QSCHEDPLOTSTATSDAO = function(){
};
QSCHEDPLOTSTATSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDPLOTSTATS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDPLOTSTATS...");
        object.SchedID = resultset.fieldByName('SchedID');
        object.Schedname = resultset.fieldByName('Schedname');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.PlotID = resultset.fieldByName('PlotID');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Status = resultset.fieldByName('Status');
        object.Passed = resultset.fieldByName('Passed');
        object.Failed = resultset.fieldByName('Failed');
        object.NotCheckd = resultset.fieldByName('NotCheckd');
        object.Total = resultset.fieldByName('Total');
        object.ClosedCnt = resultset.fieldByName('ClosedCnt');
        object.OpenCnt = resultset.fieldByName('OpenCnt');
        object.TotCnt = resultset.fieldByName('TotCnt');
    };
QSCHEDPLOTSTATSDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingSchedname = function(Schedname) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where Schedname = ? ',Schedname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingPassed = function(Passed) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where Passed = ? ',Passed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingFailed = function(Failed) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where Failed = ? ',Failed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingNotCheckd = function(NotCheckd) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where NotCheckd = ? ',NotCheckd);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingTotal = function(Total) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where Total = ? ',Total);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingClosedCnt = function(ClosedCnt) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where ClosedCnt = ? ',ClosedCnt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingOpenCnt = function(OpenCnt) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where OpenCnt = ? ',OpenCnt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsingTotCnt = function(TotCnt) {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where TotCnt = ? ',TotCnt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTSTATSDAO.getUsing = function(where) {
        sqlstring = 'select SchedID,Schedname,DrwgID,DrwgTitle,PlotID,ShortDescrip,Status,Passed,Failed,NotCheckd,Total,ClosedCnt,OpenCnt,TotCnt from QSCHEDPLOTSTATS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSELSDTYPES(){
    var SDCode = null;
    var Description = null;
 var selectNoBlob = 'SDCode,Description';
};
    QSELSDTYPES.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QSELSDTYPES.prototype.getDescription = function() {
        return this.Description;
    };
    QSELSDTYPES.prototype.toString = function() {
        var retVal = "";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[Description][" + this.Description + "]";
        return retVal;
    };
var QSELSDTYPESDAO = function(){
};
QSELSDTYPESDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSELSDTYPES();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSELSDTYPESDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSELSDTYPES...");
        object.SDCode = resultset.fieldByName('SDCode');
        object.Description = resultset.fieldByName('Description');
    };
QSELSDTYPESDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select SDCode,Description from QSELSDTYPES where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELSDTYPESDAO.getUsingDescription = function(Description) {
        var resultset =  db.getConnection().execute('select SDCode,Description from QSELSDTYPES where Description = ? ',Description);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELSDTYPESDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SDCode,Description from QSELSDTYPES');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSELSDTYPESDAO.getUsing = function(where) {
        sqlstring = 'select SDCode,Description from QSELSDTYPES where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSTDDEFECTS(){
    var SDCode = null;
    var Description = null;
    var Defect = null;
 var selectNoBlob = 'SDCode,Description,Defect';
};
    QSTDDEFECTS.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QSTDDEFECTS.prototype.getDescription = function() {
        return this.Description;
    };
    QSTDDEFECTS.prototype.getDefect = function() {
        return this.Defect;
    };
    QSTDDEFECTS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[Description][" + this.Description + "]";
        retVal += "[Defect][" + this.Defect + "]";
        return retVal;
    };
var QSTDDEFECTSDAO = function(){
};
QSTDDEFECTSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSTDDEFECTS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSTDDEFECTSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSTDDEFECTS...");
        object.SDCode = resultset.fieldByName('SDCode');
        object.Description = resultset.fieldByName('Description');
        object.Defect = resultset.fieldByName('Defect');
    };
QSTDDEFECTSDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select SDCode,Description,Defect from QSTDDEFECTS where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSTDDEFECTSDAO.getUsingDescription = function(Description) {
        var resultset =  db.getConnection().execute('select SDCode,Description,Defect from QSTDDEFECTS where Description = ? ',Description);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSTDDEFECTSDAO.getUsingDefect = function(Defect) {
        var resultset =  db.getConnection().execute('select SDCode,Description,Defect from QSTDDEFECTS where Defect = ? ',Defect);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSTDDEFECTSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SDCode,Description,Defect from QSTDDEFECTS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSTDDEFECTSDAO.getUsing = function(where) {
        sqlstring = 'select SDCode,Description,Defect from QSTDDEFECTS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERS(){
    var UserID = null;
    var Username = null;
    var Password = null;
    var Fullname = null;
    var EmergencyEmail = null;
    var Current = null;
    var Role = null;
    var Email = null;
    var LastLogin = null;
    var Culture = null;
 var selectNoBlob = 'UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture';
};
    QUSERS.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERS.prototype.getUsername = function() {
        return this.Username;
    };
    QUSERS.prototype.getPassword = function() {
        return this.Password;
    };
    QUSERS.prototype.getFullname = function() {
        return this.Fullname;
    };
    QUSERS.prototype.getEmergencyEmail = function() {
        return this.EmergencyEmail;
    };
    QUSERS.prototype.getCurrent = function() {
        return this.Current;
    };
    QUSERS.prototype.getRole = function() {
        return this.Role;
    };
    QUSERS.prototype.getEmail = function() {
        return this.Email;
    };
    QUSERS.prototype.getLastLogin = function() {
        return this.LastLogin;
    };
    QUSERS.prototype.getCulture = function() {
        return this.Culture;
    };
    QUSERS.prototype.toString = function() {
        var retVal = "";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[Username][" + this.Username + "]";
        retVal += "[Password][" + this.Password + "]";
        retVal += "[Fullname][" + this.Fullname + "]";
        retVal += "[EmergencyEmail][" + this.EmergencyEmail + "]";
        retVal += "[Current][" + this.Current + "]";
        retVal += "[Role][" + this.Role + "]";
        retVal += "[Email][" + this.Email + "]";
        retVal += "[LastLogin][" + this.LastLogin + "]";
        retVal += "[Culture][" + this.Culture + "]";
        return retVal;
    };
var QUSERSDAO = function(){
};
QUSERSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERS...");
        object.UserID = resultset.fieldByName('UserID');
        object.Username = resultset.fieldByName('Username');
        object.Password = resultset.fieldByName('Password');
        object.Fullname = resultset.fieldByName('Fullname');
        object.EmergencyEmail = resultset.fieldByName('EmergencyEmail');
        object.Current = resultset.fieldByName('Current');
        object.Role = resultset.fieldByName('Role');
        object.Email = resultset.fieldByName('Email');
        object.LastLogin = resultset.fieldByName('LastLogin');
        object.Culture = resultset.fieldByName('Culture');
    };
QUSERSDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingUsername = function(Username) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Username = ? ',Username);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingPassword = function(Password) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Password = ? ',Password);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingFullname = function(Fullname) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Fullname = ? ',Fullname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingEmergencyEmail = function(EmergencyEmail) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where EmergencyEmail = ? ',EmergencyEmail);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingCurrent = function(Current) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Current = ? ',Current);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingRole = function(Role) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Role = ? ',Role);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingEmail = function(Email) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Email = ? ',Email);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingLastLogin = function(LastLogin) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where LastLogin = ? ',LastLogin);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsingCulture = function(Culture) {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where Culture = ? ',Culture);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDAO.getUsing = function(where) {
        sqlstring = 'select UserID,Username,Password,Fullname,EmergencyEmail,Current,Role,Email,LastLogin,Culture from QUSERS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSDTYPES(){
    var SDCode = null;
    var Description = null;
    var UserID = null;
    var CanUse = null;
 var selectNoBlob = 'SDCode,Description,UserID,CanUse';
};
    QUSERSDTYPES.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QUSERSDTYPES.prototype.getDescription = function() {
        return this.Description;
    };
    QUSERSDTYPES.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSDTYPES.prototype.getCanUse = function() {
        return this.CanUse;
    };
    QUSERSDTYPES.prototype.toString = function() {
        var retVal = "";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[Description][" + this.Description + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[CanUse][" + this.CanUse + "]";
        return retVal;
    };
var QUSERSDTYPESDAO = function(){
};
QUSERSDTYPESDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSDTYPES();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSDTYPESDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSDTYPES...");
        object.SDCode = resultset.fieldByName('SDCode');
        object.Description = resultset.fieldByName('Description');
        object.UserID = resultset.fieldByName('UserID');
        object.CanUse = resultset.fieldByName('CanUse');
    };
QUSERSDTYPESDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select SDCode,Description,UserID,CanUse from QUSERSDTYPES where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDTYPESDAO.getUsingDescription = function(Description) {
        var resultset =  db.getConnection().execute('select SDCode,Description,UserID,CanUse from QUSERSDTYPES where Description = ? ',Description);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDTYPESDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select SDCode,Description,UserID,CanUse from QUSERSDTYPES where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDTYPESDAO.getUsingCanUse = function(CanUse) {
        var resultset =  db.getConnection().execute('select SDCode,Description,UserID,CanUse from QUSERSDTYPES where CanUse = ? ',CanUse);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDTYPESDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SDCode,Description,UserID,CanUse from QUSERSDTYPES');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSDTYPESDAO.getUsing = function(where) {
        sqlstring = 'select SDCode,Description,UserID,CanUse from QUSERSDTYPES where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QROOMS(){
    var DrwgID = null;
    var Room = null;
 var selectNoBlob = 'DrwgID,Room';
};
    QROOMS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QROOMS.prototype.getRoom = function() {
        return this.Room;
    };
    QROOMS.prototype.toString = function() {
        var retVal = "";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Room][" + this.Room + "]";
        return retVal;
    };
var QROOMSDAO = function(){
};
QROOMSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QROOMS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QROOMSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QROOMS...");
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Room = resultset.fieldByName('Room');
    };
QROOMSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select DrwgID,Room from QROOMS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QROOMSDAO.getUsingRoom = function(Room) {
        var resultset =  db.getConnection().execute('select DrwgID,Room from QROOMS where Room = ? ',Room);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QROOMSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select DrwgID,Room from QROOMS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QROOMSDAO.getUsing = function(where) {
        sqlstring = 'select DrwgID,Room from QROOMS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERINSPECTIONS(){
    var UIID = null;
    var UserID = null;
    var Username = null;
    var SchedID = null;
    var Schedname = null;
    var SchedInits = null;
    var CanUse = null;
 var selectNoBlob = 'UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse';
};
    QUSERINSPECTIONS.prototype.getUIID = function() {
        return this.UIID;
    };
    QUSERINSPECTIONS.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERINSPECTIONS.prototype.getUsername = function() {
        return this.Username;
    };
    QUSERINSPECTIONS.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QUSERINSPECTIONS.prototype.getSchedname = function() {
        return this.Schedname;
    };
    QUSERINSPECTIONS.prototype.getSchedInits = function() {
        return this.SchedInits;
    };
    QUSERINSPECTIONS.prototype.getCanUse = function() {
        return this.CanUse;
    };
    QUSERINSPECTIONS.prototype.toString = function() {
        var retVal = "";
        retVal += "[UIID][" + this.UIID + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[Username][" + this.Username + "]";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[Schedname][" + this.Schedname + "]";
        retVal += "[SchedInits][" + this.SchedInits + "]";
        retVal += "[CanUse][" + this.CanUse + "]";
        return retVal;
    };
var QUSERINSPECTIONSDAO = function(){
};
QUSERINSPECTIONSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERINSPECTIONS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERINSPECTIONSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERINSPECTIONS...");
        object.UIID = resultset.fieldByName('UIID');
        object.UserID = resultset.fieldByName('UserID');
        object.Username = resultset.fieldByName('Username');
        object.SchedID = resultset.fieldByName('SchedID');
        object.Schedname = resultset.fieldByName('Schedname');
        object.SchedInits = resultset.fieldByName('SchedInits');
        object.CanUse = resultset.fieldByName('CanUse');
    };
QUSERINSPECTIONSDAO.getUsingUIID = function(UIID) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where UIID = ? ',UIID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingUsername = function(Username) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where Username = ? ',Username);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingSchedname = function(Schedname) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where Schedname = ? ',Schedname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingSchedInits = function(SchedInits) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where SchedInits = ? ',SchedInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsingCanUse = function(CanUse) {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where CanUse = ? ',CanUse);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERINSPECTIONSDAO.getUsing = function(where) {
        sqlstring = 'select UIID,UserID,Username,SchedID,Schedname,SchedInits,CanUse from QUSERINSPECTIONS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QLASTCHANGE(){
    var SnagID = null;
    var LastChanged = null;
    var MaxOfSUID = null;
 var selectNoBlob = 'SnagID,LastChanged,MaxOfSUID';
};
    QLASTCHANGE.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QLASTCHANGE.prototype.getLastChanged = function() {
        return this.LastChanged;
    };
    QLASTCHANGE.prototype.getMaxOfSUID = function() {
        return this.MaxOfSUID;
    };
    QLASTCHANGE.prototype.toString = function() {
        var retVal = "";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[LastChanged][" + this.LastChanged + "]";
        retVal += "[MaxOfSUID][" + this.MaxOfSUID + "]";
        return retVal;
    };
var QLASTCHANGEDAO = function(){
};
QLASTCHANGEDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QLASTCHANGE();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QLASTCHANGEDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QLASTCHANGE...");
        object.SnagID = resultset.fieldByName('SnagID');
        object.LastChanged = resultset.fieldByName('LastChanged');
        object.MaxOfSUID = resultset.fieldByName('MaxOfSUID');
    };
QLASTCHANGEDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,MaxOfSUID from QLASTCHANGE where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDAO.getUsingLastChanged = function(LastChanged) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,MaxOfSUID from QLASTCHANGE where LastChanged = ? ',LastChanged);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDAO.getUsingMaxOfSUID = function(MaxOfSUID) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,MaxOfSUID from QLASTCHANGE where MaxOfSUID = ? ',MaxOfSUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,MaxOfSUID from QLASTCHANGE');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDAO.getUsing = function(where) {
        sqlstring = 'select SnagID,LastChanged,MaxOfSUID from QLASTCHANGE where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QLASTCHANGEDALL(){
    var SnagID = null;
    var LastChanged = null;
    var Status = null;
    var FixDescrip = null;
    var UserID = null;
    var Username = null;
    var Fullname = null;
    var DaysOld = null;
 var selectNoBlob = 'SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld';
};
    QLASTCHANGEDALL.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QLASTCHANGEDALL.prototype.getLastChanged = function() {
        return this.LastChanged;
    };
    QLASTCHANGEDALL.prototype.getStatus = function() {
        return this.Status;
    };
    QLASTCHANGEDALL.prototype.getFixDescrip = function() {
        return this.FixDescrip;
    };
    QLASTCHANGEDALL.prototype.getUserID = function() {
        return this.UserID;
    };
    QLASTCHANGEDALL.prototype.getUsername = function() {
        return this.Username;
    };
    QLASTCHANGEDALL.prototype.getFullname = function() {
        return this.Fullname;
    };
    QLASTCHANGEDALL.prototype.getDaysOld = function() {
        return this.DaysOld;
    };
    QLASTCHANGEDALL.prototype.toString = function() {
        var retVal = "";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[LastChanged][" + this.LastChanged + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[FixDescrip][" + this.FixDescrip + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[Username][" + this.Username + "]";
        retVal += "[Fullname][" + this.Fullname + "]";
        retVal += "[DaysOld][" + this.DaysOld + "]";
        return retVal;
    };
var QLASTCHANGEDALLDAO = function(){
};
QLASTCHANGEDALLDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QLASTCHANGEDALL();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QLASTCHANGEDALLDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QLASTCHANGEDALL...");
        object.SnagID = resultset.fieldByName('SnagID');
        object.LastChanged = resultset.fieldByName('LastChanged');
        object.Status = resultset.fieldByName('Status');
        object.FixDescrip = resultset.fieldByName('FixDescrip');
        object.UserID = resultset.fieldByName('UserID');
        object.Username = resultset.fieldByName('Username');
        object.Fullname = resultset.fieldByName('Fullname');
        object.DaysOld = resultset.fieldByName('DaysOld');
    };
QLASTCHANGEDALLDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingLastChanged = function(LastChanged) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where LastChanged = ? ',LastChanged);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingFixDescrip = function(FixDescrip) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where FixDescrip = ? ',FixDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingUsername = function(Username) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where Username = ? ',Username);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingFullname = function(Fullname) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where Fullname = ? ',Fullname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsingDaysOld = function(DaysOld) {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where DaysOld = ? ',DaysOld);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QLASTCHANGEDALLDAO.getUsing = function(where) {
        sqlstring = 'select SnagID,LastChanged,Status,FixDescrip,UserID,Username,Fullname,DaysOld from QLASTCHANGEDALL where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSNAGS(){
    var SnagID = null;
    var DrwgID = null;
    var Status = null;
    var ShortDescrip = null;
    var Location = null;
    var Xcoord = null;
    var YCoord = null;
    var Priority = null;
    var Datestamp = null;
    var DrwgLink = null;
    var Photo = null;
    var DoBy = null;
    var PPCGUID = null;
    var GroupID = null;
    var GroupInits = null;
    var DateClosed = null;
    var BigPhoto = null;
    var SCID = null;
    var Lat = null;
    var Lng = null;
    var Owner = null;
    var SDCode = null;
    var SDID = null;
    var PlotID = null;
    var TradeCode = null;
    var MPGUID = null;
    var FixStatus = null;
 var selectNoBlob = 'SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus';
};
    QSNAGS.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QSNAGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSNAGS.prototype.getStatus = function() {
        return this.Status;
    };
    QSNAGS.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSNAGS.prototype.getLocation = function() {
        return this.Location;
    };
    QSNAGS.prototype.getXcoord = function() {
        return this.Xcoord;
    };
    QSNAGS.prototype.getYCoord = function() {
        return this.YCoord;
    };
    QSNAGS.prototype.getPriority = function() {
        return this.Priority;
    };
    QSNAGS.prototype.getDatestamp = function() {
        return this.Datestamp;
    };
    QSNAGS.prototype.getDrwgLink = function() {
        return this.DrwgLink;
    };
    QSNAGS.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QSNAGS where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QSNAGS.prototype.getDoBy = function() {
        return this.DoBy;
    };
    QSNAGS.prototype.getPPCGUID = function() {
        return this.PPCGUID;
    };
    QSNAGS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QSNAGS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QSNAGS.prototype.getDateClosed = function() {
        return this.DateClosed;
    };
    QSNAGS.prototype.getBigPhoto = function() {
         if (this.BigPhoto == null) {
            result = db.getConnection().execute('select BigPhoto from QSNAGS where ');
            this.BigPhoto = result.field(0);
         }
        return this.BigPhoto;
    };
    QSNAGS.prototype.getSCID = function() {
        return this.SCID;
    };
    QSNAGS.prototype.getLat = function() {
        return this.Lat;
    };
    QSNAGS.prototype.getLng = function() {
        return this.Lng;
    };
    QSNAGS.prototype.getOwner = function() {
        return this.Owner;
    };
    QSNAGS.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QSNAGS.prototype.getSDID = function() {
        return this.SDID;
    };
    QSNAGS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSNAGS.prototype.getTradeCode = function() {
        return this.TradeCode;
    };
    QSNAGS.prototype.getMPGUID = function() {
        return this.MPGUID;
    };
    QSNAGS.prototype.getFixStatus = function() {
        return this.FixStatus;
    };
    QSNAGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[Xcoord][" + this.Xcoord + "]";
        retVal += "[YCoord][" + this.YCoord + "]";
        retVal += "[Priority][" + this.Priority + "]";
        retVal += "[Datestamp][" + this.Datestamp + "]";
        retVal += "[DrwgLink][" + this.DrwgLink + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[DoBy][" + this.DoBy + "]";
        retVal += "[PPCGUID][" + this.PPCGUID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[DateClosed][" + this.DateClosed + "]";
        retVal += "[BigPhoto][" + this.BigPhoto + "]";
        retVal += "[SCID][" + this.SCID + "]";
        retVal += "[Lat][" + this.Lat + "]";
        retVal += "[Lng][" + this.Lng + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[SDID][" + this.SDID + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[TradeCode][" + this.TradeCode + "]";
        retVal += "[MPGUID][" + this.MPGUID + "]";
        retVal += "[FixStatus][" + this.FixStatus + "]";
        return retVal;
    };
var QSNAGSDAO = function(){
};
QSNAGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSNAGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSNAGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSNAGS...");
        object.SnagID = resultset.fieldByName('SnagID');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Status = resultset.fieldByName('Status');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.Xcoord = resultset.fieldByName('Xcoord');
        object.YCoord = resultset.fieldByName('YCoord');
        object.Priority = resultset.fieldByName('Priority');
        object.Datestamp = resultset.fieldByName('Datestamp');
        object.DrwgLink = resultset.fieldByName('DrwgLink');
        object.DoBy = resultset.fieldByName('DoBy');
        object.PPCGUID = resultset.fieldByName('PPCGUID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.DateClosed = resultset.fieldByName('DateClosed');
        object.SCID = resultset.fieldByName('SCID');
        object.Lat = resultset.fieldByName('Lat');
        object.Lng = resultset.fieldByName('Lng');
        object.Owner = resultset.fieldByName('Owner');
        object.SDCode = resultset.fieldByName('SDCode');
        object.SDID = resultset.fieldByName('SDID');
        object.PlotID = resultset.fieldByName('PlotID');
        object.TradeCode = resultset.fieldByName('TradeCode');
        object.MPGUID = resultset.fieldByName('MPGUID');
        object.FixStatus = resultset.fieldByName('FixStatus');
    };
QSNAGSDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingXcoord = function(Xcoord) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Xcoord = ? ',Xcoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingYCoord = function(YCoord) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where YCoord = ? ',YCoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingPriority = function(Priority) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Priority = ? ',Priority);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingDatestamp = function(Datestamp) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Datestamp = ? ',Datestamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingDrwgLink = function(DrwgLink) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where DrwgLink = ? ',DrwgLink);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingDoBy = function(DoBy) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where DoBy = ? ',DoBy);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingPPCGUID = function(PPCGUID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where PPCGUID = ? ',PPCGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingDateClosed = function(DateClosed) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where DateClosed = ? ',DateClosed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingBigPhoto = function(BigPhoto) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where BigPhoto = ? ',BigPhoto);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingSCID = function(SCID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where SCID = ? ',SCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingLat = function(Lat) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Lat = ? ',Lat);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingLng = function(Lng) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Lng = ? ',Lng);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingSDID = function(SDID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where SDID = ? ',SDID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingTradeCode = function(TradeCode) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where TradeCode = ? ',TradeCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingMPGUID = function(MPGUID) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where MPGUID = ? ',MPGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsingFixStatus = function(FixStatus) {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where FixStatus = ? ',FixStatus);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSDAO.getUsing = function(where) {
        sqlstring = 'select SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSNAGSUG(){
    var Role = null;
    var UserID = null;
    var SnagID = null;
    var DrwgID = null;
    var Status = null;
    var ShortDescrip = null;
    var Location = null;
    var Xcoord = null;
    var YCoord = null;
    var Priority = null;
    var Datestamp = null;
    var DrwgLink = null;
    var Photo = null;
    var DoBy = null;
    var PPCGUID = null;
    var GroupID = null;
    var GroupInits = null;
    var DateClosed = null;
    var BigPhoto = null;
    var SCID = null;
    var Lat = null;
    var Lng = null;
    var Owner = null;
    var SDCode = null;
    var SDID = null;
    var PlotID = null;
    var TradeCode = null;
    var MPGUID = null;
    var FixStatus = null;
 var selectNoBlob = 'Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus';
};
    QSNAGSUG.prototype.getRole = function() {
        return this.Role;
    };
    QSNAGSUG.prototype.getUserID = function() {
        return this.UserID;
    };
    QSNAGSUG.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QSNAGSUG.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSNAGSUG.prototype.getStatus = function() {
        return this.Status;
    };
    QSNAGSUG.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSNAGSUG.prototype.getLocation = function() {
        return this.Location;
    };
    QSNAGSUG.prototype.getXcoord = function() {
        return this.Xcoord;
    };
    QSNAGSUG.prototype.getYCoord = function() {
        return this.YCoord;
    };
    QSNAGSUG.prototype.getPriority = function() {
        return this.Priority;
    };
    QSNAGSUG.prototype.getDatestamp = function() {
        return this.Datestamp;
    };
    QSNAGSUG.prototype.getDrwgLink = function() {
        return this.DrwgLink;
    };
    QSNAGSUG.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QSNAGSUG where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QSNAGSUG.prototype.getDoBy = function() {
        return this.DoBy;
    };
    QSNAGSUG.prototype.getPPCGUID = function() {
        return this.PPCGUID;
    };
    QSNAGSUG.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QSNAGSUG.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QSNAGSUG.prototype.getDateClosed = function() {
        return this.DateClosed;
    };
    QSNAGSUG.prototype.getBigPhoto = function() {
         if (this.BigPhoto == null) {
            result = db.getConnection().execute('select BigPhoto from QSNAGSUG where ');
            this.BigPhoto = result.field(0);
         }
        return this.BigPhoto;
    };
    QSNAGSUG.prototype.getSCID = function() {
        return this.SCID;
    };
    QSNAGSUG.prototype.getLat = function() {
        return this.Lat;
    };
    QSNAGSUG.prototype.getLng = function() {
        return this.Lng;
    };
    QSNAGSUG.prototype.getOwner = function() {
        return this.Owner;
    };
    QSNAGSUG.prototype.getSDCode = function() {
        return this.SDCode;
    };
    QSNAGSUG.prototype.getSDID = function() {
        return this.SDID;
    };
    QSNAGSUG.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSNAGSUG.prototype.getTradeCode = function() {
        return this.TradeCode;
    };
    QSNAGSUG.prototype.getMPGUID = function() {
        return this.MPGUID;
    };
    QSNAGSUG.prototype.getFixStatus = function() {
        return this.FixStatus;
    };
    QSNAGSUG.prototype.toString = function() {
        var retVal = "";
        retVal += "[Role][" + this.Role + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[Xcoord][" + this.Xcoord + "]";
        retVal += "[YCoord][" + this.YCoord + "]";
        retVal += "[Priority][" + this.Priority + "]";
        retVal += "[Datestamp][" + this.Datestamp + "]";
        retVal += "[DrwgLink][" + this.DrwgLink + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[DoBy][" + this.DoBy + "]";
        retVal += "[PPCGUID][" + this.PPCGUID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[DateClosed][" + this.DateClosed + "]";
        retVal += "[BigPhoto][" + this.BigPhoto + "]";
        retVal += "[SCID][" + this.SCID + "]";
        retVal += "[Lat][" + this.Lat + "]";
        retVal += "[Lng][" + this.Lng + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[SDCode][" + this.SDCode + "]";
        retVal += "[SDID][" + this.SDID + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[TradeCode][" + this.TradeCode + "]";
        retVal += "[MPGUID][" + this.MPGUID + "]";
        retVal += "[FixStatus][" + this.FixStatus + "]";
        return retVal;
    };
var QSNAGSUGDAO = function(){
};
QSNAGSUGDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSNAGSUG();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSNAGSUGDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSNAGSUG...");
        object.Role = resultset.fieldByName('Role');
        object.UserID = resultset.fieldByName('UserID');
        object.SnagID = resultset.fieldByName('SnagID');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Status = resultset.fieldByName('Status');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.Xcoord = resultset.fieldByName('Xcoord');
        object.YCoord = resultset.fieldByName('YCoord');
        object.Priority = resultset.fieldByName('Priority');
        object.Datestamp = resultset.fieldByName('Datestamp');
        object.DrwgLink = resultset.fieldByName('DrwgLink');
        object.DoBy = resultset.fieldByName('DoBy');
        object.PPCGUID = resultset.fieldByName('PPCGUID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.DateClosed = resultset.fieldByName('DateClosed');
        object.SCID = resultset.fieldByName('SCID');
        object.Lat = resultset.fieldByName('Lat');
        object.Lng = resultset.fieldByName('Lng');
        object.Owner = resultset.fieldByName('Owner');
        object.SDCode = resultset.fieldByName('SDCode');
        object.SDID = resultset.fieldByName('SDID');
        object.PlotID = resultset.fieldByName('PlotID');
        object.TradeCode = resultset.fieldByName('TradeCode');
        object.MPGUID = resultset.fieldByName('MPGUID');
        object.FixStatus = resultset.fieldByName('FixStatus');
    };
QSNAGSUGDAO.getUsingRole = function(Role) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Role = ? ',Role);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingXcoord = function(Xcoord) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Xcoord = ? ',Xcoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingYCoord = function(YCoord) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where YCoord = ? ',YCoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingPriority = function(Priority) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Priority = ? ',Priority);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingDatestamp = function(Datestamp) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Datestamp = ? ',Datestamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingDrwgLink = function(DrwgLink) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where DrwgLink = ? ',DrwgLink);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingDoBy = function(DoBy) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where DoBy = ? ',DoBy);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingPPCGUID = function(PPCGUID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where PPCGUID = ? ',PPCGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingDateClosed = function(DateClosed) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where DateClosed = ? ',DateClosed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingBigPhoto = function(BigPhoto) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where BigPhoto = ? ',BigPhoto);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingSCID = function(SCID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where SCID = ? ',SCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingLat = function(Lat) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Lat = ? ',Lat);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingLng = function(Lng) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Lng = ? ',Lng);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingSDCode = function(SDCode) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where SDCode = ? ',SDCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingSDID = function(SDID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where SDID = ? ',SDID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingTradeCode = function(TradeCode) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where TradeCode = ? ',TradeCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingMPGUID = function(MPGUID) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where MPGUID = ? ',MPGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsingFixStatus = function(FixStatus) {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where FixStatus = ? ',FixStatus);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getall = function() {
        var resultset =  db.getConnection().execute('select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGSUGDAO.getUsing = function(where) {
        sqlstring = 'select Role,UserID,SnagID,DrwgID,Status,ShortDescrip,Location,Xcoord,YCoord,Priority,Datestamp,DrwgLink,DoBy,PPCGUID,GroupID,GroupInits,DateClosed,SCID,Lat,Lng,Owner,SDCode,SDID,PlotID,TradeCode,MPGUID,FixStatus from QSNAGSUG where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QUSERSNAGS(){
    var UserID = null;
    var GroupID = null;
    var SnagID = null;
    var DrwgID = null;
    var Owner = null;
    var DrwgTitle = null;
    var Groupname = null;
 var selectNoBlob = 'UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname';
};
    QUSERSNAGS.prototype.getUserID = function() {
        return this.UserID;
    };
    QUSERSNAGS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QUSERSNAGS.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QUSERSNAGS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QUSERSNAGS.prototype.getOwner = function() {
        return this.Owner;
    };
    QUSERSNAGS.prototype.getDrwgTitle = function() {
        return this.DrwgTitle;
    };
    QUSERSNAGS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QUSERSNAGS.prototype.toString = function() {
        var retVal = "";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[DrwgTitle][" + this.DrwgTitle + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        return retVal;
    };
var QUSERSNAGSDAO = function(){
};
QUSERSNAGSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QUSERSNAGS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QUSERSNAGSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QUSERSNAGS...");
        object.UserID = resultset.fieldByName('UserID');
        object.GroupID = resultset.fieldByName('GroupID');
        object.SnagID = resultset.fieldByName('SnagID');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Owner = resultset.fieldByName('Owner');
        object.DrwgTitle = resultset.fieldByName('DrwgTitle');
        object.Groupname = resultset.fieldByName('Groupname');
    };
QUSERSNAGSDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingDrwgTitle = function(DrwgTitle) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where DrwgTitle = ? ',DrwgTitle);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QUSERSNAGSDAO.getUsing = function(where) {
        sqlstring = 'select UserID,GroupID,SnagID,DrwgID,Owner,DrwgTitle,Groupname from QUSERSNAGS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QGROUPSBYTRADE(){
    var TradeCode = null;
    var TradeDescrip = null;
    var GroupID = null;
    var Groupname = null;
    var GroupInits = null;
    var Email = null;
    var Email2 = null;
    var Email3 = null;
    var CanBeEmailed = null;
    var Current = null;
    var Culture = null;
 var selectNoBlob = 'TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture';
};
    QGROUPSBYTRADE.prototype.getTradeCode = function() {
        return this.TradeCode;
    };
    QGROUPSBYTRADE.prototype.getTradeDescrip = function() {
        return this.TradeDescrip;
    };
    QGROUPSBYTRADE.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QGROUPSBYTRADE.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QGROUPSBYTRADE.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QGROUPSBYTRADE.prototype.getEmail = function() {
        return this.Email;
    };
    QGROUPSBYTRADE.prototype.getEmail2 = function() {
        return this.Email2;
    };
    QGROUPSBYTRADE.prototype.getEmail3 = function() {
        return this.Email3;
    };
    QGROUPSBYTRADE.prototype.getCanBeEmailed = function() {
        return this.CanBeEmailed;
    };
    QGROUPSBYTRADE.prototype.getCurrent = function() {
        return this.Current;
    };
    QGROUPSBYTRADE.prototype.getCulture = function() {
        return this.Culture;
    };
    QGROUPSBYTRADE.prototype.toString = function() {
        var retVal = "";
        retVal += "[TradeCode][" + this.TradeCode + "]";
        retVal += "[TradeDescrip][" + this.TradeDescrip + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[Email][" + this.Email + "]";
        retVal += "[Email2][" + this.Email2 + "]";
        retVal += "[Email3][" + this.Email3 + "]";
        retVal += "[CanBeEmailed][" + this.CanBeEmailed + "]";
        retVal += "[Current][" + this.Current + "]";
        retVal += "[Culture][" + this.Culture + "]";
        return retVal;
    };
var QGROUPSBYTRADEDAO = function(){
};
QGROUPSBYTRADEDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QGROUPSBYTRADE();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QGROUPSBYTRADEDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QGROUPSBYTRADE...");
        object.TradeCode = resultset.fieldByName('TradeCode');
        object.TradeDescrip = resultset.fieldByName('TradeDescrip');
        object.GroupID = resultset.fieldByName('GroupID');
        object.Groupname = resultset.fieldByName('Groupname');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.Email = resultset.fieldByName('Email');
        object.Email2 = resultset.fieldByName('Email2');
        object.Email3 = resultset.fieldByName('Email3');
        object.CanBeEmailed = resultset.fieldByName('CanBeEmailed');
        object.Current = resultset.fieldByName('Current');
        object.Culture = resultset.fieldByName('Culture');
    };
QGROUPSBYTRADEDAO.getUsingTradeCode = function(TradeCode) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where TradeCode = ? ',TradeCode);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingTradeDescrip = function(TradeDescrip) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where TradeDescrip = ? ',TradeDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingEmail = function(Email) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Email = ? ',Email);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingEmail2 = function(Email2) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Email2 = ? ',Email2);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingEmail3 = function(Email3) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Email3 = ? ',Email3);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingCanBeEmailed = function(CanBeEmailed) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where CanBeEmailed = ? ',CanBeEmailed);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingCurrent = function(Current) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Current = ? ',Current);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsingCulture = function(Culture) {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where Culture = ? ',Culture);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getall = function() {
        var resultset =  db.getConnection().execute('select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QGROUPSBYTRADEDAO.getUsing = function(where) {
        sqlstring = 'select TradeCode,TradeDescrip,GroupID,Groupname,GroupInits,Email,Email2,Email3,CanBeEmailed,Current,Culture from QGROUPSBYTRADE where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSNAGDETAILS(){
    var SDDescription = null;
    var SDDefect = null;
    var Priority = null;
    var SnagID = null;
    var ShortDescrip = null;
    var Location = null;
    var DoBy = null;
    var Photo = null;
    var GroupID = null;
    var GroupInits = null;
    var Groupname = null;
 var selectNoBlob = 'SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname';
};
    QSNAGDETAILS.prototype.getSDDescription = function() {
        return this.SDDescription;
    };
    QSNAGDETAILS.prototype.getSDDefect = function() {
        return this.SDDefect;
    };
    QSNAGDETAILS.prototype.getPriority = function() {
        return this.Priority;
    };
    QSNAGDETAILS.prototype.getSnagID = function() {
        return this.SnagID;
    };
    QSNAGDETAILS.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSNAGDETAILS.prototype.getLocation = function() {
        return this.Location;
    };
    QSNAGDETAILS.prototype.getDoBy = function() {
        return this.DoBy;
    };
    QSNAGDETAILS.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QSNAGDETAILS where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QSNAGDETAILS.prototype.getGroupID = function() {
        return this.GroupID;
    };
    QSNAGDETAILS.prototype.getGroupInits = function() {
        return this.GroupInits;
    };
    QSNAGDETAILS.prototype.getGroupname = function() {
        return this.Groupname;
    };
    QSNAGDETAILS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SDDescription][" + this.SDDescription + "]";
        retVal += "[SDDefect][" + this.SDDefect + "]";
        retVal += "[Priority][" + this.Priority + "]";
        retVal += "[SnagID][" + this.SnagID + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[DoBy][" + this.DoBy + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[GroupID][" + this.GroupID + "]";
        retVal += "[GroupInits][" + this.GroupInits + "]";
        retVal += "[Groupname][" + this.Groupname + "]";
        return retVal;
    };
var QSNAGDETAILSDAO = function(){
};
QSNAGDETAILSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSNAGDETAILS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSNAGDETAILSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSNAGDETAILS...");
        object.SDDescription = resultset.fieldByName('SDDescription');
        object.SDDefect = resultset.fieldByName('SDDefect');
        object.Priority = resultset.fieldByName('Priority');
        object.SnagID = resultset.fieldByName('SnagID');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.DoBy = resultset.fieldByName('DoBy');
        object.GroupID = resultset.fieldByName('GroupID');
        object.GroupInits = resultset.fieldByName('GroupInits');
        object.Groupname = resultset.fieldByName('Groupname');
    };
QSNAGDETAILSDAO.getUsingSDDescription = function(SDDescription) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where SDDescription = ? ',SDDescription);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingSDDefect = function(SDDefect) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where SDDefect = ? ',SDDefect);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingPriority = function(Priority) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where Priority = ? ',Priority);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingSnagID = function(SnagID) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where SnagID = ? ',SnagID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingDoBy = function(DoBy) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where DoBy = ? ',DoBy);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingGroupID = function(GroupID) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where GroupID = ? ',GroupID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingGroupInits = function(GroupInits) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where GroupInits = ? ',GroupInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsingGroupname = function(Groupname) {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where Groupname = ? ',Groupname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSNAGDETAILSDAO.getUsing = function(where) {
        sqlstring = 'select SDDescription,SDDefect,Priority,SnagID,ShortDescrip,Location,DoBy,GroupID,GroupInits,Groupname from QSNAGDETAILS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDPLOTDETAILS(){
    var PlotID = null;
    var SchedID = null;
    var SchedInits = null;
    var DrwgID = null;
    var Xcoord = null;
    var Ycoord = null;
    var Status = null;
    var ShortDescrip = null;
    var Location = null;
    var Datestamp = null;
    var Photo = null;
    var SetRefs = null;
    var StartDate = null;
    var PPCGuid = null;
    var Lat = null;
    var Lng = null;
    var Owner = null;
    var RecurDue = null;
    var MPGUID = null;
    var ExtRef = null;
    var Schedname = null;
 var selectNoBlob = 'PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname';
};
    QSCHEDPLOTDETAILS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDPLOTDETAILS.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QSCHEDPLOTDETAILS.prototype.getSchedInits = function() {
        return this.SchedInits;
    };
    QSCHEDPLOTDETAILS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSCHEDPLOTDETAILS.prototype.getXcoord = function() {
        return this.Xcoord;
    };
    QSCHEDPLOTDETAILS.prototype.getYcoord = function() {
        return this.Ycoord;
    };
    QSCHEDPLOTDETAILS.prototype.getStatus = function() {
        return this.Status;
    };
    QSCHEDPLOTDETAILS.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSCHEDPLOTDETAILS.prototype.getLocation = function() {
        return this.Location;
    };
    QSCHEDPLOTDETAILS.prototype.getDatestamp = function() {
        return this.Datestamp;
    };
    QSCHEDPLOTDETAILS.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QSCHEDPLOTDETAILS where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QSCHEDPLOTDETAILS.prototype.getSetRefs = function() {
        return this.SetRefs;
    };
    QSCHEDPLOTDETAILS.prototype.getStartDate = function() {
        return this.StartDate;
    };
    QSCHEDPLOTDETAILS.prototype.getPPCGuid = function() {
        return this.PPCGuid;
    };
    QSCHEDPLOTDETAILS.prototype.getLat = function() {
        return this.Lat;
    };
    QSCHEDPLOTDETAILS.prototype.getLng = function() {
        return this.Lng;
    };
    QSCHEDPLOTDETAILS.prototype.getOwner = function() {
        return this.Owner;
    };
    QSCHEDPLOTDETAILS.prototype.getRecurDue = function() {
        return this.RecurDue;
    };
    QSCHEDPLOTDETAILS.prototype.getMPGUID = function() {
        return this.MPGUID;
    };
    QSCHEDPLOTDETAILS.prototype.getExtRef = function() {
        return this.ExtRef;
    };
    QSCHEDPLOTDETAILS.prototype.getSchedname = function() {
        return this.Schedname;
    };
    QSCHEDPLOTDETAILS.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[SchedInits][" + this.SchedInits + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Xcoord][" + this.Xcoord + "]";
        retVal += "[Ycoord][" + this.Ycoord + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[Datestamp][" + this.Datestamp + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[SetRefs][" + this.SetRefs + "]";
        retVal += "[StartDate][" + this.StartDate + "]";
        retVal += "[PPCGuid][" + this.PPCGuid + "]";
        retVal += "[Lat][" + this.Lat + "]";
        retVal += "[Lng][" + this.Lng + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[RecurDue][" + this.RecurDue + "]";
        retVal += "[MPGUID][" + this.MPGUID + "]";
        retVal += "[ExtRef][" + this.ExtRef + "]";
        retVal += "[Schedname][" + this.Schedname + "]";
        return retVal;
    };
var QSCHEDPLOTDETAILSDAO = function(){
};
QSCHEDPLOTDETAILSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDPLOTDETAILS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDPLOTDETAILS...");
        object.PlotID = resultset.fieldByName('PlotID');
        object.SchedID = resultset.fieldByName('SchedID');
        object.SchedInits = resultset.fieldByName('SchedInits');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Xcoord = resultset.fieldByName('Xcoord');
        object.Ycoord = resultset.fieldByName('Ycoord');
        object.Status = resultset.fieldByName('Status');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.Datestamp = resultset.fieldByName('Datestamp');
        object.SetRefs = resultset.fieldByName('SetRefs');
        object.StartDate = resultset.fieldByName('StartDate');
        object.PPCGuid = resultset.fieldByName('PPCGuid');
        object.Lat = resultset.fieldByName('Lat');
        object.Lng = resultset.fieldByName('Lng');
        object.Owner = resultset.fieldByName('Owner');
        object.RecurDue = resultset.fieldByName('RecurDue');
        object.MPGUID = resultset.fieldByName('MPGUID');
        object.ExtRef = resultset.fieldByName('ExtRef');
        object.Schedname = resultset.fieldByName('Schedname');
    };
QSCHEDPLOTDETAILSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingSchedInits = function(SchedInits) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where SchedInits = ? ',SchedInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingXcoord = function(Xcoord) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Xcoord = ? ',Xcoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingYcoord = function(Ycoord) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Ycoord = ? ',Ycoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingDatestamp = function(Datestamp) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Datestamp = ? ',Datestamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingSetRefs = function(SetRefs) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where SetRefs = ? ',SetRefs);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingStartDate = function(StartDate) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where StartDate = ? ',StartDate);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingPPCGuid = function(PPCGuid) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where PPCGuid = ? ',PPCGuid);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingLat = function(Lat) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Lat = ? ',Lat);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingLng = function(Lng) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Lng = ? ',Lng);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingRecurDue = function(RecurDue) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where RecurDue = ? ',RecurDue);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingMPGUID = function(MPGUID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where MPGUID = ? ',MPGUID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingExtRef = function(ExtRef) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where ExtRef = ? ',ExtRef);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsingSchedname = function(Schedname) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where Schedname = ? ',Schedname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSDAO.getUsing = function(where) {
        sqlstring = 'select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,MPGUID,ExtRef,Schedname from QSCHEDPLOTDETAILS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDPLOTDETAILSPPC(){
    var PlotID = null;
    var SchedID = null;
    var SchedInits = null;
    var DrwgID = null;
    var Xcoord = null;
    var Ycoord = null;
    var Status = null;
    var ShortDescrip = null;
    var Location = null;
    var Datestamp = null;
    var Photo = null;
    var SetRefs = null;
    var StartDate = null;
    var PPCGuid = null;
    var Lat = null;
    var Lng = null;
    var Owner = null;
    var RecurDue = null;
    var Schedname = null;
 var selectNoBlob = 'PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname';
};
    QSCHEDPLOTDETAILSPPC.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getSchedInits = function() {
        return this.SchedInits;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getXcoord = function() {
        return this.Xcoord;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getYcoord = function() {
        return this.Ycoord;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getStatus = function() {
        return this.Status;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getShortDescrip = function() {
        return this.ShortDescrip;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getLocation = function() {
        return this.Location;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getDatestamp = function() {
        return this.Datestamp;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getPhoto = function() {
         if (this.Photo == null) {
            result = db.getConnection().execute('select Photo from QSCHEDPLOTDETAILSPPC where ');
            this.Photo = result.field(0);
         }
        return this.Photo;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getSetRefs = function() {
        return this.SetRefs;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getStartDate = function() {
        return this.StartDate;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getPPCGuid = function() {
        return this.PPCGuid;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getLat = function() {
        return this.Lat;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getLng = function() {
        return this.Lng;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getOwner = function() {
        return this.Owner;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getRecurDue = function() {
        return this.RecurDue;
    };
    QSCHEDPLOTDETAILSPPC.prototype.getSchedname = function() {
        return this.Schedname;
    };
    QSCHEDPLOTDETAILSPPC.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[SchedInits][" + this.SchedInits + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[Xcoord][" + this.Xcoord + "]";
        retVal += "[Ycoord][" + this.Ycoord + "]";
        retVal += "[Status][" + this.Status + "]";
        retVal += "[ShortDescrip][" + this.ShortDescrip + "]";
        retVal += "[Location][" + this.Location + "]";
        retVal += "[Datestamp][" + this.Datestamp + "]";
        retVal += "[Photo][" + this.Photo + "]";
        retVal += "[SetRefs][" + this.SetRefs + "]";
        retVal += "[StartDate][" + this.StartDate + "]";
        retVal += "[PPCGuid][" + this.PPCGuid + "]";
        retVal += "[Lat][" + this.Lat + "]";
        retVal += "[Lng][" + this.Lng + "]";
        retVal += "[Owner][" + this.Owner + "]";
        retVal += "[RecurDue][" + this.RecurDue + "]";
        retVal += "[Schedname][" + this.Schedname + "]";
        return retVal;
    };
var QSCHEDPLOTDETAILSPPCDAO = function(){
};
QSCHEDPLOTDETAILSPPCDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDPLOTDETAILSPPC();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDPLOTDETAILSPPC...");
        object.PlotID = resultset.fieldByName('PlotID');
        object.SchedID = resultset.fieldByName('SchedID');
        object.SchedInits = resultset.fieldByName('SchedInits');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.Xcoord = resultset.fieldByName('Xcoord');
        object.Ycoord = resultset.fieldByName('Ycoord');
        object.Status = resultset.fieldByName('Status');
        object.ShortDescrip = resultset.fieldByName('ShortDescrip');
        object.Location = resultset.fieldByName('Location');
        object.Datestamp = resultset.fieldByName('Datestamp');
        object.SetRefs = resultset.fieldByName('SetRefs');
        object.StartDate = resultset.fieldByName('StartDate');
        object.PPCGuid = resultset.fieldByName('PPCGuid');
        object.Lat = resultset.fieldByName('Lat');
        object.Lng = resultset.fieldByName('Lng');
        object.Owner = resultset.fieldByName('Owner');
        object.RecurDue = resultset.fieldByName('RecurDue');
        object.Schedname = resultset.fieldByName('Schedname');
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingSchedInits = function(SchedInits) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where SchedInits = ? ',SchedInits);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingXcoord = function(Xcoord) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Xcoord = ? ',Xcoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingYcoord = function(Ycoord) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Ycoord = ? ',Ycoord);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingShortDescrip = function(ShortDescrip) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where ShortDescrip = ? ',ShortDescrip);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingLocation = function(Location) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Location = ? ',Location);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingDatestamp = function(Datestamp) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Datestamp = ? ',Datestamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingPhoto = function(Photo) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Photo = ? ',Photo);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingSetRefs = function(SetRefs) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where SetRefs = ? ',SetRefs);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingStartDate = function(StartDate) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where StartDate = ? ',StartDate);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingPPCGuid = function(PPCGuid) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where PPCGuid = ? ',PPCGuid);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingLat = function(Lat) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Lat = ? ',Lat);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingLng = function(Lng) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Lng = ? ',Lng);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingOwner = function(Owner) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Owner = ? ',Owner);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingRecurDue = function(RecurDue) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where RecurDue = ? ',RecurDue);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsingSchedname = function(Schedname) {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where Schedname = ? ',Schedname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDPLOTDETAILSPPCDAO.getUsing = function(where) {
        sqlstring = 'select PlotID,SchedID,SchedInits,DrwgID,Xcoord,Ycoord,Status,ShortDescrip,Location,Datestamp,SetRefs,StartDate,PPCGuid,Lat,Lng,Owner,RecurDue,Schedname from QSCHEDPLOTDETAILSPPC where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QCLOSEDADHOCS(){
    var PlotID = null;
    var Adhoc = null;
    var Status = null;
 var selectNoBlob = 'PlotID,Adhoc,Status';
};
    QCLOSEDADHOCS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QCLOSEDADHOCS.prototype.getAdhoc = function() {
        return this.Adhoc;
    };
    QCLOSEDADHOCS.prototype.getStatus = function() {
        return this.Status;
    };
    QCLOSEDADHOCS.prototype.toString = function() {
        var retVal = "";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[Adhoc][" + this.Adhoc + "]";
        retVal += "[Status][" + this.Status + "]";
        return retVal;
    };
var QCLOSEDADHOCSDAO = function(){
};
QCLOSEDADHOCSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QCLOSEDADHOCS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QCLOSEDADHOCSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QCLOSEDADHOCS...");
        object.PlotID = resultset.fieldByName('PlotID');
        object.Adhoc = resultset.fieldByName('Adhoc');
        object.Status = resultset.fieldByName('Status');
    };
QCLOSEDADHOCSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select PlotID,Adhoc,Status from QCLOSEDADHOCS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDADHOCSDAO.getUsingAdhoc = function(Adhoc) {
        var resultset =  db.getConnection().execute('select PlotID,Adhoc,Status from QCLOSEDADHOCS where Adhoc = ? ',Adhoc);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDADHOCSDAO.getUsingStatus = function(Status) {
        var resultset =  db.getConnection().execute('select PlotID,Adhoc,Status from QCLOSEDADHOCS where Status = ? ',Status);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDADHOCSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select PlotID,Adhoc,Status from QCLOSEDADHOCS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QCLOSEDADHOCSDAO.getUsing = function(where) {
        sqlstring = 'select PlotID,Adhoc,Status from QCLOSEDADHOCS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDCHECKSPPC(){
    var SCID = null;
    var SetRef = null;
    var Categ = null;
    var PlotID = null;
    var Code = null;
    var Description = null;
    var srt = null;
    var Qty = null;
    var Result = null;
    var Comment = null;
    var UserID = null;
    var DateStamp = null;
    var SchedID = null;
    var PassFail = null;
    var YYYYMMDD = null;
    var EditQty = null;
    var RecurDays = null;
 var selectNoBlob = 'SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays';
};
    QSCHEDCHECKSPPC.prototype.getSCID = function() {
        return this.SCID;
    };
    QSCHEDCHECKSPPC.prototype.getSetRef = function() {
        return this.SetRef;
    };
    QSCHEDCHECKSPPC.prototype.getCateg = function() {
        return this.Categ;
    };
    QSCHEDCHECKSPPC.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDCHECKSPPC.prototype.getCode = function() {
        return this.Code;
    };
    QSCHEDCHECKSPPC.prototype.getDescription = function() {
        return this.Description;
    };
    QSCHEDCHECKSPPC.prototype.getsrt = function() {
        return this.srt;
    };
    QSCHEDCHECKSPPC.prototype.getQty = function() {
        return this.Qty;
    };
    QSCHEDCHECKSPPC.prototype.getResult = function() {
        return this.Result;
    };
    QSCHEDCHECKSPPC.prototype.getComment = function() {
        return this.Comment;
    };
    QSCHEDCHECKSPPC.prototype.getUserID = function() {
        return this.UserID;
    };
    QSCHEDCHECKSPPC.prototype.getDateStamp = function() {
        return this.DateStamp;
    };
    QSCHEDCHECKSPPC.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QSCHEDCHECKSPPC.prototype.getPassFail = function() {
        return this.PassFail;
    };
    QSCHEDCHECKSPPC.prototype.getYYYYMMDD = function() {
        return this.YYYYMMDD;
    };
    QSCHEDCHECKSPPC.prototype.getEditQty = function() {
        return this.EditQty;
    };
    QSCHEDCHECKSPPC.prototype.getRecurDays = function() {
        return this.RecurDays;
    };
    QSCHEDCHECKSPPC.prototype.toString = function() {
        var retVal = "";
        retVal += "[SCID][" + this.SCID + "]";
        retVal += "[SetRef][" + this.SetRef + "]";
        retVal += "[Categ][" + this.Categ + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[Code][" + this.Code + "]";
        retVal += "[Description][" + this.Description + "]";
        retVal += "[srt][" + this.srt + "]";
        retVal += "[Qty][" + this.Qty + "]";
        retVal += "[Result][" + this.Result + "]";
        retVal += "[Comment][" + this.Comment + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[DateStamp][" + this.DateStamp + "]";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[PassFail][" + this.PassFail + "]";
        retVal += "[YYYYMMDD][" + this.YYYYMMDD + "]";
        retVal += "[EditQty][" + this.EditQty + "]";
        retVal += "[RecurDays][" + this.RecurDays + "]";
        return retVal;
    };
var QSCHEDCHECKSPPCDAO = function(){
};
QSCHEDCHECKSPPCDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDCHECKSPPC();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDCHECKSPPC...");
        object.SCID = resultset.fieldByName('SCID');
        object.SetRef = resultset.fieldByName('SetRef');
        object.Categ = resultset.fieldByName('Categ');
        object.PlotID = resultset.fieldByName('PlotID');
        object.Code = resultset.fieldByName('Code');
        object.Description = resultset.fieldByName('Description');
        object.srt = resultset.fieldByName('srt');
        object.Qty = resultset.fieldByName('Qty');
        object.Result = resultset.fieldByName('Result');
        object.Comment = resultset.fieldByName('Comment');
        object.UserID = resultset.fieldByName('UserID');
        object.DateStamp = resultset.fieldByName('DateStamp');
        object.SchedID = resultset.fieldByName('SchedID');
        object.PassFail = resultset.fieldByName('PassFail');
        object.YYYYMMDD = resultset.fieldByName('YYYYMMDD');
        object.EditQty = resultset.fieldByName('EditQty');
        object.RecurDays = resultset.fieldByName('RecurDays');
    };
QSCHEDCHECKSPPCDAO.getUsingSCID = function(SCID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where SCID = ? ',SCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingSetRef = function(SetRef) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where SetRef = ? ',SetRef);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingCateg = function(Categ) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Categ = ? ',Categ);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingCode = function(Code) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Code = ? ',Code);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingDescription = function(Description) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Description = ? ',Description);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingsrt = function(srt) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where srt = ? ',srt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingQty = function(Qty) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Qty = ? ',Qty);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingResult = function(Result) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Result = ? ',Result);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingComment = function(Comment) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where Comment = ? ',Comment);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingDateStamp = function(DateStamp) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where DateStamp = ? ',DateStamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingPassFail = function(PassFail) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where PassFail = ? ',PassFail);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingYYYYMMDD = function(YYYYMMDD) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where YYYYMMDD = ? ',YYYYMMDD);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingEditQty = function(EditQty) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where EditQty = ? ',EditQty);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsingRecurDays = function(RecurDays) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where RecurDays = ? ',RecurDays);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSPPCDAO.getUsing = function(where) {
        sqlstring = 'select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,SchedID,PassFail,YYYYMMDD,EditQty,RecurDays from QSCHEDCHECKSPPC where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
function QSCHEDCHECKS(){
    var SCID = null;
    var SetRef = null;
    var Categ = null;
    var PlotID = null;
    var Code = null;
    var Description = null;
    var srt = null;
    var Qty = null;
    var Result = null;
    var Comment = null;
    var UserID = null;
    var DateStamp = null;
    var DrwgID = null;
    var SchedID = null;
    var Schedname = null;
    var PassFail = null;
    var YYYYMMDD = null;
    var PPCGuid = null;
    var DueBy = null;
 var selectNoBlob = 'SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy';
};
    QSCHEDCHECKS.prototype.getSCID = function() {
        return this.SCID;
    };
    QSCHEDCHECKS.prototype.getSetRef = function() {
        return this.SetRef;
    };
    QSCHEDCHECKS.prototype.getCateg = function() {
        return this.Categ;
    };
    QSCHEDCHECKS.prototype.getPlotID = function() {
        return this.PlotID;
    };
    QSCHEDCHECKS.prototype.getCode = function() {
        return this.Code;
    };
    QSCHEDCHECKS.prototype.getDescription = function() {
        return this.Description;
    };
    QSCHEDCHECKS.prototype.getsrt = function() {
        return this.srt;
    };
    QSCHEDCHECKS.prototype.getQty = function() {
        return this.Qty;
    };
    QSCHEDCHECKS.prototype.getResult = function() {
        return this.Result;
    };
    QSCHEDCHECKS.prototype.getComment = function() {
        return this.Comment;
    };
    QSCHEDCHECKS.prototype.getUserID = function() {
        return this.UserID;
    };
    QSCHEDCHECKS.prototype.getDateStamp = function() {
        return this.DateStamp;
    };
    QSCHEDCHECKS.prototype.getDrwgID = function() {
        return this.DrwgID;
    };
    QSCHEDCHECKS.prototype.getSchedID = function() {
        return this.SchedID;
    };
    QSCHEDCHECKS.prototype.getSchedname = function() {
        return this.Schedname;
    };
    QSCHEDCHECKS.prototype.getPassFail = function() {
        return this.PassFail;
    };
    QSCHEDCHECKS.prototype.getYYYYMMDD = function() {
        return this.YYYYMMDD;
    };
    QSCHEDCHECKS.prototype.getPPCGuid = function() {
        return this.PPCGuid;
    };
    QSCHEDCHECKS.prototype.getDueBy = function() {
        return this.DueBy;
    };
    QSCHEDCHECKS.prototype.toString = function() {
        var retVal = "";
        retVal += "[SCID][" + this.SCID + "]";
        retVal += "[SetRef][" + this.SetRef + "]";
        retVal += "[Categ][" + this.Categ + "]";
        retVal += "[PlotID][" + this.PlotID + "]";
        retVal += "[Code][" + this.Code + "]";
        retVal += "[Description][" + this.Description + "]";
        retVal += "[srt][" + this.srt + "]";
        retVal += "[Qty][" + this.Qty + "]";
        retVal += "[Result][" + this.Result + "]";
        retVal += "[Comment][" + this.Comment + "]";
        retVal += "[UserID][" + this.UserID + "]";
        retVal += "[DateStamp][" + this.DateStamp + "]";
        retVal += "[DrwgID][" + this.DrwgID + "]";
        retVal += "[SchedID][" + this.SchedID + "]";
        retVal += "[Schedname][" + this.Schedname + "]";
        retVal += "[PassFail][" + this.PassFail + "]";
        retVal += "[YYYYMMDD][" + this.YYYYMMDD + "]";
        retVal += "[PPCGuid][" + this.PPCGuid + "]";
        retVal += "[DueBy][" + this.DueBy + "]";
        return retVal;
    };
var QSCHEDCHECKSDAO = function(){
};
QSCHEDCHECKSDAO.doresultset = function(resultset) {
        var resultarray = new Array(resultset.rowCount);
        for (var i = 0; i < resultset.rowCount; i++){
            var result = new QSCHEDCHECKS();
            this.loadFromResultset(result, resultset);
            resultset.next();
            resultarray[i] = result;
        }
        return resultarray;
    };
QSCHEDCHECKSDAO.loadFromResultset = function(object, resultset) {
        Titanium.API.info("loading QSCHEDCHECKS...");
        object.SCID = resultset.fieldByName('SCID');
        object.SetRef = resultset.fieldByName('SetRef');
        object.Categ = resultset.fieldByName('Categ');
        object.PlotID = resultset.fieldByName('PlotID');
        object.Code = resultset.fieldByName('Code');
        object.Description = resultset.fieldByName('Description');
        object.srt = resultset.fieldByName('srt');
        object.Qty = resultset.fieldByName('Qty');
        object.Result = resultset.fieldByName('Result');
        object.Comment = resultset.fieldByName('Comment');
        object.UserID = resultset.fieldByName('UserID');
        object.DateStamp = resultset.fieldByName('DateStamp');
        object.DrwgID = resultset.fieldByName('DrwgID');
        object.SchedID = resultset.fieldByName('SchedID');
        object.Schedname = resultset.fieldByName('Schedname');
        object.PassFail = resultset.fieldByName('PassFail');
        object.YYYYMMDD = resultset.fieldByName('YYYYMMDD');
        object.PPCGuid = resultset.fieldByName('PPCGuid');
        object.DueBy = resultset.fieldByName('DueBy');
    };
QSCHEDCHECKSDAO.getUsingSCID = function(SCID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where SCID = ? ',SCID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingSetRef = function(SetRef) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where SetRef = ? ',SetRef);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingCateg = function(Categ) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Categ = ? ',Categ);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingPlotID = function(PlotID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where PlotID = ? ',PlotID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingCode = function(Code) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Code = ? ',Code);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingDescription = function(Description) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Description = ? ',Description);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingsrt = function(srt) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where srt = ? ',srt);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingQty = function(Qty) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Qty = ? ',Qty);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingResult = function(Result) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Result = ? ',Result);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingComment = function(Comment) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Comment = ? ',Comment);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingUserID = function(UserID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where UserID = ? ',UserID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingDateStamp = function(DateStamp) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where DateStamp = ? ',DateStamp);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingDrwgID = function(DrwgID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where DrwgID = ? ',DrwgID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingSchedID = function(SchedID) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where SchedID = ? ',SchedID);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingSchedname = function(Schedname) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where Schedname = ? ',Schedname);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingPassFail = function(PassFail) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where PassFail = ? ',PassFail);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingYYYYMMDD = function(YYYYMMDD) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where YYYYMMDD = ? ',YYYYMMDD);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingPPCGuid = function(PPCGuid) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where PPCGuid = ? ',PPCGuid);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsingDueBy = function(DueBy) {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where DueBy = ? ',DueBy);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getall = function() {
        var resultset =  db.getConnection().execute('select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS');
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };
QSCHEDCHECKSDAO.getUsing = function(where) {
        sqlstring = 'select SCID,SetRef,Categ,PlotID,Code,Description,srt,Qty,Result,Comment,UserID,DateStamp,DrwgID,SchedID,Schedname,PassFail,YYYYMMDD,PPCGuid,DueBy from QSCHEDCHECKS where ' + where;
        var resultset =  db.getConnection().execute(sqlstring);
        var resultarray = this.doresultset(resultset);
        resultset.close();
        return resultarray;
    };