We have a client that currently runs a batch file nightly to take a VSAM file and generate static HTML from that. We are assuming that there is some Cobol code being used to carry out that task. In looking around for a better way to do this we located a product called “VIASQL” which [...]
We are in the throes of moving our entire range web sites, database and ancillary services (mail, CFMX, Flashcom etc) from a dedicated served environment in Dallas Texas to a co-located facility in Los Angeles CA. We challenged ourselves to have no downtime and this was quite a challenge as the dedicated environment in Texas [...]
answersthatwork.com have what looks like one of the best resources we have seen for detailed information on the programs that run in the background in the task manager on Microsoft Windows systems. They have an immense alphabetically sorted database of all the details you could conceivably need to troubleshoot related issues and/or figure out what [...]
Ray Camden blogged a thought provoking piece relating to Democracy, you can find it on here. It made me think about different forms of government, although I am a firm believer in a strong democracy. I mentioned Singapore as a comment on Ray’’s blog, as an example of alternative forms of government. Then I stumbled [...]
Jochem van Dieten pointed this link out on MM’’s web site. It points to a list of reserved words in the SQL standard. These are words that should not be used as variable names in queries. There is an additional note that checks should also be made with the particular RDBMS manufacturer that you are [...]
Query of a Query was introduced in version 5.0 of ColdFusion. There is no doubt that used wisely the ability to query queries is a very powerful and flexible feature. However the syntax for using Q of Q is both stricter and quirkier than standard Query operation in ColdFusion. There is not much good information [...]
In some cases it can be difficult if not impossible to use Verity for full text searching with ColdFusion MX. There was a recent thread on CFTalk relating to this. Java Lucene from the Apache Jakarta project is worth a worthy contender in these circumstances. Here is an article in the ColdFusion Developers Journal [...]
ColdFusion has great logging capabilities to use in troubleshooting issues. One thing to bear in
mind though is that most of the logs are Error logs and in a perfect world should not exist. (I did say
a perfect world ;o).
One of the most debilitating errors as far as server performance goes are PCode errors, they [...]
Hal Helms has been creating and evangelizing with common sense for many years. Using a recognized framework in web application creation has immense benefits as Hal points out here. Hal has written regularly in ColdFusion Developers Journal, was one of the Founding-Fathers of Fusebox and the co-creator of Mach-ii along with Ben Edwards. [...]
Over yesterday and early today there has been a battle royal of a thread going on on CF-Talk which, in my opinion, sadly demonstrates the lack of necessary managerial and organizational thinking sometimes in our world. This all started when someone mentioned that Macromedia were using Mach-ii on their web site and this was [...]