Ah crap! Forgot about the ValueList()!
-----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 1:16 PM To: CF-Newbie Subject: RE: Create List From Query Look at the function ValueList() or QuotedValueList(). <cfset LenderRegions = ValueList(qryGetLenderRegion.RegionID, ",")> How's that? Ade -----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: 05 October 2005 19:09 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1414 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
