Need help with incorrect syntax error during a record update

Question

I'm getting the error below but I cannot figure out what I'm doing wrong.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.

The error occurred in C:\ColdFusion9\wwwroot\Intranet\DM\Admin\Maintenance-BulbBaseType.cfm: line 23

21 : UPDATE [Bulb Base Type Table]

22 : SET [BulbBaseTypeDesc] = '#TxtBulbBaseTypeDesc#',

23 : WHERE ([BulbBaseTypeID] = #TxtID#)

24 : </cfquery>

25 : <cfset TxtID = 0>

I have set my cfparam as:

btvbillb · Accepted Answer

Thanks. I'm new to ColdFusion and this is someone else's code. I appreciate the help.

Adam Cameron. · Answer

A good rule of thumb when encountering this sort of error message is to examine the preceding line of code.

If you do that with your query, you should spot the trailing comma at the end of the line.

Also: read up on CFQUERYPARAM. Don't hard-code dynamic values in your SQL string.

--

Adam

Sign up