Skip to main content
U
Urban1977
Participant
July 7, 2008
Question

create datasource on fly

  • July 7, 2008
  • 2 replies
  • 474 views
Hi

I have a coldfusion application which I am using mySQL 5 database with. When I have a new client that wants to use the applicaton is there a way for me to create a new database / datasource on the fly using coldfusion and then copy files to a new folder on the web server.

like an auto install routine?

I have seen this done with php installers.
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
July 7, 2008
Once you've done what Bob told you, you can run create table queries to build the database.

From a maintenance perspective, it would be simpler to have one db with a client table in their somewhere.
J
JR__Bob__Dobbs-qSBHQ2
Inspiring
July 7, 2008
You can add a data source programmatically using the administrator API.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.html
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices