external data in Mura

I am wondering how I can have an extra dsn work with Mura to log into our company server to pull customer/product data. Any ideas?
LVL 1
ShawnAsked:
Who is Participating?
 
Gurpreet Singh RandhawaConnect With a Mentor Web DeveloperCommented:
what do you mean by extra DSN

What i can suggest here is if you want to Log some information into other database which is not user, you can always do like this:

<CFTRANSACTION>
      <cfquery datasource="datasource1">
         SELECT * FROM mytables
      </cfquery>
      <cfquery datasource=datasource2>
        SELECT * FROM other.dbo.mytables
      </cfquery>
 </CFTRANSACTION>


just check tis "other.dbo.mytables". it means it has been provided with fully qualified details as to which dadatasbe.schema.tablename

Check this link:

http://www.raymondcamden.com/index.cfm/2006/3/23/Ask-a-Jedi-Multiple-DSNs-in-ColdFusion-Applications
0
 
ShawnAuthor Commented:
so even if I use Mura I am pretty much free to set things up as in a regular cf site app? nice
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
yep
0
All Courses

From novice to tech pro — start learning today.