cfloop list error

[Tams87]

Hi,

I am trying to loop over a list and get results matching that list however, I get the following error:

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "1": invalid identifier

The error occurred in E:\ColdFusion8\wwwroot\MidWiferyLottery\test2.cfm: line 11

9 : <cfquery name='test1' datasource='t_test'>
10 : SELECT ID, FIRSTCHOICE FROM TBL_LOTTERY
11 : WHERE FIRSTCHOICE="#i#"
12 : </cfquery>
13 : </cfloop>

I have attached the code I am using.

Thanks in advance.

[Dan_Bracuk · Accepted solution]

Your error is caused by using double quotes.

Your approach is horrifically inefficient. You only need 1 query.

[Tams87]

Thank you, the quotes were the problem. As for the method, I am working on making it more efficient.