It seems to me that it would be a lot simpler if you use cfloop & CFCase
<cfloop query="returnedRecs">
<cfswitch expression="#returnedRecs.CurrentRow#">
<cfcase value="1">
<cfset firstID = returnedRecs.listing_id >
<cfset firstAddress = returnedRecs.address >
</cfcase>
<cfcase value="2">
<cfset secondID = returnedRecs.listing_id >
<cfset secondAddress = returnedRecs.address >
</cfcase>
<cfcase value="3">
<cfset thirdID = returnedRecs.listing_id >
<cfset thirdAddress = returnedRecs.address >
</cfcase>
<!--- Repeat cfcase for each value --->
<cfdefaultcase></cfdefaultcase>
</cfswitch>
</cfloop>
-----Original Message-----
From: Mike Chytracek [mailto:[email protected]]
Sent: Monday, June 21, 2010 4:19 PM
To: cf-newbie
Subject: RE: Classic ASP to Coldfusion
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:5021
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
