I use Trac 0.9.6 with SQLite for my project. I've been trying to make report by using $USER. But I don't use $USER with wildcard syntax.
For example, when $USER=k-sakakibara and I write SELECT * FROM ticket WHERE cc LIKE '%%$USER%%', report shows error message Report execution failed: near "k": syntax error. But, I write SELECT * FROM ticket WHERE cc LIKE '%%k-sakakibara%%', it's no error. Maybe '-' in $USER causes problem, but I can't solve it. Can you show me samples SQLite syntax. PS. I tried to use glob function, but it's same result... Thank you, k-sakakibara --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
