CFUPDATE AND MX

[bluesauceuk]

Hello,

I have an Access Database and I am moving hostingt companies...

It works on the old host but not on the new.. is this because of they have CF MX?

The code is really simple:

<cfupdate datasource=&quot;project03&quot; tablename=&quot;traxhome&quot; formfields=&quot;traxhomeid, text&quot;>

Where the form.text is a MEMO field in the access database.

What is going on does anyone know?

Thanks

Mark

 

[ecobb]

It could be an issue with MX, I've never tried a cfupdate with it. But most likely, the problem is going to be with cfupdate itself, and nothing wrong with your host. Both the cfupdate and cfinsert are considered somewhat unstable and it is HIGHLY recommended (by Macromedia and most CF developers) that the actual SQL statements be used for updates and inserts. Mainly for the reasons that you are seeing now. The applications work great for a while, then they break for no reason, and the next day they may be working again. This has literally happened to me before with both cfupdate and cfinsert. Try using the SQL update instead of the cfupdate and I'll bet your form will work.