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:2581 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
