Skip to main content
W
wolfeyes333
Participant
August 21, 2014
解決済み

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

  • August 21, 2014
  • 返信数 1.
  • 2189 ビュー

          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

    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

    W
    wolfeyes333作成者
    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
    wolfeyes333作成者解決！
    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.

    契約条件Accessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices