[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-users] ColdFusion - MySQL datasource connection



Kagie InteractiveHi all,

I managed to install MySQL and ColdFusion on my RaQ4, and I just created a
MySQL database called 'kagiebase'.

My question: how can I connect from my webpages to my new database
'kagiebase'? I prefer a DSN connection, but how do I create it? Has anyone
an example of a webpage for me?

Thanks in advance,
Micha

PS. Coming from Windows and Ms Access, I always used the file
Application.cfm, containing:

<CFPARAM name="Application.datasource" default="kagiebase">
<CFPARAM name="Application.dbtype" default="Access">

That was all! On the webpages itself, I only had to write:
<CFQUERY DATASOURCE="#Application.datasource#" NAME="GetItems">
 SELECT * FROM blabla WHERE blabla
</CFQUERY>

I hope this can also work on my Cobalt! :-)