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 wa... (more)
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
automat... (more)
Thanks to those of you who sent in questions recently. I hope the answers you
received from me or other members of the Allaire training team were helpful.
For our readers, here are a few of the questions that were submitted:
Q:I understand the importance of using CFLOCK with the Scope attribute around
code that references session or application variables. Could you give me an
example of w... (more)
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... (more)
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... (more)