[rt-users] RT2 Attachments.Contents Lookups

[Fred.Purdue]

Right now I'm hacking together an Invoicing & Reporting front end for RT
using Microsoft Access and myODBC.  So far everything is going great.,
but I do have a question for the group.

Since the RT interface is *nix and Access is windows I'm having a
problem with a lookup on [Attachments.Contents].  When I lookup the
contents of the field on a windows host I'm getting some strange
characters (all the <cr>'s get turned into [] boxes.)  Basically the
exact same thing you get if you open a unix file in windows notepad...

Sooo..  What can I do to make the lookup work properly?  Every solution
I have found to date would require converting the data in the database
(which would cause problems with RT right?)

Fred
-- 
Fred.Purdue <Fred.Purdue at Pobox.com>

When choosing between two evils, I always like to take the one I've
never
tried before.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20021122/d5d1e466/attachment.htm>