jQuery Forum

Hi Guys,

i have a little problem getting to the results of a sql count function.

this is what i am trying to do:

table 1: product categories
    cid = uniek
    category_name = TEXT

table 2: products
   pid = uniek
   cid = link to category
   type = subcategorie (there are only 2 types)
   product_name = TEXT

I want a listview of all categories_name en the number of products of type 1 and type 2 that are in that categorie in to seperate <span class="ui-li-count">.

The sql and loop for the category listview is working fine, now i want to add a function to this loop that counts the number of type 1 en type 2 product in each category.

My problem is storing the result of the count function in a way that i can use it in the creation of the listview.

Code: Create listview loop

1. this.store = new select_functions()
2. this.store.select_categorie(function(result_array){
3.       var l = result_array.length;
4.       var e;               
   
5.      
   
6.       for (var i=0; i<l; i++) {
   
7.             e = result_array[i];
   
8.      
   
9.             this.count = new count_functions();
10.             var type1 =  this.count.count_products_by_type(e.cid, "type1", callback); //not working
    
11.             var type2 = this.count.count_products_by_type(e.cid, "type2", callback); //not working
12. 
    
13.             $('#categorie_listview').append('<li"><a href="#">'+ e.categorie_name+'</a><span class="ui-li-count">'+type1+'</span><span class="ui-li-count">'+type2+'</span></li>');
14.         }
15. });

 

Hi Guys,

i'm new to jquery/jquery mobile, and trying to build my first app with dynamic content from sqlite database.
the basic functionality of the app is working, but i got some difficulty refreshing the dynamic content pages.
In this app there can be several links to the same page with different argmuments to get the correct content from te database. so the page should be totaly rebuild before shown to the user.

The dynamic adding to de list works fine, but when i revisit the dynamic page with different arguments for adding content to the list, the old results (list) shows for a few seconts before rebuilding the list with de dynamic content of the new request.

CODE:

Menu links:  (?order=... is removed by plugin and is stored in $.mobile.pageData)

1. <a href="#page_products?order=price">Order by Price</a>
2. <a href="#page_products?order=name">Order by Name</a>

Function

1. $('#page_products').live('pageshow',function(){
2.    //get data from sqlite ......
   
3.      $('#list_product').empty();
4.       //loop through results
   
5.       for (var i=0; i<l; i++){
6.                  $('#list_product').append('<li>Products variable</li>');
   
7.       }
8. });

HTML page

1. <div data-role="page" id="page_products">
2.        <div data-role="content">
3.                    <ul data-role="listview" id="list_product" data-inset="true"></ul>                           
4.        </div><!-- /content -->
5.  </div>