Interestingly enough I can have Access do the grouping internally (stored
query) and get the values... I guess that will be my solution.
If any one knows of a good reason not to do it this way please let me know.
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
