reading and writing to taffydb

424 views Asked by At

I can't seem to get data from my taffyDB. It has to be bad syntax but I don't know where. My Javascript looks like this:

// init db
var procTech = TAFFY();

//..... other code in the middle

procTech().remove(); 
var x = 0;
$(".sxRow select[id^='KRCtech_']").each(function() {
    var techName = $(this).val();       
    x++;
    var xStr = x.toString();
    clog(xStr + " " + techName);
    procTech.insert({"count":xStr,"tech":techName });   
});

var ret = eval(procTech().select("count","tech"));   
clog(ret.length);
for (j = 0; j <= ret.length - 1; j++) {   
    clog("read back: " + [j][0] + "," + [j][1]);
}   

// wrapper for console.log
function clog(s) {
    window.console && console.log(s);
    return; 
}

console says:

 1 tonya
 2 shawn
 2
 read back: 0,undefined
 read back: 1,undefined

so I know that

  1. my initial values are good; i.e. they have value
  2. Taffy sees 2 records, which is correct

It's just when I try and retrieve them, they are garbage.

What am I doing wrong?

1

There are 1 answers

0
ray On BEST ANSWER
procTech.insert({"count":1,"tech":'techName' });
procTech.insert({"count":2,"tech":'techName1' });
procTech.insert({"count":3,"tech":'techName2' });
procTech.insert({"count":3,"tech":'techName2' });
procTech.insert({"count":3,"tech":'techName2' });
procTech.insert({"count":4,"tech":'techName3' });

var query = procTech.select("count","tech"); // 3 rows

for ( var x=0; x<query.length-1; x++ ) {
    console.log(query[x][0], query[x][1]);
}