We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Oracle DBexecute from DBQuery

Comments

2 comments

  • Avatar
    Infogix Support
    Originally posted by: gmullin

    Looks like you're using a library "DB Nodes" that you didn't attach.

    Presuming you're using the Filter node to build up your where clause, you could make the entire query there like this:

    emit "select * from my_table where Numb in (" + ZZ.str() + ")" as query

    And then in DB Execute use: sqlSelect(1,query)
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: ThomasT

    Thanks Gerry.

    I got it to work :-)

    Thomas
    0
    Comment actions Permalink

Please sign in to leave a comment.