I've experienced a similar problem running on the SDK.aplying two filter()s result in 0 records found. Aplying either one of the filter()s and comparing the resultsets found a record that matches both filter()s.
Jaap Taal [ Q42 BV | tel 070 44523 42 | direct 070 44523 65 | http://q42.nl | Waldorpstraat 17F, Den Haag | KvK 30164662 ] On Tue, Aug 4, 2009 at 6:01 AM, phtq <[email protected]> wrote: > > In our application (kbdlessons version 1-01) we have just had a case > where a query in our application failed to return a record which > definitely exists. We were able to reproduce this problem using the > Dataviewer page off the app engine dashboard. > > We put in this query using the Dataviewer: > > SELECT * FROM StudentSubscriptions where StudentKey = 'REBECCA' and > ProductKey = 'Typequick Professional' and AccountKey = 'SIVF' > > and got no results. However, if we use just 2 out of the 3 tests (any > 2!) the record we want appears amongst the results. > > Also, other valid values for StudentKey when used in this 3 part query > do return a record in the Dataviewer page, just not this particular > set of 3 values. > > We had to build a new record (under another name) to get the student > going, but have left the troubled record in the database so you can > look at it. > > Please let me know how to avoid this rather worrying problem. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
