>- see footer for list info -< Couple of really simple options off the top of my head - 1. Perform the two queries separately and then just do a query of queries to combine them 2. Create a view from one database to the tables in the other database. Then you can just combine the queries since they're in the same datasource.
I seem to remember there was a way to do this by first stating the database in the table name, i.e. myserver.mydatabase.tablename but for the life of me I can't find the reference. Good luck! J 2009/8/12 Terry Riley <[email protected]> > >- see footer for list info -< > For the first time, I need to do this, but have become aware that a > standard <cftransaction> around two queries won't work, as CF8 insists > the datasources are the same (mine aren't). > > For the sake of my sanity, can anyone point me in the right direction? I > have been googling on this for an hour or more with no concrete results. > > (And please don't suggest I uodate to 9 - it isn't an option) > > Cheers > Terry > (free event listings at http://www.confexdb.co.uk) > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > -- ------------------------------------------------------------------------------------------ Jason Haritou Kitsune Ltd http://www.kitsunesystems.com/ +44 (0) 7734 955 925 The copyright in this email belongs to Kitsune Ltd and its contents are confidential. Unless expressly agreed to the contrary, no representation is made by this email and it must only be used for the purpose for which it was supplied. Unintended recipients must not make or resend copies of this email, nor use its contents for any purpose. Any opinions expressed by the sender of this E-Mail do not necessarily represent those of Kitsune Ltd. Due to the insecure nature of Internet Communications, Kitsune Ltd does not accept legal responsibility for this E-Mail message. ------------------------------------------------------------------------------------------ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
