Done that Already. Definitely Memo. I have used the like solution for
now.
I thought it may be something to do with distinct - possibly treating
them all as text fields but
<cfquery name="Records" datasource="tracker">
select Refurl
from tracker
where 1=1
and searchengine is null
and pageurl is not null
</cfquery>
gives me the same, max length of 255 chars.
Giles Roadnight
http://giles.roadnight.name
-----Original Message-----
From: Tom Smith [mailto:tomo_smith@;yahoo.co.uk]
Sent: 18 October 2002 12:05
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Only 255 chars from memo field
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]
--
** 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]
