Hi Matt, Are you thinking of the admin API to create the dsn?
On 20 January 2012 02:39, Matt Quackenbush <quackfu...@gmail.com> wrote: > > I think you'll want to look into the ColdFusion Administrator API. There > are hooks for doing just these types of tasks programmatically. If you are > on Railo, it also has an API exposed that allows these tasks (<cfadmin> > tag, I think?). I've never used OpenBD, but I assume that it exposes > something of the sort as well. > > HTH > > > On Thu, Jan 19, 2012 at 11:54 AM, HCI <cf.contrac...@gmail.com> wrote: > > > > > Hi all: > > > > I've been presented with an interesting problem for which I seem to have > > hit a wall. I have an app wherein it would be very handy to be able to > > have the CF code create a new database as needed IN MySQL. I've tried > the > > straight CREATE DATABASE AAA in a CFQUERY with an existing datasource and > > get an exception error reading "Encountered "DATABASE" at line xxx". > I've > > tried doing the entire SQL string as a variable. I'm considering putting > > it in as a stored proc on an existing database and passing in the new > > database name...but nothing works. > > > > I saw an earlier thread here that seemed to allude to being able to do > > this but with no specific examples. Any help would be greatly > appreciated. > > > > Thanks in advance! > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm