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:2689 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
