Replying to my own post: Now that I've thought about it a bit more, I guess this behavior makes sense. Asking the database to read/compare the entire value of a memo field would add considerable overhead to a "select distinct" query.
Just wish I'd known about it sooner! ----- Original Message ----- From: "Ricq Pattay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 10:53 AM Subject: SELECT DISTINCT in Access ODBC truncates MEMO field? > OK, this is weird: > > <cflock scope="session" timeout="30" type="readonly"> > <cfquery datasource="medsuppapp" name="get_access_exp"> > select id, exp_id, title, org, date_range, hours, description > from experiences > where id = #session.suserid# > </cfquery> > </cflock> > > returns the full value of the "description" field, which is type MEMO. > > However, > > <cflock scope="session" timeout="30" type="readonly"> > <cfquery datasource="medsuppapp" name="get_access_exp"> > select distinct id, exp_id, title, org, date_range, hours, description > from experiences > where id = #session.suserid# > </cfquery> > </cflock> > > truncates "description" to 255 characters. Why? (CF 5, Access ODBC data source) > > > Ricq Pattay > Senior Analyst/Programmer > College of Veterinary Medicine > University of Minnesota - Twin Cities > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
