> Thanks for the reply! I see your point re: the code being involved, except
> for the fact that it gets to the end
> and writes the final log entry just fine (even on production). This is the
> only template that this happens to.
> I'm posting the code here. Here's hoping you see something!!
Unfortunately, I didn't really see anything obvious there. I would
recommend that you put HTML comments in the page at various places,
and see what happens when you get those prompts to download a file -
download the file and look in it to see what you find.
On a probably unrelated note, you could probably do with a second look
at how you're handling concurrency with CFLOCK and exception handling
with CFTRY. For example, in the following code, there's no reason for
the CFLOCK at all, since the database will enforce concurrency control
with that SELECT statement. Also, it's a good idea to always specify a
TYPE attribute with CFCATCH, so that you don't catch exceptions that
you're not prepared to deal with.
<cftry>
<cflock name="itunesSearchResult" type="readonly"
throwontimeout="yes" timeout="10">
<cfquery datasource="#application.dsn_10#" name="searchResult" >
SELECT *
FROM itunesMasterIndex
WHERE artist = '#artist2Find#'
AND album = '#album2Find#'
AND Song = '#song2Find#'
</cfquery>
</cflock>
<cfcatch>
<cfoutput>Database Error: #cfcatch.Detail#</cfoutput>
</cfcatch>
</cftry>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
