>
>Hope someone can help me with this:
>
>How can I tell a SP to query a different dbs inside of a SP?
>
>I need to be able to run some queries on one db and within that same SP run
>queries on another db.
>IS this possible? Or will I need to do two different SP one in each db and
>a temp table to hold the information from the first SP to run against the
>second SP.
>and just do the two calls from the CF page?
>
I don't know what RDBMS you're using, but you should be able to scope the
table name with either the database name or the schema name:
myDB1.tableName, myDB2.tableName, etc.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
