The question arises as to why is this code attempting to create
variables for every row in the recordset? With ColdFusion, you can loop
over the recordset and use the current row columns for display or
calculation purposes.
<cfloop query="returnedRecs">
<p>
Current Record: <cfoutput>#returnedRecs.currentRow#</cfoutput><br/>
Listing Id: <cfoutput>#returnedRecs.listing_id#</cfoutput><br/>
Address: <cfoutput>#returnedRecs.address#</cfoutput>
</p>
</cfloop>
Or, you could simplify that by moving the cfoutput up to the loop if the
whole point is displaying data.
<cfoutput query="returnedRecs">
<p>
Current Record: #returnedRecs.currentRow#<br/>
Listing Id: #returnedRecs.listing_id#<br/>
Address: #returnedRecs.address#
</p>
</cfoutput>
--
Jeff Chastain
President/CEO, Admentus, Inc.
http://www.admentus.com
http://ams.admentus.com
Admentus is a custom web based solutions provider, delivering
business software applications, systems integration, strategic
consulting, and ColdFusion application maintenance services
which allow our clients to grow their business and plan for
the future.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5022
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
