No, just onto the page. The problem is when I try to update the DB fields using this field and on other. The Db is not updated as it is only getting the first 255 chars. I know I could do like '#field#%' but this is less than ideal and I would rather not.
Giles Roadnight http://giles.roadnight.name -----Original Message----- From: [EMAIL PROTECTED] [mailto:duncan.cumming@;alienationdesign.co.uk] Sent: 18 October 2002 11:54 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Only 255 chars from memo field Giles, tell me you're not outputting this in a text field? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:duncan.cumming@;alienationdesign.co.uk Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Giles Roadnight" <giles.roadnight@goldcockerelbo To: <[EMAIL PROTECTED]> oks.co.uk> cc: Subject: RE: [ cf-dev ] Only 255 chars from memo field 10/18/02 11:50 AM Please respond to dev 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] -- ** 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]
