*newbie* connecting to sql

[stupidstanly]

I want to connect to my db, not sure how. In php I used:

$user_connection = mysql_connect($host, $user_id, $password)
or die ("Couldn't connect to server.");
$db = mysql_select_db('tablename', $user_connection)
or die ("Could not connect to db.");

where
$host="sqlserver"; /*on a network, NOT localhost*/
$user_id="myid";
$password="mypassword";

how do I do this in CF? thank you!

[forumnotifier]

I want to connect to my db, not sure how. In php I used:

$user_connection = mysql_connect($host, $user_id, $password)
or die ("Couldn't connect to server.");
$db = mysql_select_db('tablename', $user_connection)
or die ("Could not connect to db.");

where
$host="sqlserver"; /*on a network, NOT localhost*/
$user_id="myid";
$password="mypassword";

how do I do this in CF? thank you!

[mxstu]

Typically you would create a datasource in the CF Administrator. The
datasource settings vary based on database and connection type. Once you
create the datasource, it can then be used in cfqueries.

<cfquery name="getData" datasource="myNewDatasource">
SELECT something FROM someTable
</cfquery>

[dphillipsCFX]

Check out [url]http://tutorial2.easycfm.com/[/url]



Dan Phillips
CFXHosting.com