Don't think so - I', not retrieving much data at all. It is also not the CF admin set up as I get the same problem when I run it in Access.
I've been told that this is what Access does to memos when they are grouped. I'll just have to run 2 queries. Giles Roadnight http://giles.roadnight.name -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 10:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Access queries Are you exceeding the max number of characters per row. In SQL server you cannot have more than 8000 characters per row of data, unless you use BLOBS. I would imagine Access is similar. So any data beyond this gets chopped. russ > -----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] -- 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]
