>- see footer for list info -< Won't work, I'm afraid. First 'query' is actually a delete and the second is an update - and all I need back is to know they both succeeded.
I'm currently looking at the possibility of using a MySQL stored procedure. But at this point I don't know if this will work. But thanks anyway! Terry (free event listings at http://www.confexdb.co.uk) ----- Original Message ----- > *From:* Jason Haritou <[email protected]> > *To:* [email protected], Coldfusion Development > <[email protected]> > *Date:* Wed, 12 Aug 2009 17:09:18 +0100 > > 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. > ---------------------------------------------------------------------- > -------------------- > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.406 / Virus Database: 270.13.51/2297 - Release Date: > 08/11/09 18:27:00 > > > -- > *Included Files:* > am2file:001-HTML_Message.html _______________________________________________ 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 -<
