We upgraded our production server to windows 2003 and have been seeing
this error when trying to update the database through a cfquery tag:

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
near ','.

SQL = "UPDATE documents SET catid = , moduleid = WHERE document_id =
21122"

Data Source = "EONET2"

The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (9:1) to (9:57).

Here is the code on the NT4 box:

<cfset itemId = #listFirst(docs.node)#>
<CFQUERY NAME="UpdateDoc" datasource="#application.DSN#">
UPDATE documents
SET catid = #itemID#, moduleid = #listLast(docs.node)#
WHERE document_id = #documentID#
</CFQUERY>


I've tried restructuring the query many ways but nothing seems to work?
What am I missing here?