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]
