Viewing by month: January 2005
Cftransaction issue
Posted on Jan 28, 2005
Extending on the DTS project I talked about a few posts ago, I was writing the page that would run the export. Without going into a long explanation as to the reasoning behind some of the structure, the steps were as follows:
- Run a stored procedure to move all purchase data into a "temporary" table of sorts
- Run the DTS package using the stored procedure as described here
- Update all the records moved with a timestamp denoting that they have been previously downloaded
New Job
Posted on Jan 27, 2005
In two weeks I will be beginning a new position. I will be in charge of the international brand sites for Hasbro. Hasbro's sites are all built in ColdFusion and I expect this to be an exciting opportunity. Hopefully, the new experiences will offer me more learning opportunities that I can share.
Running DTS from ColdFusion
Posted on Jan 25, 2005
For a project I am working on for my current employer, we had to run a DTS package essentially on-demand to move data aggregated in a number of views from SQL to Access. I knew this could be done, but actually had never needed to build this functionality prior. Fortunately, there are a number of resources available that assisted.
JavaScript Reference
Posted on Jan 24, 2005
I saw this link posted to Christian Cantrell's blog under a commment. It was in response to the question of what resource to use now that Netscape's JavaScript reference is no longer available (a question I have many times asked myself recently in frustration).
http://lachy.id.au/dev/mozilla/sidebar/sidebar.xul
If you use FireFox (and you should), bookmark this link and add the option to the bookmark preferences to open in sidebar.
Farcry CMS (phase one - part II)
Posted on Jan 20, 2005
Ok, so no surprise that it was a bit of ignorance regarding the setup of Farcry that caused my issues.