Answered
cfloop list error
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.
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.
