Problem connecting to Data Source

[KevCB]

Hi,

I seem to be having a problem connecting to a data source, now that I have
changed the cfform to flash format. This is the error I am getting:

There are no columns found for the given table name "dbo.vacancy".

The error occurred in C:\Inetpub\wwwroot\HR\eom_vacancyeditaction.cfm: line 17

15 : <!--- Update the database --->
16 : <cfif IsDefined("Form.vacancyRef")>
17 : <cfupdate datasource="HR" tablename="dbo.vacancy">
18 : <cflocation url="eom_vacancydetail.cfm?ID=#Form.vacancyRef#">
19 : <cfelse>

Can anyone help?

Thanks

[Umesh-12021976]

By the error u provided it seems that there is other reason for error. can u provide some details

[KevCB]

Thanks for the reply, but I think I may have fixed this (well the error doesn't come up anymore).

I am now using SQL update in a cfquery tag instead of the cfupdate tag.