in addition to Cutter's answer: you ARE returning only ONE result from your cfc (and it is not of type query as CF rightly complains to you when you change the returntype attribute of your cffunction tag).
you are using: <cfset result=data.tirerear > which will return the value of tirerear field in the FIRST ROW of you query's resultset ONLY. -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
