check the database itself and find out if it is text and not memo, better to be completely sure about this. ----- Original Message ----- From: "Giles Roadnight" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 11:56 AM Subject: RE: [ cf-dev ] Only 255 chars from memo field
> 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
