<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.1.6">
</HEAD>
<BODY>
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.<BR>
<BR>
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...<BR>
<BR>
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?)<BR>
<BR>
Fred<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
Fred.Purdue <<A HREF="mailto:Fred.Purdue@Pobox.com">Fred.Purdue@Pobox.com</A>><BR>
<BR>
When choosing between two evils, I always like to take the one I've never<BR>
tried before.
</TD>
</TR>
</TABLE>
</BODY>
</HTML>