[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[cobalt-users] ColdFusion - MySQL datasource connection
- Subject: [cobalt-users] ColdFusion - MySQL datasource connection
- From: "Micha Kagie" <kagie@xxxxxxxxx>
- Date: Mon Mar 18 10:16:01 2002
- List-id: Mailing list for users to share thoughts on Cobalt products. <cobalt-users.list.cobalt.com>
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! :-)