I had this happen once, it took days of hair pulling before I worked it out. Check in CF administrator that the datasource has "Enable long text retrieval (CLOB)" checked, it's under advanced settings for the datasource and by default is not checked.
On Wed, 2 Mar 2005 11:36:54 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote: > > Ooops - hit the send button too early > > That's the maximum length of an Access field (except a memo) - firstly > are you sure its a memo field. > > > ++++++++++ > Kevin Parker > Web Services Consultant > WorkCover Corporation > > p: 08 8233 2548 > m: 0418 806 166 > e: [EMAIL PROTECTED] > w: www.workcover.com > > ++++++++++ > > -----Original Message----- > From: Parker, Kevin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 2 March 2005 11:35 AM > To: CF-Talk > Subject: RE: Access Memo field issues > > <<< 255 characters. > > That's the maximum length of an Access field (except a memo) > > ++++++++++ > Kevin Parker > Web Services Consultant > WorkCover Corporation > > p: 08 8233 2548 > m: 0418 806 166 > e: [EMAIL PROTECTED] > w: www.workcover.com > > ++++++++++ > > -----Original Message----- > From: Jake McKee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 2 March 2005 11:03 AM > To: CF-Talk > Subject: Access Memo field issues > > All, > > I recently was testing an application that I'm building and noticed that > suddenly one of my queries was truncating one of my #variable# outputs. > I'm using Access while I test, and things have been fine up until now. > > On the admin tool, things are saving and displaying correctly, but when > the trying to output it on the user side, it's truncating at or around > 255 characters. > > Any idea what might be going on or how to resolve it? > > Thanks! > Jake > --- > BlogFusion > www.countersinkdg.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197083 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
