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 <[email protected]> wrote: > <cfloop from="1" to="3" index="i"> > <cfquery name="section" dbtype="query"> > SELECT * > FROM questions > WHERE section = #i# > </cfquery> > </cfloop> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
