- see footer for list info -<
Not sure of MYSQL Has them are can do it but I've used a SYNOM across
MSSQL Databases before.
Thus have the SP in the one DB that affects them both.
--------------------------------------------------
Big Mad Kev
Adobe Community Expert (ColdFusion)
email: [email protected]
blog: http://inner-rhythm.co.uk/blog
--------------------------------------------------
On 12 Aug 2009, at 17:31, Terry Riley wrote:
- 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 -<
_______________________________________________
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 -<
