> OK, managed to duplicate post and still screw it up! > The IN clause of the second query should be:
> WHERE messageId IN (<cfloop from="#startRow#" > to="#endRow#" > index="i">#ListGetAt(ValueList(getMessageIds.messageId), > i)#</cfloop>) > This is only an illustration - it's probably worth > creating the ValueList outside the loop to avoid creating > a large list multiple times. You need a comma in the loop also... <cfloop index="i"> <cfif i gt 1>,</cfif> #listgetat()#</cfloop> s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
