Unknown Data Access Error???

[DeZiner]

Here is the error message I get when updating a record:

Data Access Error
Unknown Data Access Error.
The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (89:1) to (89:227).

Pertinent code:

<cfupdate datasource=&quot;#Application.DB#&quot; tablename=&quot;bnb_general&quot; formfields=&quot;name,addr_1,addr_2,city,state,zip,area_code_ph1,prefix_ph1,ph1,area_code_ph2,prefix_ph2,ph2,area_code_fx,prefix_fx,fx,email,domain,web_addr,state_loc&quot;></cfupdate>

Any thought on how to change the above code. This code was working fine on Windows platform and cf 4.5 We have moved to a Linux Box running cf 5.0 professional.
We also changed from an access DB to MySql on this linux box.

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[DeZiner]

My apologies. Asked this one before!

Solution:
<cfquery name=&quot;dbupdate&quot; datasource=&quot;#Application.DB#&quot;>
update listings
SET name='#form.name#', addr_1='#form.addr_1#', addr_2='#form.addr_2#', city='#form.city#', state='#form.state#', zip='#form.zip#', area_code_ph1='#form.area_code_ph1#', prefix_ph1='#form.prefix_ph1#', ph1='#form.ph1#', area_code_ph2='#form.area_code_ph2#', prefix_ph2='#form.prefix_ph2#', ph2='#form.ph2#', area_code_fx='#form.area_code_fx#', prefix_fx='#form.prefix_fx#', fx='#form.fx#', email='#form.email#', domain='#form.domain#', web_addr='#form.web_addr#', state_loc='#form.state_loc#'
WHERE id='#form.id#'
</cfquery>

Thanks again Tek-Tip users. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic