Yes, assuming you are on MSSQL, this is a similar thing: http://www.thescripts.com/forum/thread80874.html
On 1/19/07, Jim Wright <[EMAIL PROTECTED]> wrote: > 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) -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2690 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
