If there is a variables called #active_week# and you have it in a cfquery you don't need a tag around it.
Ade -----Original Message----- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: 01 August 2003 16:41 To: CF-Talk Subject: dynamic sql update i know i need a tag around #active_week#_winner but i cant remember what it is. can someone remind me? thanks. update tbl_pic set #active_week#_pic = #active_week#_win ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4