Coldfusion 9: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.

[wolfeyes333]

          HI, I can't seem to figure out what is the issue with this query, maybe someone can help me please

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.

Rishi

[wolfeyes333]

Forgot to include the query:

The error occurred in D:\work\kobeni\sites\current\noapp\sch_list_copy.cfm: line 168

166 : INSERT INTO #TO_PLATFORM.str_db2#.dbo.Files (str_filename, int_count, f_source_id, f_map_id, str_origfilename, str_delimiter, bln_quotes, bln_quarantine, bln_static, bln_imported)

167 : SELECT '#trim(str_file_name)#', #qry_lists.int_sizer#, 0, #map_id#, '#trim(str_file_name)#', '|', 0, 0, 0,0

168 : WHERE (select count(*) from #TO_PLATFORM.str_db2#.dbo.files where str_filename = '#trim(str_file_name)#') = 0

169 : </cfquery>

[EddieLotter]

If you evaluate your variables, what do they contain?

[wolfeyes333 · Accepted solution]

Turns out the issue was the 1st file, the name wasn't formatted properly so once I removed it all the others worked without any issues

Thanks for the response.