Hey Don, You won't be able to execute SQL UPDATEs from the web interface. If you want to execute that SQL you'll need to use an external database client.
Alternatively you could try installing http://trac-hacks.org/wiki/BatchModifyPlugin -- it might also do what you need (but without any SQL). egj On Thu, Aug 20, 2009 at 4:34 PM, Don<don...@verizon.net> wrote: > > Sorry if this is a newbie question, didn't see it in the help faq. > > I'm trying to do a bulk update like update ticket set owner='joe' > where owner='shmoe'; > > But I'm not sure where to run that from. When I try to enter it in a > custom query, I'm getting an error because it is trying to get a count > from the query results, as in: select count(*) from (update ticket > set owner=...) > > thanks, > - Don > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---