Hi Stephen,
mails are stored in their rfc2822 (MIME) message format.
MIME supports encoded messages, so you CAN'T always expect to find the
text as is. For example it could be encoded in BASE64.
One possible approach is to integrate lucene and to change the
mailrepository to intercept message store to update an index (by
appropriately indexing interesting MimeMessage parts) so that you can
later query the lucene index to obtain message keys.
Stefano
[EMAIL PROTECTED] wrote:
Hi Folks,
I'm hoping that someone will be able to point me in the right direction. I
have created several lists to distribute email to user groups. These emails
are stored in a MS SQL database. I want to be able to query the mail table
and do wild card searches on message_body column and for emails that
satisfy the search I want to show those emails on a web page. So I want to
be able to do something like this:
SELECT * FROM mail WHERE UPPER(message_body) LIKE '%TEST STRING%' ORDER BY
last_updated DESC
This should return all the content from the emails so that they can be
displayed on a web page.
Any help would be much appreciated....
Thanks in advance,
Stephen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
