Success! Looks like we've fixed this one. According to our records the fix was applied for TOUCH-4037 in 2.1.1.
  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
    St. Louis, MO
    Posts
    33,684
    Vote Rating
    435
    mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of

      0  

    Default


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

Tags for this Thread