Rather than exec I would use sp_executesql.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Jim Wright To: SQL Sent: Fri Jan 19 04:07:38 2007 Subject: Re: using a stored field name in an evaluation Michael Dinowitz wrote: > This may sound strange, but I have a table which is holding the name of a field. For example, the field TableID might contain the value domain.id > What i'd like to do is to take the value of TableID, and then use it as if it was a table/cell to be compared against something else. Something like > > tableid.treatvalueastable = 35 > > Is such a thing possible or should I either rewrite or hack a fix through ColdFusion? > Maybe something with EXEC... DECLARE @sql varchar(500) SELECT @sql = 'SELECT * FROM domain WHERE '+ (SELECT tableid FROM thetable) + ' = 35' EXEC(@sql) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2691 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
