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:349547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
