Nothing wrong with cross-database joins - heaps quicker than a QofQ. On 13/09/06, Barry Beattie <[EMAIL PROTECTED]> wrote: > > Thanx Rod > > well, bugger me, it worked! > > <cfquery name="qry" datasource="FOUREX"> > SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID, > INST.AbsoluteSerialNum > FROM evaluationsQuizDev.dbo.tbl_Quiz_Schedule AS SCHED INNER JOIN > tbl_InstrumentReleased AS INST ON > INST.OnlineQuizID = SCHED.Quiz_ID > </cfquery> > > <cfdump var="#qry#" expand="false"> > > I suppose it'd crash'n'burn if the username/password was changed per > database, not just logon to the db server...yes? > > thanx again > b > > > > > > > On 9/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Are the databases on the same sql server? If so you can simply include the > > database name as part of the query. > > > > ie <dbname>.<dbuser>.<dbtable> > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > >
-- Darryl http://www.acheron.org/darryl/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
