Solved

external data in Mura

Posted on 2013-05-21
3
242 Views
Last Modified: 2013-05-26
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?
0
Comment
Question by:Shawn
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Gurpreet Singh Randhawa earned 500 total points
ID: 39189837
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
 
LVL 1

Author Comment

by:Shawn
ID: 39198298
so even if I use Mura I am pretty much free to set things up as in a regular cf site app? nice
0
 
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 39198491
yep
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question