Skip to main content
Inspiring
September 25, 2008
Question

List to Oracle Query

  • September 25, 2008
  • 2 replies
  • 254 views
qOper is a query that holds Employee IDs, I need to pass that into oracle statement as below..
How would I do this ( And EID IN ('ED1','ED2', 'ED3',...) )?

Apparently valuelist doesnt work because it retuns no row...Thank you
    This topic has been closed for replies.

    2 replies

    emmim44Author
    Inspiring
    September 25, 2008
    I populated as follow valueslist(1,2,3)...got errorr
    Inspiring
    September 25, 2008
    What do see if you just look at that valuelist? Does it have anything in it?

    If it does, and you hard code some of those values into the some sql and run it outside of cold fusion, do you get results?