I've been following the thread (or at least trying!). I've yet to see the following
use for the query a query.
In my case I have 2 databases. The first one is a FoxPro system that contains the
current location of a job in our shop along with any production notes from the various
production departments. The second database is in SQL Server and contains detailed
production information about the same jobs.
I need to produce a web page that merges the 2 systems together. Currently I have to
do a query against the SQL Server database, loop through each record and run a query
against the FoxPro system go generate my output. With the new functionality I can
query my SQL Server database and FoxPro system separately then run a query that does a
"Select Fox.Data, SQL.Data from Fox, SqL where Fox.Job = SQL.Job" and then output the
resulting dataset.
This is somewhat simplified but is an example of something I've needed to do for quite
awhile and have never been able to do directly within CF.
Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850
Phone: 301-424-3300 x396
FAX: 301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
WWW: www.euservices.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
