I admit it. SQL is not my area. So bear with me on a stupid question:
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
What am I doing wrong?
--
Roger Oberholtzer
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
