NorthStarDA
IS-IT--Management
Hey all,
I need to pull information from and join tables in 2 separate databases with 1 CFQUERY. I've heard rumors you could do it by referencing your database name and table name, but has anyone done this with MySQL? I've also read that it is more dependant on how your database handles this than CF.
CF MX 6.1
MySQL 4.1
tia
=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison
I need to pull information from and join tables in 2 separate databases with 1 CFQUERY. I've heard rumors you could do it by referencing your database name and table name, but has anyone done this with MySQL? I've also read that it is more dependant on how your database handles this than CF.
CF MX 6.1
MySQL 4.1
tia
=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison