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

Question

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 · Accepted Answer

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 issuesThanks for the response.

wolfeyes333 · Answer

Forgot to include the query:The error occurred in D:\work\kobeni\sites\current oapp\sch_list_copy.cfm: line 168166 : 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,0168 : WHERE (select count(*) from #TO_PLATFORM.str_db2#.dbo.files where str_filename = '#trim(str_file_name)#') = 0169 :

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.