check your ODBC drivers. make sure you have the latest ones... especially since you upgraded to MX where JDBC is now an issue.
hth, mike -----Original Message----- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 10:01 AM 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
