getting mSSQL Err:

I have the following insert and doing insert in mSSQL:

getting error:

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.  
 
The error occurred in C:\inetpub\wwwroot\project2\admin\com\insert.cfc: line 302
 
300 :     (prodID,catID)
301 :     VALUES
302 :     <cfloop from="1" to="#listlen(arguments.structform.category)#" index="x">
303 :     (#NewProductID#, #listgetat(arguments.structform.category, x)#)
304 :     <cfif x lt listlen(arguments.structform.category)>,</cfif>
 

<cfquery datasource="#request.dsn#" name="myset" username="#request.user#" password="#request.pass#">      
    SET NOCOUNT ON
    INSERT INTO products(productName, prodDesc, seller_ID, productaddon, status, prodShortDesc) 
    VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.structform.productname#" maxlength="255">,
    <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#arguments.structform.productDesc#">,
    <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.structform.chooseSeller#">,
    <cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateODBCDateTime(now())#">,
    <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.structform.status#">,
    <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#arguments.structform.productShortDesc#">)
    SET NOCOUNT OFF 
    select scope_identity() as productID;
    </cfquery>
    <cfset NewProductID = #myset.productID#>
    <cfquery name="insertItemCats" datasource="#request.dsn#" username="#request.user#" password="#request.pass#">
    INSERT INTO ProductCategories   
    (prodID,catID) 
    VALUES
    <cfloop from="1" to="#listlen(arguments.structform.category)#" index="x">
    (#NewProductID#, #listgetat(arguments.structform.category, x)#)
    <cfif x lt listlen(arguments.structform.category)>,</cfif>
    </cfloop>
    </cfquery>

Select allOpen in new window