Skip to main content
W
wolfeyes333
Participant
August 21, 2014
Answered

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

  • August 21, 2014
  • 1 reply
  • 2189 views

          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

    This topic has been closed for replies.
    Correct answer wolfeyes333

    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.

    1 reply

    W
    wolfeyes333Author
    Participant
    August 21, 2014

    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
    EddieLotter
    Inspiring
    August 21, 2014

    If you evaluate your variables, what do they contain?

    W
    wolfeyes333AuthorCorrect answer
    Participant
    August 22, 2014

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices