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
> >
> > >
> >
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
