View Full Version : MySQL and Cold Fusion

11-25-2009, 11:58 AM
All these years I have been using access database with cold fusion with dsn.

Now I m trying to use MYSQL instead of Access.

I need to know how I would start? I already created a table.

So for example to display records from access I used to do write the following query.

<CFQUERY DATASOURCE="dsn" NAME="getinfo" >
SELECT * FROM non_music where id = 122

<cfoutput query="getinfo">


--Now how would I do the same if I m using MYSQL instead of Access?