Skip to main content
T
TALAL_MANAA
Inspiring
October 12, 2009
Answered

Relational MS SQL Databases

  • October 12, 2009
  • 6 replies
  • 1632 views

I have multilple relational databases, our aspx developer was able to relate them using stored procedure , but since I'd like to convert the job into coldfusion I found difficulties in using the stored procedures to query all the relational databases , since coldfusion connection should be made manually to every database. Here is the scenario:

I have 5 MS SQL databases: [img1, img2, img3, img4, and descriptionDB]

the "descriptionDB" holds text and id information the id will be related to a hexadecimal image inside one of images databases img.

How can I make a query using coldfusion to display images and their related texts !

This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer Dan_Bracuk

You might be looking to fix something that isn't broken.  If the stored procedures worked in asp, there is no reason for them to not work in cf.  The only connection you should need is to the db with the stored procedure.

6 replies

A
Anonymous
October 12, 2009

Do you realise that you can reuse the same or create new stored procedures?

T
TALAL_MANAAAuthor
Inspiring
October 13, 2009

As I use Dreamweaver for coldfusion development, I can see the whole stored procedures written by the previous aspx developer;  however, the stored procedure was so complex and coldfusion couldn't understand it as it has first to be connected properly to databases.

ilssac
ilssac
Inspiring
October 12, 2009

Do you want to do it at the database level or the applicaiton server level?

At the application server level you could query each table seperatly and then use a query-of-query syntax to combine the different recordsets together, but I would not consider this the best choice.

At the database level, if one of these databases can see the other databases you can do it in a singe query using fully qualified table names.  In MS SQL a fully qualified table name is [server].[databasename].[owner].[tablename].

You can leave of the higher levels of that if they are the same for all the objects you want to join.  I.E.  If all these databases are on the same server you can leave the server name out of the name.

T
TALAL_MANAAAuthor
Inspiring
October 13, 2009

thank you for your time and effort in providing helpful information, I will try your methodologies and let you know of the results.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices