Workflow and ServiceDesk Community

 View Only
Back to discussions
Expand all | Collapse all

-1 Row(s) affected error - Integration Project SQL Query

  • 1.  -1 Row(s) affected error - Integration Project SQL Query

    Posted Jun 17, 2014 01:27 PM

    Hello,

    I am receiving the following error when trying to query a database.  The query is a simple 'select * from (TABLE) where ID = ''  This was working fine but suddenly stopped working.  Issue appears in multiple DB queries.

     

    error.jpg



  • 2.  RE: -1 Row(s) affected error - Integration Project SQL Query
    Best Answer

    Posted Jun 17, 2014 01:31 PM

    You need to check "Returns Data" if you have a Select statement