Hi, If you are able to use Navicat to create tables then you MySQL is fine. I don't know about blue dragon, but for a test create a data-source called users and a table in there called users with fields of username, password put some fake data in there, and make a cf page get_users.cfm
If you have any troubles I can send you the SQL file and the cf page, but all should be good. John get_users.cfm <cfparam name="PageNum_get_users" default="1"> <cfquery name="get_users" datasource="users"> SELECT * FROM users </cfquery> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <table border="1"> <tr> <td>username</td> <td>password</td> </tr> <cfoutput query="get_users"> <tr> <td>#get_users.username#</td> <td>#get_users.password#</td> </tr> </cfoutput> </table> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4405 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
