Is it considered normal for Access 2000 to only return the first 255
characters of a memo field when the DISTINCT argument is used? Here's what
I'm seeing ...
<CFQUERY Name="example" Datasource="db">
SELECT DISTINCT a.RecID, a.RecInfo, a.PriCode
FROM Master a, Info b
WHERE a.MasterID = #FORM.Id# AND a.IdxNum = b.IdxNum
ORDER BY b.RecID
</CFQUERY>
All columns are numeric except for RecInfo which is a memo field. The query
works fine, returns the expected records, except that with the DISTINCT
argument it only returns the first 255 characters of the field. If the
DISTINCT argument is removed the full field is returned.
Thanks,
Steve
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
