Thanks for the reply Serge. I guess I should ask a more rudimentry question.... how do
I get the source to compile cleanly?
I downloaded the source and created a new project from source (JBuilder) and when I
attempt to run the Ant build I get an error:
D:\projects\james_source\phoenix-bin\lib not found.
Dave
-----Original Message-----
From: Serge Knystautas [mailto:[EMAIL PROTECTED]
Sent: Tue 10/7/2003 12:31 PM
To: James Users List
Cc:
Subject: Re: Display Messages
David Liles wrote:
> I am trying to display the message_body column and am having trouble......
the data type in the database is "image" (MS SQL) so I'm unsure as to what to use....
blob, clob or what?
>
> I tried blob but got an error... I've never used blob data type before.....
What are you trying to display the message as? If you're using messages
within James, you don't need to know the table structure.
If you're just in Query Analyzer, I frequently do select
convert(varchar(8000), message_body) just to see the beginning of the
message body. If you're in Java, it really depends on your mapping
layer or if you're using straight JDBC. That's more of a question for
them though.
--
Serge Knystautas
President
Lokitech >> software . strategy . design >> http://www.lokitech.com
p. 301.656.5501
e. [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
