> but this bombs out with: Complex object types cannot be > converted to simple values
> <cfquery name="getNewList" datasource="myds"> > ... > </cfquery> > <cfoutput>#getNewList#</cfoutput> Change that last line to: <cfdump var="#getNewList#"> You can't cfoutput a query result like that which is where your complex object error is coming from. The query itself looks fine and is certainly possible. I'd recommend using CFQUERYPARAM as well for good measure. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4560 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
