Oh, my real answer is: Normally, in Java, one creates a datasource object, and then connect to a database using a connection string. Then, you do your SQL operations then close the database connection. You can save yourself some time with coding by creating a wrapper class that does the connecting for you, and then call that object each time instead of instantiating the datasource object directly.
In fact, I can't think of a reason why CFMX couldn't support dynamic connections, even with the Merant drivers. If they're Type IV drivers (and I'm positive they are), they've gotta implement the JDBC API, part of which is what I explained above. Someone could easily write a custom tag that allows dynamic query connections, I suppose. ----- Original Message ----- From: Dave Watts <[EMAIL PROTECTED]> Date: Friday, June 14, 2002 10:47 am Subject: RE: RE: CFQuery Error - No more ConnectString ??? > > Really odd. The thing is, it's really easy to create dynamic > > connections in Java using JDBC. Like, it's so simple it ain't > > even funny. I do it all the time. > > I guess I'd have been more accurate in saying "the versions of the > Merantdrivers included with CF MX don't support dynamic > connections." Or, perhaps, > it's not even the drivers' fault at all - it might be the way that > CF MX > works with the drivers. I don't really know why that is. For all I > know, the > versions that do support dynamic connections cost too much for MM to > include. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
