Skip to main content
WolfShade
WolfShade
Legend
February 17, 2017
Answered

SQL command not properly ended - grrr argh..

  • February 17, 2017
  • 1 reply
  • 765 views

Hello, all,

I've got a query that isn't running within my CFM document; however, if I copy/paste the SQL from the error message into SQL Developer, it does just fine.

Windows Server 2012 with Oracle 12 and Windows Server 2012 with CF10 Server.

I'm creating a query object from scratch (QueryNew()) and trying to insert that data into a table.

My code is:

<cfquery name="insertData" datasource="#application.dsn#">
    INSERT ALL
    <cfloop query="myQuery">  into tableA(ID, ORG_ID, NAME, CITY, STATE, ZIP) VALUES ('#varA', '#varB', '#varC', '#varD', '#varE', '#varF')
    </cfloop>  SELECT * FROM DUAL;
</cfquery>

The error message is very vague, and yet if I copy/paste the SQL from the error message into SQL Developer, all the data is inserted.

Confuzzedly,

^_^

    This topic has been closed for replies.
    Correct answer WolfShade

    *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk*

    sigh

    *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk* *headdesk*

    I removed the semi-colon from after the "SELECT * FROM DUAL" subquery and it works.  WTF!!!

    V/r,

    ^_^

    1 reply

    H
    haxtbh
    Inspiring
    February 17, 2017

    What is the error message?

    Also you are missing  the end # on the vars in the query.

    WolfShade
    WolfShadeAuthor
    Legend
    February 17, 2017

    Hi, haxtbh​,

    The error message is the title of my post "SQL command not properly ended".  I am not missing any of the hashtags around variable names.

    V/r,

    ^_^

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