Hi Mike, That will work. Thanks!
--Ben Dawson, Michael wrote: >You cannot query from more than one DSN at a time, however, there are >some alternatives: > >* Use the database server to create "links" between other database >servers. > >* Use Query of Query (QoQ) to merge multiple recordsets after querying >each one, individually. > >* Query one datasource, then loop over each record and update another >datasource. > >m!ke > >-----Original Message----- >From: Ben Conner [mailto:[EMAIL PROTECTED] >Sent: Saturday, March 08, 2008 6:09 PM >To: CF-Talk >Subject: using CFQuery across multiple DSNs > >Hi, > >Is it possible to get a query (select/update/delete) to work when >pulling data from more than one dsn? What would the syntax be? I have >one database/dsn I need to update records from another one. Never done >that before. > >Thanks...! > >--Ben > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
