6 Replies Latest reply on Feb 16, 2017 1:39 AM by xguo RSS
    xguo Explorer

    The column index is out of range: 1, number of columns: 0

    Dear everyone,

     

    I stucked with the problem that input variable could not put into sql statement,Thingworx give error "

    The column index is out of range: 1, number of columns: 0

    "

     

    my sql statement like:

    select EXTRACT(MONTH from TIMESTAMP '[[ddd]]');   //ddd is the input variable  ,Datetime type

     

    if I put the ddd with '2016-12-01 08:40:00', thingworx will give error.

     

    thank you in advance.