> > Final code that works: > > WHERE contactid = #FORM.player#
I would also suggest using cfqueryparam for a variety of reasons, including some limited sql injection protection. http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_18.html -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:330613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4