On 7/24/06, Schultz, Eric <[EMAIL PROTECTED]> wrote:
It would help even more to show the original "RT query" that generated
this SQL.
Here you go.
Thanks,
Brian
[13/Jul/2006:10:09:30 -0400] x.x.x.x SSLv3 RC4-MD5 "GET
/Search/Results.html?Order=ASC&Query=%20Priority%20%3D%2075%20AND%20Created%20%3E%20'1%2F1%2F2006'%20AND%20Queue%20%3D%20'alerts'%20AND%20'CF.%7BActionable%7D'%20LIKE%20'Yes'%20AND%20'CF.%7BIR%7D'%20LIKE%20'Yes'%20AND%20Content%20NOT%20LIKE%20'Incident%20Report'&Rows=&OrderBy=id&Format='%20%20%20%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23'%2C%0A'%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject'%2C%0A'__Status__'%2C%0A'__QueueName__'%2C%0A'__OwnerName__'%2C%0A'__Priority__'%2C%0A'__NEWLINE__'%2C%0A''%2C%0A'%3Csmall%3E__Requestors__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E'
HTTP/1.1" 52331
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
