CFUPDATE not updating field

[Guest_imported]

I am using cfupdate to update a table on an Access DB. I am omitting the FormFields parm, so that all available form fields will update.

CFUPDATE is successfully updating each field but one. The field is of type text, I've verified that the form field is spelled exactly as the db column, and that it does exist and has a valid value. Similar text fields are updating fine with the same cfupdate operation. Including the FormField parm makes no difference in the outcome.

If I use CFQUERY with a SQL UPDATE statement for this field, it works fine.

Any idea why CFUPDATE would drop a single field like this?

Thanks!

 

[imstillatwork]

I would stick to using

<cfquery>
SQL UPDATE / INSERT / SELECT
</cfquery>

it seems to be more reliable anyway.

 

[Guest_imported]

So CFUPDATE is just quirky like this?

UDev

 

[imstillatwork]

I don't know all of the details of cfupdate, but I feel safer knowing that I created the SQL to make the update happen. I have NEVER had sql go wrong, unless it was bad coding. SQL is tried and true. I stick with that, and that way, any database access is in <cfquery> with SQL easy to see and edit for changes, debuging, whatever.