Skip to main content
E
emmim44
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

    E
    emmim44Author
    Inspiring
    September 25, 2008
    I populated as follow valueslist(1,2,3)...got errorr
    D
    Dan_Bracuk
    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?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices