run code within JSON **URGENT**
Hi All,
I've been asked to write a mobile app for a customer and as usual I've left it to the last minute, which is now tomorrow.
The code below is made up of two parts.
The first part is a getJSON() query that returns data as three strings sql_id, sql_company, sql_con. This part works well.
The second part is to save the data collected in part one into an IndexedDB, which doesn't work.
Does anyone know how I can get the store.put to work?
The console logs the following error
If I run store.put outside of the getJSON(), it works.
Any suggestions?
I've been asked to write a mobile app for a customer and as usual I've left it to the last minute, which is now tomorrow.
The code below is made up of two parts.
The first part is a getJSON() query that returns data as three strings sql_id, sql_company, sql_con. This part works well.
The second part is to save the data collected in part one into an IndexedDB, which doesn't work.
$.getJSON(url, function(data){
$.each(data.users, function(i,user){
//set variables
var sql_id = user.id;
var sql_company = user.company;
var sql_contact = user.contact;
//put variables into IndexedDB
store.put({id: sql_id, customer: sql_company, contact: sql_contact});
});
});
Does anyone know how I can get the store.put to work?
The console logs the following error
Uncaught TransactionInactiveError: Failed to execute 'put' on 'IDBObjectStore': The transaction has finished.
If I run store.put outside of the getJSON(), it works.
Any suggestions?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi mate.
So you're trying to insert a new record or update an existing one?
First thing is that you're using the 'put' method which updates an existing record and for that you need to get it from the store, change it, and then save it again.
But what I think is that what you actually want is to add a new record to the store right?
For that you need to use the 'add' method:
So you're trying to insert a new record or update an existing one?
First thing is that you're using the 'put' method which updates an existing record and for that you need to get it from the store, change it, and then save it again.
But what I think is that what you actually want is to add a new record to the store right?
For that you need to use the 'add' method:
store.put({id: sql_id, customer: sql_company, contact: sql_contact});
Yes I am trying to add a new record.
returns
store.add({id: sql_id, customer: sql_company, contact: sql_contact});
returns
Uncaught TransactionInactiveError: Failed to execute 'add' on 'IDBObjectStore': The transaction has finished.
I'm getting a bit desperate, so tried switching to WebSQL (instead of IndexedDB).
returns this
tx.executeSql('INSERT INTO CRM (id, customer, contact, modified) VALUES (1, "Company name","Contact Name","2014-01-01")');
returns this
Uncaught InvalidStateError: Failed to execute 'executeSql' on 'SQLTransaction': SQL execution is disallowed.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial