Databases
StackOverflow2013
Postsdbo
POretrieval failed in indexedDB
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POretrieval failed in indexedDB
    primarykey
    data
    text
    <p>The error is of failed retrieval of objects from the db. The exception is Exception 0 i.e. data provided to operation does not meet requirements. I want to retrieve the object values of date,pre,post depending upon the date provided in the input field. Also one error is of report is undefined. plz help..</p> <pre><code>&lt;!DOCTYPE html&gt; &lt;html manifest="manifest.webapp" lang="en"&gt; &lt;head&gt; &lt;meta charset="utf-8"&gt; &lt;title&gt;Diab&lt;/title&gt; &lt;!link rel="stylesheet" href="diab.css"&gt; &lt;script src="http://ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"&gt;&lt;/script&gt; &lt;/head&gt; &lt;body&gt; &lt;input type="date" id="date" &gt;Date&lt;/input&gt; &lt;input type="number" id="pre"&gt;Pre&lt;/input&gt; &lt;input type="number" id="post"&gt;Post&lt;/input&gt; &lt;button id="add"&gt;Add&lt;/button&gt; &lt;button id="show"&gt;Show&lt;/button&gt; &lt;script type="text/javascript" src="diab3.js"&gt;&lt;/script&gt; &lt;/body&gt; &lt;/html&gt; $(document).ready(function() { var db; var openDb=function() { var request=indexedDB.open("diabetore2",2); request.onsuccess = function() { console.log("DB created succcessfully"); db = request.result; console.log("openDB done!!"); return db; }; request.onerror=function(){ alert("could not open db"); }; request.onupgradeneeded = function() { var db= request.onsuccess(); console.log("openDB.onupgradeneeded function"); var store = db.createObjectStore("diab", {keyPath: 'date'}); var dateIndex = store.createIndex("date", "date",{unique: true}); // Populate with initial data. store.put({date: "june 1 2013",pre:70,post:70}); store.put({date: "june 2 2013",pre:71,post:87}); store.put({date: "june 3 2013",pre:72,post: 76}); store.put({date: "june 8 2013",pre:73,post:75}); }; }; function getObjectStore(store_name,mode) { var tx=db.transaction(store_name,mode); return tx.objectStore(store_name); } function addItems(date,pre,post) { console.log("addition to db started"); var obj={date:date,pre:pre,post:post}; var store=getObjectStore("diab",'readwrite'); var req; try { req=store.add(obj); }catch(e) { if(e.name=='DataCloneError') alert("This engine doesn't know how to clone"); throw(e); } req.onsuccess=function(evt) { console.log("****Insertion in DB successful!!****"); }; req.onerror=function(evt) { console.log("Could not insert into DB"); }; } function getItems(date) { var gdate=date; console.log("retrieval started from db"); var store=getObjectStore("diab","readonly"); var index=store.index("date"); var request=index.get(gdate); request.onsuccess=function() { var matching=request.result; if(matching !== undefined) { //report(matching.pre,matching.post); alert(matching.pre+ " , "+matching.post); }else console.log("match not found"); //report (null); }; } $("#add").click(function(){ console.log("addEventListeners called..."); console.log("add..."); var date=document.getElementById('date').value; var pre=document.getElementById('pre').value; var post=document.getElementById('post').value; if(!date) { alert("required field missing.."); return; } addItems(date,pre,post); }); $("#show").click(function(){ console.log("eventlistner called for retrieval.."); console.log("retrieve"); var date=$('date').val(); /*if(!date) { alert("required field missing.."); return; }*/ getItems(date); }); openDb(); //addEventListners(); //here(); }); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAbhishek Jain
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POretrieval failed in indexedDB
      1. USAbhishek Jain
      1. VTFavorite
    1. COwhat is the value of $('date').val();
      singulars
      1. POretrieval failed in indexedDB
      1. USKristof Degrave
    2. CO@ Kristof Degrave nw i added console.log("Date entered is"+ date); but i found that no value was stored in date variable,so i think this is the problem root...how to solve the issue ???..plz help
      singulars
      1. POretrieval failed in indexedDB
      1. USAbhishek Jain
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload