<cftransaction>
<!--- retrieve the file details
based fileID passed to me --->
<cfquery
datasource="****" name="filedetails">
select *
from tblFiles
where FileID = <cfqueryparam
cfsqltype="cf_sql_varchar" maxlength="35"
value="#url.fileID#">
</cfquery>
<!--- make sure we
retrieve a valid record --->
<cfif filedetails.recordcount>
<cfset newdownloadcount = filedetails.downloadcount + 1>
<cfquery datasource="****"
name="updatecount">
update tblFiles
set downloadcount = <cfqueryparam
cfsqltype="cf_sql_integer" value="#newdownloadcount#">
where FileID = <cfqueryparam cfsqltype="cf_sql_varchar"
maxlength="35" value="#url.fileID#">
</cfquery>
</cfif>
</cftransaction>
<cfif filedetails.recordcount>
<!--- fake
header so browsers don't try to download as current template name --->
<cfheader
name="content-disposition"
value="attachment;filename=#filedetails.filename#">
<!--- serve
the file up with CFCONTENT --->
<cfcontent
file="c:\****\#filedetails.path#\#filedetails.filename#"
type="application/unknown">
</cfif>
From:
John Beynon [mailto:[EMAIL PROTECTED]
Sent: 28 May 2004 10:01
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] serving
files with cfcontent
Ah yes,
if I remove the transaction block it works. I need to make sure that in between
querying the db for the file details and updating the download count another
'download' doesn't sneak in, hence the use of cftransaction. If I complete the
transaction block before serving the file I'll be spanning the <cfif>
that checks if a record is valid so my code would end up looking like:
<cftransaction>
<!--- retrieve the file details
based fileID passed to me --->
<cfquery
datasource="****" name="filedetails">
select *
from tblFiles
where FileID = <cfqueryparam
cfsqltype="cf_sql_varchar" maxlength="35"
value="#url.fileID#">
</cfquery>
<!--- make sure we
retrieve a valid record --->
<cfif filedetails.recordcount>
<cfset newdownloadcount = filedetails.downloadcount + 1>
<cfquery datasource="****"
name="updatecount">
update tblFiles
set downloadcount = <cfqueryparam
cfsqltype="cf_sql_integer" value="#newdownloadcount#">
where FileID = <cfqueryparam cfsqltype="cf_sql_varchar"
maxlength="35" value="#url.fileID#">
</cfquery>
</cftransaction>
<!--- fake header so browsers don't try to download as current
template name --->
<cfheader name="content-disposition"
value="attachment;filename=#filedetails.filename#">
<!--- serve the file up with CFCONTENT --->
<cfcontent
file="c:\****\#filedetails.path#\#filedetails.filename#"
type="application/unknown">
</cfif>
Any
ideas?
-----Original
Message-----
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 28 May 2004 09:58
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] serving
files with cfcontent
> It
sends the file for download but doesn't update the download count
> in the db, if I comment out
the cfheader/cfcontent block it updates
> the Db so it's not a code bug.
>
Its probably because you're serving
the file inside the cftransaction.
Try
completing the transaction before serving the file.
Stephen
--
These lists are syncronised with
the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and
contributors:-
*Hosting and support provided by
CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To
unsubscribe, e-mail: [EMAIL PROTECTED]
_____________________________________________________________________
This e-mail has been scanned for
viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs.
For further information visit http://www.mci.com
**********************************************************************
Copyright ERA Technology Ltd. 2004. (www.era.co.uk). All rights reserved. The
information supplied in this Commercial Communication should be treated in
confidence.
No liability whatsoever is accepted for any loss or damage
suffered as a result of accessing this message or any attachments.
**********************************************************************
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed Scanning
Services - powered by MessageLabs. For further information visit
http://www.mci.com
