Cold Fusion MX newbie havinf issues with database connection

K

Kyros

Guppy
I bought Dreamweaver MX 2004 a while a ago and decided to plunge into the Cold Fusion area as well. The problem I am having is connecting a MS access database to cold fusion mx.

First off, here is my goal.

I do not plan on publishing my website over the world wide web. It will only be for me. My goal is to store NFL and MLB player statistics into access (which I have done successfully) and then publish them on my PC only (like a local site but just for myself).

The problem I am having is getting Cold Fusion MX to connect to the database. I tried to follow a tututrial on the macromedia site but that one is for Cold Fusion 7 and not MX (not sure if they are the same.

When the tuturial asks me to click on a box with a "plus" sign to select MS access database, it isn't there. So I am lost.

I want to make basic pages of players with thier names, teams, stats, their pictures, and then sort them via "sortable columns.

See the link below for what I would like to accomlish;

http://www.nfl.com/stats

or like this;

http://www.nfl.com/stats/leaders/NFL/RYDS/2005/regular

can this be done since I do have the database pretty much complete?

Thanks and I hope to hear from someone. :)
 
Yes you can make apps like those examples using coldfusion, but take my advice, just go ahead and learn to write the code - trying to build apps directly from dreamweaver with no knowledge of the code will have you beating your head against the wall. - just go here and this will get you started. once you have a good working knowledge of the basic code, THEN go back to dreamweaver and use it as a tool to save time. anyway, here is the link to get you started:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/part_get.htm

hth ~megan
 
Oh yes, I agree, if you were to buy a book (and that is a good one), written by one of the true Coldfusion masters, only to copy the examples to implement in your own applications, not play around with and learn from them, or take advantage of all the resourses the book contains.

That "Coldfusion" book is what I used when migrating to MX from Coldfusion 5. It worked well for me; others I have turned on to it that were starting from scratch have told me the same. I also found "Advanced Coldfusion MX Application Development" to be quite useful for when getting into Coldfusion a bit deeper.

Get a scripting tool... don't start with notepad.

HomeSite is what I started with and now use the CFEclipse plugin for the Eclipse IDE for development code, and normaly use Dreamweaver for maintaining developed production sites at JodoHost and other hosting providers.

I also do my experimenting and development using my computers here at my office and at home using my FREE development servers from Macromedia and New Atlanta, this helps to keep the production servers at JodoHost running smoothly.
 
thank you guys for all of your help.

I also have VB.net and was wondering if it were better for me to just use that (vb.net) to get the data from access database and build a utility that will sort the players statistics and allow for images such as player pictures and helmets, ect..ect. I really don't need a local website but thought I would just do it that way because I could personally design and make it my very own and all. Is vb.net the way to go instead?
 
My personal choice would be to use Coldfusion and Dreamweaver. Get familiar with Coldfusion, either online or get a book or two. I think you'll like it. Try doing some of what you have in mind both ways and see what you find out.
 
haven't tried vb.net but did originally start with asp (vb) and I say go with coldfusion - it is WAY more fun. just my .02 ~megan
 
Try this example
http://www.cfide.org/Excel_DSNLESS.html

I blocked out some parts only because its for excel but it
could be used for access or text .txt files too. You don't
need it to be in a component and don't ask for a DSN because
it all goes through one gateway "the ODBC service" and you'll
put pressure on the system. close() all your connections and
use prepareStatements when you can.

prepareStatements ? marks are not typeo's !
http://groups.yahoo.com/group/CFMX_JAVA/message/220

and good luck, Dan
 
You must log in or register to reply here.
Back
Top