I would store the result to an array and count the array. That may not be optimal, but usually if I want a result count I wanted the results too, if only to store in memcache.
But if you select count(Query) You get just the count for the query. Long Explanation for Java here: http://groups.google.com/group/google-appengine-java/browse_thread/thread/78 b8b1b9c8a2dab1/073eb6d7eeb4cf84 -----Original Message----- From: google-appengine@googlegroups.com [mailto:google-appengine@googlegroups.com] On Behalf Of Droid Sent: Thursday, June 30, 2011 11:01 AM To: Google App Engine Subject: [google-appengine] How to do a 'count' in App Engine Basic question which I cannot solve: SELECT * FROM MyWords where bookname = 'book1' how can I simply count the number of returns? (I bet its easy eh?) Thanks in advance if you take the time.... -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en. -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.