I take it that the 'Message' field is the Memo field? If so, try
selecting that one last in the query...
SELECT
Max(Messages.TimeStamp) As NewMessage,
Topics.Topic,
Messages.Message
FROM
Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID
GROUP BY
Topics.Topic,
Messages.Message
Other than that???
HTH,
Jeff
-----Original Message-----
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 10:18 PM
To: CF-Talk
Subject: Access memo fields truncated in GROUP BY?
Something I hadn't noticed before. What's up with Access, Memo fields,
and
joins?
If you include a memo field in a GROUP BY it gets truncated to 255
chars...
not the desired effect here. If I remove the MAX() ..and then don't
require
the GROUP BY then the field is not truncated...
If there is a solution I would love to hear it. (feeling perplexed)
(the simplified non-working query)
<cfquery datasource="forum" name="GetForumInfo" debug>
SELECT
Messages.Message,
Max(Messages.TimeStamp) As NewMessage,
Topics.Topic
FROM
Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID
GROUP BY
Topics.Topic,
Messages.Message
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
