Success! Looks like we've fixed this one. According to our records the fix was applied for TOUCH-4037 in a recent build.
  1. #1
    Sencha User
    Join Date
    Oct 2012
    Posts
    1
    Vote Rating
    0
    bullale is on a distinguished road

      0  

    Default Ext.data.proxy.SQL uuid support for single read.

    Ext.data.proxy.SQL uuid support for single read.


    REQUIRED INFORMATION

    Sencha Touch version tested:
    • ST 2.1.0
    Browser versions tested against:
    • Chrome 24.0.1312.57
    DOCTYPE tested against:
    • ____
    Description:
    Ext.data.proxy.SQL.selectRecords function builds the SQL string with
    Code:
    sql += filterStatement + idProperty + ' = ' + params;
    even when params is a UUID string. Thus the SQL looks like:
    Code:
    "SELECT * FROM MyModel WHERE id = 7c2bdb7d-de73-4d9f-af11-35416a723170"
    Of course SQL does not know how to handle
    Steps to reproduce the problem:
    • Config a model with identifier: 'uuid' and proxy: 'sql' then try to get a single model.
    Possible fix:
    • Change the offending line as follows:
    Code:
    params = typeof(params)==="string" ? "'" + params + "'" : params;
    sql += filterStatement + idProperty + ' = ' + params;
    Last edited by bullale; 21 Feb 2013 at 1:45 AM. Reason: Possible fix worked in console but not in practice. Hmph. Fix works now.

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    36,795
    Vote Rating
    834
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    Thanks for the report! I have opened a bug in our bug tracker.

  3. #3
    Sencha User
    Join Date
    Jan 2012
    Posts
    1
    Vote Rating
    0
    jebus888 is on a distinguished road

      0  

    Default idProperty of proxy.sql

    idProperty of proxy.sql


    Question:
    When I specify a idProperty name into the model, the json data is not being saved into the web sql. Is this a known issue?

    Code:
    Ext.define('Mobile.model.ResponseModel', {
                extend: 'Ext.data.Model',
                config: {
                    idProperty: 'FormId',
                    identifier: 'uuid',
                    fields: [ {name: 'FormId', type: 'auto', mapping: 'Response.FormId'}]
                }
            });

Thread Participants: 2

Tags for this Thread

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi