Text Missing from cfquery

[Jeremy Tan]

I have a query which return like 150 records, one of the field contain more
than 200 characters. When i try to display it, it only show up part of the text
from all the records. I did look at the data inside database, everything look
alright in there. Can someone help me please.

I am using
Access 2000,
CF4.5,
ODBC setup is allow long text and maximum text is 165000

[Jeremy Tan]

I found out that the cause is because of the group by and distinct in SQL. It
appear if i using DISTINCT or GROUP BY on long text, some text will be cut off
from the result.... does anyone know is there a limitation on that?

[Tim Carley]

If I remember correctly (it's been a while since I used 4.5 & Access)
255 characters is all that can be retreived when using distinct or group
by (performance issues). The work around is to run a separate query to
get the complete text. Sorry, I don't have a link to the M$ tech note handy.
HTH,
Tim
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMrecfusion.com[/email]

[sosueme]

Tim is correct, the limit is 255 characters in an Access text field. I got
around this, however, by changing the field type to meme, which allows
unlimited text in the Access field. It worked in 4.5 and is currently
displaying just fine using CF7. Good luck~