Hi Giles I don't know if it's the root of your problem or not, but in the datasource setup "Advanced" settings in the CF Administrator, there's a whole load of settings for long text retrieval, buffer size etc - have you enabled long text retrieval in there?
Cheers Robin -----Original Message----- From: Giles Roadnight [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 21:52 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Access queries I have two tables: news and comments. I have written a query that returns the news records with a count of the number of comments there are for each story. This all works fine but as I am grouping the newsContent field I am only getting the first 255 (that's what it looks like anyway) characters (it is a memo field). How do I get around this? I know Access is quite limited but this is ridiculous! I must be able to count the number of comments and return the whole story! Thanks Giles Roadnight http://giles.roadnight.name -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
