Bruce Van Horn

Subscribe to Bruce Van Horn: eMailAlertsEmail Alerts
Get Bruce Van Horn: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Bruce Van Horn

Greetings. I hope all of you who attended the DevCon last month enjoyed it, and came away with some great tips and tricks. This month's column is short, but hopefully addresses some problems that you've encountered recently. Keep those questions coming! Q: I have an application that allows users to upload newsletter articles into a database memo field (I'm using MS Access for my database). My problem is this: when I query the articles from the database and output them using CFOUTPUT, some of the really long articles are getting truncated. I've double-checked, and all of the text is in the database, so CF is cutting it off either in the query or during output. Any ideas? A: Yes! The problem is not with your database or with your output. The problem is actually with the way you have your datasource set up in the CF Administrator. To improve the perfor-mance of your que... (more)

Ask the Training Staff

I don't know about you, but February is going to be a very busy month for me. Not only is there plenty of CF work to keep me busy, but my wife, my son, and I are eagerly awaiting the birth of baby boy number two! Nevertheless, I have questions to answer and one revision to make on a previous answer. I hope you find it all worthwhile. First let's deal with the revision of my answer back in December (Vol. 4, issue 12) regarding the use of a placeholder in a query. The question was really centered around writing dynamic queries and how to handle the question of what should go immed... (more)

In Defense of MS Access

I often hear ColdFusion developers and some of my colleagues who do training for Allaire say things like, "Don't just walk away from MS Access_run!" While I think I know much of the rationale for a statement like that, I still feel I have to come to its defense. The Bad News First! Let me start by saying that I agree, to some extent, with the above derogatory comment about Access. Much of the criticism of ColdFusion comes in the form of "CF is too slow." When asked to explain, people will say, "It seems like most of the ColdFusion sites I visit are slow" or some similar remark a... (more)

Ask the Training Staff

Sometimes I take for granted just how cool ColdFusion really is! The other day one of my programmers asked me how to do what I thought was a fairly easy task. When I showed him the four lines of CF code he needed, he said, "ColdFusion rocks! It would have taken me 50 lines in PHP to do the same thing!" What could I say, other than "Yep"? Below are a few lines of code that I hope will make your life easier. Q:How can we prevent a browser from caching the content of our Web pages? For example, our content is constantly changing; if a user browses a page, goes on to other pages, a... (more)

Ask the Training Staff

Can you believe it's December already? 2002 was certainly a year of big changes for many CFers as Macromedia released the new MX products. Many of us scrambled to come up to speed on the new changes in CFMX. However, the fundamentals of CF programming didn't really change. The newcomer to CF still has to learn the basic CF tags, functions, and logic that were in previous versions before tackling the new features. With that in mind, here are two questions that came in recently that address some basics that CFers deal with every day. Q: I'm having trouble with a nested loop. The c... (more)