how to connect coldfusion and mysql... need db first

[asnyder131]

I'm a newby here as well as to mysql and coldfusion.

I'm a business owner who had previously designed my own relational database system for my company (smartware) and used it sucessfully for many years. I have recently paid for a new web based system and decided to go with a programmer that built a coldfusion mx/mysql system.

There are a number of features and procedures that are not working correctly and my programmer is telling me that I'll have to pay him more to fix these items (I'm pretty upset at this point).

He just provided me with the coldfusion source code/files as well as "code" for the db. What he gave me for the db was a single file (an .SQL file). It appears to be a single "script" creating and enetring data into the tables for the db.

How can I take this file and actually "create" my database... once I have this it seems fairly easy to connect with coldfusion so that I can start some debugging on my own.

Please help... Thanks

[bishwadeep]

Hello I have send you some steps for the setup:

Go to coldfusion administrator
Click on data sources menu
On the top You will see Add new datasource
Type your Data source name
Driver Mysql
Click add
Then
on the form
datasource name:datasource name
Database:Database name
Server: eg "192.168.0.41"
User name:
Password:
then
Submit


In the page:
if you have to run the query then simply do the following:

<cfquery name="abc" datasource="datasource name">
Select * from your table
</cfquery>
<cfoutput query="abc">#abc.fieldname#</cfoutput>

Thats all