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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
