Yup, completely sure it is a memo field. The way I found the problem was to compare the output I get on the page with the field in the DB. The one on the page was 255 chars, the one in the DB was much longer.
If I try to do a select distinct on just the memo field it won't let me, if I do it with another record too it does let me. Possibly it is not doing a distinct select on the memo. Giles Roadnight http://giles.roadnight.name -----Original Message----- From: Taz -=TT=- [mailto:chris@;cfmaster.co.uk] Sent: 18 October 2002 11:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Only 255 chars from memo field I'd say its not a memo field, since you can't do distinct operations on a memo/blob/etc. Are you sure its not a text field (which has a maximum of 255 chars in access)? Taz > Why am I only getting the first 255 characters from an Access DB memo > field when I do a select query? I have enabled Long text retrieval and > the long text buffer is set to 65000, the blob buffer is set to 64000 > bytes. > This is the query: -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
