On Fri, 2009-05-29 at 08:50 -0500, David Champion wrote: > * On 29 May 2009, Roger Oberholtzer wrote: > > > > 2. Convert all the text to [wiki:TestProcedureTicket104] This is > > probably the most straight forward. But, as the subject suggests, I > > wonder if there is a way to do this to all tickets with this variable in > > a single script. It would make my life much easier. Otherwise I have a > > marathon editing session. > > If I understand correctly, you can do this in a single SQL statement > on your database: > > UPDATE ticket_custom > SET value = '[wiki:' || value || ']' > WHERE name = 'customVariable'; > > You might want to do this on a copy of the database as a trial run.
This seems right. Two questions: (1) 'customVariable' is the name of my variable, like 'tc_ten', right? (2) I an using the sqlite database (IIRC). Where would I execute this command? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
