Roger, On Fri, Sep 11, 2009 at 9:48 AM, Roger Oberholtzer <[email protected]> wrote: > > I want to change all values of the 'cc' field in all tickets to some > value. I do not care what is already there. I will replace it. I have > tried many things, but I do not seem to get it to work. > > I can list the field with: > > SELECT id AS Cc, cc FROM ticket; > > However, when I try to update the value of the 'cc' field with: > > UPDATE ticket SET value = '@Tickets' WHERE name = 'cc'; > > I get this error: > > SQL error: no such column: value
If you want to change ALL tickets, then the correct sql would be more like this: UPDATE ticket SET cc = '@Tickets'; There is no need for a where clause at all, if you want to change all tickets. chris --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
