On Aug 21, 2:27 pm, Ethan Jucovy <[email protected]> wrote: > 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 > installinghttp://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<[email protected]> 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
I typically use batchmodifyplugin for these types of things, however there are quite a few sqllite convience tools, like Line 709, not sure I like a SQL Lite Browser that make this easy. sqllite also has a command-line option, if I remember correctly , and you could write a python script that connects to the db and exectues the query as well. Just some thoughts. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" 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/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
