Skip to main content
Participating Frequently
July 25, 2008
Answered

cfloop list error

  • July 25, 2008
  • 1 reply
  • 390 views
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.

This topic has been closed for replies.
Correct answer Dan_Bracuk
Your error is caused by using double quotes.

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

1 reply

Dan_BracukCorrect answer
Inspiring
July 26, 2008
Your error is caused by using double quotes.

Your approach is horrifically inefficient. You only need 1 query.
Tams87Author
Participating Frequently
July 28, 2008
Thank you, the quotes were the problem. As for the method, I am working on making it more efficient.