Aug
20
comment Backbone Model Sync() and $.mockjax()
I was afraid so too. Thanks. :)
Aug
20
accepted Backbone Model Sync() and $.mockjax()
Aug
20
comment Backbone Model Sync() and $.mockjax()
agreed.. that certainly is one way.. just as multiple regex are.. but in my opinion, quite a bit messy.. the ideal situation in my case would be a single regex that captures all the parameters regardless of the order they appear in.. however i think that this may be wishful thinking and probably no regex exists that can do this.. in which case, your answer turns out to be the next best option.. and hence correct.. :)
Aug
20
comment Backbone Model Sync() and $.mockjax()
The only solutions I have are: 1. Define multiple regex permutations and test for each of them (request > object and object > request). 2. Define single regex and ensure the query string contains parameters in a fixed order only.
Aug
20
comment Backbone Model Sync() and $.mockjax()
Thanks for the response jakerella. However the core argument still remains unaddressed. What SINGLE regex can possibly match AND capture the request and object variable values in both these urls. /adminNPS?request=abc&object=xyz and /adminNPS?object=xyz&request=abc.
Aug
11
comment SQL - Syncing Denormalize Table
works like a charm.. and i also understand how it works and why.. thank you so much.. :)
Aug
11
comment SQL - Syncing Denormalize Table
im sorry but im unable to get it to work, would you be kind enough to lay out the complete query? i need to update the LOGS table in batches of X rows while joining it with other tables.. heres my query right now.. UPDATE LOGS l LEFT JOIN users u ON u.id = l.user_id SET l.username = u.username, l.user_role = u.user_role WHERE l.username IS NULL
Aug
11
comment SQL - Syncing Denormalize Table
it works yes.. however if i wish to limit and order based on the LOGS table, the LOGS table becomes a read-only view.. and updating fails..
Aug
11
comment SQL - Syncing Denormalize Table
a follow up question.. i noticed that the sql ORDER BY and LIMIT clauses dont work with this type of query (update + join).. it works with a standard or joined SELECT query.. how can i impose a LIMIT with this query?
Aug
11
comment SQL - Syncing Denormalize Table
Thank you so much. It's so simple that it's beautiful. :)
Aug
11
accepted SQL - Syncing Denormalize Table
Aug
11
asked SQL - Syncing Denormalize Table
Jul
2
awarded Curious
Dec
20
asked Posting raw body form with jQuery
Dec
15
awarded Popular Question
Nov
2
awarded Tumbleweed
Oct
26
asked Backbone Model Sync() and $.mockjax()
Sep
8
revised Marionette + RequireJs - Issues with lazy loading
added 1358 characters in body
Sep
7
awarded Supporter
Sep
7
awarded Scholar
1 2 3 4 5