If it's a query: <cfloop query="dbQueryname"> <cfif x=y> xxx <cfelseif x=z> xxx </cfif> </cfloop>
Mike -----Original Message----- From: Adam Parker [mailto:[email protected]] Sent: Monday, June 21, 2010 3:08 PM To: cf-newbie Subject: Classic ASP to Coldfusion Hello - I am attempting to translate the following code into CF: counter = 0 do while not returnedRecs.eof if counter = 0 then firstID = returnedRecs("listing_id") firstAddress = returnedRecs("address") elseif counter= 1 then secondID = returnedRecs("listing_id") secondAddress = returnedRecs("address") elseif counter = 2 then thirdID = returnedRecs("listing_id") thirdAddress = returnedRecs("address") elseif counter = 3 then fourthID = returnedRecs("listing_id") fourthAddress = returnedRecs("address") elseif counter = 4 then fifthID = returnedRecs("listing_id") fifthAddress = returnedRecs("address") elseif counter = 5 then sixthID = returnedRecs("listing_id") sixthAddress = returnedRecs("address") elseif counter = 6 then seventhID = returnedRecs("listing_id") seventhAddress = returnedRecs("address") elseif counter = 7 then eighthID = returnedRecs("listing_id") eighthAddress = returnedRecs("address") elseif counter = 8 then ninethID = returnedRecs("listing_id") ninethAddress = returnedRecs("address") else tenthID = returnedRecs("listing_id") tenthAddress = returnedRecs("address") end if counter = counter + 1 returnedRecs.movenext loop %> I believe the code is assigning variables values from the database. I think the way to translate this is: <cfif qGetProperties.recordCount EQ 0> <cfset firstID = #listingID#> <cfelseif>... </cfif> and so on... Am I on the right track? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5020 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
