Your host probably jumped from CF5 to CF6 (or CF7) I've seen errors like this when upgrading from CF5 to CFMX (both 6 and 7). But, it's been a while so I don't remember specifics.
Check to make sure that the form fields match up with the database one-to-one. Make sure that the primary key is in the form for cfupdate, or not in there for cfinsert. Switch to a 'normal' cfquery and I'm sure you'll have no problems. At 07:36 AM 10/17/2006, you wrote: >Sometime around 2001 I created a website that used CF and MS Access. Last >year my host had a server crash. When they brought everything back up my >code no longer worked. They finally admitted they had jumped from CF6 to >CF7 so I assumed this was what had broken my site. I finally got around >to moving to another host who still hosts CF6 and surprise, my code is >still broken. It's got something to do with the SQL. It can query the db >just fine, but when there's a CFupdate to edit the db it returns an error >about types not matching, and it no longer accepts commas in >numbers. Since this was written so long ago the code is all gibberesh to >me now and I no longer have my original CF test Server so I can't recreate >the original setup. Can anyone point me to where the problem could >be? Is something missing in the DSN setup? Is XP possibly an >issue? Like I said, the code didn't change. One day it worked, next day >it didn't. And of course, the error message is a typical generic Windows >"yeah, there's something wrong somewhere" error message. I can post it if >anyone thinks it would help. Thank you. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2582 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
