-
21 Feb 2013 1:38 AM #1
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
- Chrome 24.0.1312.57
- ____
Ext.data.proxy.SQL.selectRecords function builds the SQL string with
even when params is a UUID string. Thus the SQL looks like:Code:sql += filterStatement + idProperty + ' = ' + params;
Of course SQL does not know how to handleCode:"SELECT * FROM MyModel WHERE id = 7c2bdb7d-de73-4d9f-af11-35416a723170"
Steps to reproduce the problem:- Config a model with identifier: 'uuid' and proxy: 'sql' then try to get a single model.
- 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.
-
22 Feb 2013 10:47 AM #2Sencha - Senior Forum Manager
- Join Date
- Mar 2007
- Location
- St. Louis, MO
- Posts
- 33,684
- Vote Rating
- 435
Thanks for the report! I have opened a bug in our bug tracker.
Success! Looks like we've fixed this one. According to our records the fix was applied for
TOUCH-4037
in
2.1.1.


Reply With Quote