[plum] Referencing multiple databases in Plum

[Rick Penticoff]

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