Thanks
I am using the following
<cfset user = listLast(cgi.REMOTE_USER,"\") >
<cfheader name="content-disposition"
value="attachment;filename=testdoc.doc">
<cfcontent type="application/msword"
file="#ExpandPath(".")#\testdoc.doc" deletefile="no">
to display word docs, but what would be the best approach to check that
the document has been opened and read by the user.
Once read the user has to click a checkbox or link? that they have read
the document. (Similar to an e-learning course website)
In the document listing page, next to this document it will display
'Read' with this information stored in the database for that user. If
the user has opened the doc and not clicked the checkbox it will display
'Doc Opened' next to that document on the webpage, and if they have not
opened it, it will display 'Not Read'. Any ideas on the right approach
for this?
Or am I making this more complicated than it should be?
I have set up a DB table with the following fields ID, Name, LoginID,
Document, Status, Date
For example when opening the doc via cfcontent how would I create a
query to set the document name in the database, so it knows that users
have either 'opened', 'read' or 'not read' the document and what would
be the best way of setting the status of the document i.e. Opened, Read
or Not Read? in the database to display next to the document listing
<cfquery name="LOOKUP" datasource="DS">
SELECT Max(docid) NewdocID
FROM docstatus
</cfquery>
<cfif lookup.newdocid is "">
<cfset docid = 1>
<cfelse>
<cfset docid = lookup.newdocid + 1>
</cfif>
<cfquery datasource="DS" name="insert ">
INSERT INTO docstatus (docid, name, loginid, documents, status, date)
VALUES (
<cfqueryparam cfsqltype="cf_sql_number" value="#linkid#">,
<cfqueryparam cfsqltype="cf_sql_date" value="#user#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#loginid#">,
???????
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:319269
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
