You can't join the takes cross datasource.
I'd use the query of queries method or question why they need to be joined
as you could just.
<cfquery name="one" datasouce="one"
Select Blah
<cfloop name="two" query="one">
<cfquery datasource="two"
Select Blah
Where x=#one.y#
Regards
Dale Fraser
http://dale.fraser.id.au
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Barry Beattie
Sent: Wednesday, 13 September 2006 10:52 AM
To: [email protected]
Subject: [cfaussie] Querying across multiple databases
Hi all
I think I remember a post on this before but I can't find it anywhere.
the app I'm extending uses 2 databases (2 diff DSN's). I now need to
pull in data from both into the same recordset.
eg:
SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID,
INST.AbsoluteSerialNum
FROM tbl_Quiz_Schedule AS SCHED INNER JOIN
evaluations.dbo.tbl_InstrumentReleased AS INST
ON INST.OnlineQuizID = SCHED.Quiz_ID
I could:
- use Query'o'query to combine 2 seperate queries into one (too much
irrelivant data)
- put the SQL onto one of the DB's as a SProc (back-up plan)
- work out how to join the two databases within the same CFQUERY
(preferred)
any suggestions?
thanx
barry.b
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
