Hi guys
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:
<cfquery name="Records" datasource="tracker">
select distinct top 100 Refurl, pageurl
from tracker
where 1=1
and searchengine is null
and pageurl is not null
</cfquery>
Giles Roadnight
http://giles.roadnight.name
--
** 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]
