What's wrong with this QoQ?

This is driving me batty. Every time I try to run this code I get a QoQ syntax error and I'm not seeing where the error is. cfloop from=1 to=3 index=i cfquery name=section dbtype=query SELECT * FROM questions WHERE section = #i# /cfquery /cfloop In case it's not immediately obvious, section is

re: What's wrong with this QoQ?

, April 29, 2010 3:34 PM To: cf-talk cf-talk@houseoffusion.com Subject: What's wrong with this QoQ? This is driving me batty. Every time I try to run this code I get a QoQ syntax error and I'm not seeing where the error is. cfloop from=1 to=3 index=i cfquery name=section dbtype=query SELECT * FROM

Re: What's wrong with this QoQ?

It appears section is a reserved word. Your WHERE clause should work if you use: WHERE [section] = #i# On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote: cfloop from=1 to=3 index=i cfquery name=section dbtype=query SELECT * FROM questions WHERE section = #i# /cfquery

Re: What's wrong with this QoQ?

It appears section is a reserved word. Your WHERE clause should work if you use: WHERE [section] = #i# On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote: Thanks. I didn't think to check for reserved words. That was the problem.