All was working fine 
and suddenly I am getting an error message below. I am going batty trying to think what the problem might be. Welcome your fresh set of eyes/insight into what the problem may be…
<CFQUERY NAME="Update" DATASOURCE="#request.SiteDSN#">
UPDATE products_list
SET
Products_MetaTitle = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Trim(Variables.Products_MetaTitle)#">,
Products_MetaKeywords = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Trim(Variables.Products_MetaKeywords)#">,
Products_MetaDescription = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Trim(Variables.Products_MetaDescription)#">,
Products_LandingSummary = <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#Trim(Variables.Products_LandingSummary)#">,
Products_Title = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Trim(Variables.Products_Title)#">,
Products_Info = <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#Trim(Variables.Products_Info)#">,
Products_HomeTitle = <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#Trim(Variables.Products_HomeTitle)#">,
Products_HomeDisplay = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#Trim(Variables.Products_HomeDisplay)#">,
Products_TryOption = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#Trim(Variables.Products_TryOption)#">,
Products_BuyOption = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#Trim(Variables.Products_BuyOption)#">,
Products_Hide = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#Trim(Variables.Products_Hide)#">
WHERE Products_PK = #Trim(Variables.ItemID)#;
</CFQUERY>
The error alert is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘9’ at line 14.
The position the message mentions is: Products_PK = #Trim(Variables.ItemID)#
Products_PK is a smallint field.
TIA!