<!--- Get Lender Regions ---> <cfquery name="qryGetLenderRegion" datasource="#datasource#"> SELECT RegionID FROM LenderRegion WHERE LenderID = '#qryGetAdminInfo.LenderID#' </cfquery> <cfset LenderRegions = ""> <cfloop query="qryGetLenderRegion"> <cfset LenderRegions = ListAppend(LenderRegions, RegionID)> </cfloop>
-----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 1:09 PM To: CF-Newbie Subject: Create List From Query My brain is broken today - I need to create a list from Query results: <!--- Get Lender Regions ---> <cfquery name="qryGetLenderRegion" datasource="#datasource#"> SELECT RegionID FROM LenderRegion WHERE LenderID = '#qryGetAdminInfo.LenderID#' </cfquery> <cfset LenderRegions = (#qryGetLenderRegion.RegionID#)> LenderRegions SHOULD = "1,2" Instead, I just get "1" Help please - Thanks, -Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1412 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
