2 Replies Latest reply on Mar 13, 2012 9:13 PM by ACS LLC

    Using a created list in a SQL IN query

    ACS LLC Level 1

      I've solved this before but can't remember how, know it's going to be a simple one

       

      I've created a list from a CFLOOP, let's say it's MYLIST="us,ca,au,fr"

       

      I need to run a SQL CFQUERY on this list, WHERE xyz IN (MYLIST)

       

      The problem is that it won't read it correctly. Can anybody tell me the right command to make the sql read the list correctly on an individual item basis

       

      Thanks

       

      Mark