a colleague of mine (two actually) has reliably informed me that you can't group on memo fields!?
_______________________________________________________ Regards, Richard Lovelock Senior Application Analyst Westminster City Council - Web Support Capgemini UK Southbank 95 Wandsworth Road London SW8 2HG Tel: 0870 906 7482 -----Original Message----- From: Giles Roadnight [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 10:58 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Access queries 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] Our name has changed. Please update your address book to the following format: "[EMAIL PROTECTED]". This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. -- 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]
