PDA

View Full Version : MySQL and Cold Fusion



internetsalsa
11-25-2009, 11:58 AM
Hi,
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
</CFQUERY>

<cfoutput query="getinfo">

#vdo_code#
</cfoutput>

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

Thanks