I recently switched over to a new hosting company and my update query doesn't
work. Any ideas on what I can change to make this work? I changed it a ton of
times but it would not save the file name from my form into my mysql database.

UPDATE tblCust
Set item1 = '#cffile.ServerFile#'
where tblCust.CustID = #Session.CustId#

Get them to check the advanced settings for the datasource, that is where you define what type of commands are allowed.