I have followed the tutorial for building a JQuery and JQTouch mobile website for the apple Iphone: [login to view URL] and the next chapter. After editing the code to make this an inventory taking website, the new entries do not appear. I have done extensive error checking and believe the issue lies within the "refreshEntries" loop, but I need someone who knows a little about javascript and SQLLite to fix the issue.
Also, I would like to add the 6th chapter to this project, the "offline caching" so that this site works when there is no internet connection, as well as an "upload" button that will upload the newly created database to the internet and then delete the local database. My web server (godaddy) has MySQL capabilities. Finally, I'd like to create a second "inventory" taking option that will download a list of product description from the server's MySQL database into a scrolling text box so that after you scan in the product barcode, you can match (select) the product description.
I will provide a link to the site for the error checking to the hired freelancer.
This is a sample of the code that does not appear to be working:
function refreshEntries() {
$('#scans ul li:gt(0)').remove();
[login to view URL](
function(transaction) {
[login to view URL](
'SELECT * FROM entries ORDER BY id;',
function (transaction, result) {
for (var i=0; i < [login to view URL]; i++) {
var row = [login to view URL](i);
var newEntryRow = $('#entryTemplate').clone();
[login to view URL]('id');
[login to view URL]('style');
[login to view URL]('entryId', [login to view URL]);
[login to view URL]('#scans ul');
[login to view URL]('.label').text([login to view URL]);
[login to view URL]('.pack').text([login to view URL]);
[login to view URL]('.delete').click(function() {
var clickedEntry = $(this).parent();
var clickedEntryId = [login to view URL]('entryId');
deleteEntryById(clickedEntryId);
[login to view URL]();
});
}
},
errorHandler
);
}
);
}