If GoDaddy is like any other ISP you need to get the datasource name for you database. Many ISPs give you tools to do this yourself.
For instance, you might have the capability to create a database (including tables, queries, etc.) within a user interface on GoDaddy.com. Once you save the database, lets call it “dataOne”, you must tell ColdFusion where the database is.
At this point you must open your ColdFusion Administrator (provided by the ISP) and select the link on the left called datasources. Fill out the form and name the datasource. This tells ColdFusion that there is a database called “DataOne” and where it is located.
If GoDaddy does not allow you access to the ColdFusion Administrator, then they should be providing you another way to create a datasource, use that.
Once the datasource is created you will use it in all your queries to refer to the database:
SELECT *
FROM tablename
Hope this helps. Coldfusion is fun. I have been using it for about 9 years and it really speeds up my development time for creating applications.
Recent Answers