I doing this: list= db.GqlQuery(" SELECT * FROM UserUpdates WHERE windAngle=328")
for entity in list: db.delete(entity) On Jan 13, 6:54 am, "murexconsult...@googlemail.com" <robin_ow...@hedge-row.co.uk> wrote: > http://volvooceanracegamehelp.appspot.com/is the URL. > > I know I can delete programatically, but would rather use the tool you > provide for one-off deletes. > > Thanks for the help. > > Robin > > PS I just tried again using gql: > SELECT * FROM UserUpdates > WHERE windAngle=328 > > And it is still not working. > > On Jan 12, 9:39 pm, Marzia Niccolai <ma...@google.com> wrote: > > > Hi, > > > If you reply with your app id I can look in to it directly. > > > If you can find the data in the dataviewer, however, you can get the > > key string (from the data's URL) and call db.delete() directly on that > > key in your application (if, for instance, you included something like > > shell with your application so you could run interactive commands). > > > -Marzia > > > On Sun, Jan 11, 2009 at 1:33 PM, murexconsult...@googlemail.com > > > <robin_ow...@hedge-row.co.uk> wrote: > > > > There was a bug in my app and some bad data got into the Datastore. > > > > So I want to delete some data. The models have a number of items so > > > rather than paging through them all 20 at a time to find it I ran the > > > GQL query: > > > SELECT * FROM UserUpdates > > > WHERE windAngle=328 > > > > This returns one row as expected. I then click on the tickbox beside > > > it and click on Delete. > > > > I then get a dialog box asking if I am sure to which I say yes. > > > > I then get the error displayed in a red box at the top saying "The URL > > > to forward to once the request is fulfilled" - Yes the error is a > > > partial sentence and makes no sense. > > > > The item is NOT deleted. > > > > This is happening to all 4 of my models. However 2 of them only have a > > > few hundred entries, so I was able to page through, find the item and > > > delete it. When I paged through, the deleting was successful. > > > > I think that there must be a bug in the data viewer when removing data > > > found using a gql query. > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---