Yes, Thank you for looking. Changing the order didn't work. Neither did
checking the "long text" field in the CF administrator. Heck, in the ODBC
control panel I tried adjusting the buffer and the "MaxAcanRows" values (I
believe they let the driver determine "what" the data types are?)
I feel better know that I have found other people with the same "unresolved"
problem:
I have a "workaround" in mind but this evening I will continue to poke
around.
> 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
