WHERE = field IN #listlen()#

[CF_starter]

I'm capturing the value of wrong answers to question, i.e. 1,2,5,7, in a LIST.
I would like to use the LIST with the WHERE to generate the question
incorrectly and then display the right answer. I got it to work by doing
X-amount data queries in a loop. I don't like that solution and thought I could
it the wasy described above. Here is the code I'm using:

<cfquery name="question" datasource="#dataquery#>
SELECT *
FROM quiz
WHERE quizID IN #listlen(answer)#
</cfquery>

Answer is the LIST.

thanks
grady

[cf_menace]

ListLen(x) return the Length of the list "x".

So if you <cfset answer = "1,2,5,7">, then you're asking "WHERE quizID IN
(4)".

I'm really not sure what else you're trying to do though. Are you trying to
select the particular question, then show it with each element of the list as a
wrong answer?

[CF_starter]

I'm trying to see if I can look at all the value in the list to return the answer. I have a loop that I'm using but that don't like that solution.

grady

[CF_starter]

I'm trying to see if I can look at all the values in the list to return the answer. I have a loop that I'm using but that don't like that solution.

grady

[forumnotifier]

I'm trying to see if I can look at all the values in the list to return the answer. I have a loop that I'm using but that don't like that solution.

grady

[kyle969]

how does quizID relate to the answer? Show us more code, especially the old loop.