sakakiba at mug
Oct 22, 2007, 3:16 AM
Post #1 of 1
(125 views)
Permalink
|
|
SQL report syntax about $USER
|
|
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 trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
|
