WHOOHOO!!! that did the trick Thanks a bunch!!!!! EP!
----- Original Message ----- From: "Craig Dudley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 9:41 AM Subject: RE: What am I doing WRONG!?!?! It is most likely long text retrieval option in the data source setup. Go into cf administrator and edit the data source. I had this issue the 1st time I upgraded a Cf5 box to MX, none of them access data sources would retrieve memo text fields. Fortunately, it only takes 2 seconds to fix. -----Original Message----- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:01 To: CF-Talk Subject: What am I doing WRONG!?!?! I'm no stranger to writing CF code and updataing a database is a snap, however I'm dumbfounded by this bug. Here is the setup Compaq server with CFMX running (upgraded from CF5) 1GIG or ram and 40gig of free space. The server processes istn even hitting 2% utilization yet. Ok here is the problem: I have a form to insert / update records to a database (Access) I know I would much rather use SQL but that id a different story, anyways I created a news form very simple feilds are title, date, and article, the tables defined in the database are as follows. ID = AutoNumber NewsTitle =text, 50 NewsDate = text, 50 NewsArticle =Memo Really Simple right... Well for some reason I cannot get the news article to show up it will update and I can insert a new record but when I do a CFDUMP of the query it says "[empty string]" under the NewsArticle feild is. But when I download the database from the server to view it, the table has the data in the feild. whats even more confusing is that the two other feild display and update fine. Here is the insert statment: <cfinsert dbtype="ODBC" datasource="srcs" tablename="TeamNews" formfields="NewsDate,NewsTitle,NewsArticle"> Here is the Update statment: <cfquery datasource="srcs" dbtype="ODBC"> UPDATE TeamNews SET NewsDate = '#NewsDate#', NewsTitle = '#NewsTitle#', NewsArticle = '#NewsArticle#' WHERE ID = #Update#; </cfquery> Thanks in advance Ernie Pena U. T. MD Anderson ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
