Skip navigation
Currently Being Moderated

Using a created list in a SQL IN query

Mar 7, 2012 12:43 PM

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

 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points