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

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 code shown in Listing 1 should - if I understand the way CF does loops - output both "house" and "mouse" in that order. However, when I run the code, it only outputs "house". Any insight? Listing 1 more)

Ask the Training Staff

Q:   What's OnRequestEnd.cfm? A:   OnRequestEnd.cfm is the twin brother of Application. cfm. When the code inside a file named Application.cfm is automatically included at the beginning of every .cfm file in the same subdirectory (and any directory below, provided that there isn't another Applic-ation.cfm in those directories), any code placed in a file named On-RequestEnd.cfm is automatically in-cluded at the end of every .cfm page. Q:   I come from an ASP background and am finding certain tasks difficult in ColdFusion. Here's my question: How do I find the size of a file on the ... (more)

Ask the Training Staff

My thanks to those of you who've read this column and let me know that it's actually helped. Even more thanks to those who've sent in questions - keep them coming! Here are some of the most recent ones. Q: I need to create a server-wide variable, not a session variable. It cannot be user specific. Can this be done without using a table? A: Most certainly! That's what the server variable scope is used for. Most programmers just starting out with CF quickly discover how to use session and application variables, but the server variable is often overlooked. All you need to do is set a... (more)

Ask the Training Staff

It looks as if this month's column is all about functions. In the questions and answers below we'll look at RandRange(), ListLen(), ListAppend(), GetTickCount(), and the ever-elusive Soundex() functions. Q:I need to build a search engine for our employee directory that will return some results even if the user doesn't know exactly how someone's last name is spelled (I think they call this a "fuzzy" search). How can I do this? A:There are two (probably more) ways to do a "fuzzy" search, both of which have little to do with CF and everything to do with SQL. The first and most obvio... (more)

Ask the Training Staff

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 ... (more)