Hi All, HELP - I'm really stumped on this one. A simple form inserts data to an Access table, comprised of numeric, text, autonumber(key), and memo fields. Data writes to db normally (I've checked the db). However, doing a cfquery and cfoutput to display the results returns all fields except for the memo field. - upon which I get a blank (empty) area where the memo output should be.
No error messages are thrown, except if I don't scope the output for the memo field as coming from the query, then it throws an error as it can't determine the parameter (this only occurs on the memo field output, all other fields, even if not scoped are returned normally). I've turned off all instances of cfsilent, cfsetting enableoutput=yes, cfprocessingdirective suppresswhitespace, all to no avail. All variables are scoped. This problem just seems to have started with two new sites I've been working on using a clean ms Access db and DWMX for coding. Old sites which I have running don't have this problem (both old and new site using CF 5). BTW - I've also tried tweaking parameter settings in MS Access with no change in results. Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
