Thanks for the kudos, Rick. I wrote the database chapters (David and I wrote 80% of the book), and really wanted to explain at least part of how SQL really works. There's an even more revealing explanation in our Advanced Development with ColdFusion and SQL Server 2000 class, if you're interested.
To work with multiple databases, you'll need to handcraft what we're going to be adding in the next version: optional data source arguments to DatabaseBlocks methods. Modify the DatabaseBlocks.cfc methods to take three optional arguments: Arguments.dbDSN, Arguments.dbUsername, and Arguments.dbPassword. Default these to the values of Application.dbDSN, Application.dbUsername, and Application.dbPassword, respectively. Then change the methods to use these new arguments rather than the constants stored in the Application scope. Make sure to re-run setup/Setup.cfm after you make any changes. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "Rick Penticoff" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, June 08, 2005 7:24 PM Subject: [plum] Referencing multiple databases in Plum Hi, I've just finished the "Getting Started" tutorial. Amazing functionality. In the infrastructure I inherited, our website is fed with data from multiple dbs. The applications I need to develop will often need to draw data from two dbs at the same time. In some existing applications, we have hand-written queries that are doing this. I assume it's possible, but how would one go about coding for multiple databases in a Plum application? I've looked through the Plum Help and queried the online KnowledgeBase, but haven't found anything that addresses this issue. Thanks for any advice and help. BTW, chap. 9 of the CFMX Bible is the first place, ever, that has helped me understand an SQL statement. I've read plenty of books that describe the features or attributes of a SQL clause or function, but none that explain how a statement actually works, clause by clause. It's a vivid illustration of a book that teaches, rather than just rewrites the product documentation. Rick Penticoff IdahoPTV web developer ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
