> I would like to do a simple select statement, but need to mingle the
> results together for display purposes. I am trying to merge the
> select from each of two identical tables located on two different
> Oracle DB Servers. A simple UNION statement can only live under a
> single CFQuery statement (which of course points to a single DSN)
> .... any suggestions on an efficient way to do this in CF?
As mentioned in many previous threads, you cannot combine 2 DSNs in one
query
You could try talking to the other databse, but I don't know the Oracle
syntax - it may be the same as SQL Server's one... this is referring to the
table as "database.dbo.table"
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
