We are making some fairly major updates to our website at the moment, one of which includes pulling the postings dynamically from this blog and putting excerpts on the home page of our website. To do this you will need to either use your website host to install wordpress or download wordpress and install it manually on your own server, although do note that wordpress is run on php. The reason I bring this up is because if you are working on a Coldfusion server, as I am, it is most likely that the files just won’t work, or, if they do, they will be a maintenance nightmare.
If you install wordpress via your host, then you will most likely need to contact them to get access to the database. Once you have your host name, user name, and password from your host for your wordpress database you can log in through the phpMyAdmin tool. Once in you can look for your self on how the database is set up and what fields you want to pull to your website. Next you will need to create a dsn to this database. If you have access to your Coldfusion Administrator create it there, or if you are on shared hosting you will probably have to contact your host and have them set up the dsn. Once you have the dsn you should be all set to pull the data the same way you would for a database running locally or on the site’s server.