I am dynamically outputting a query that loops through some documents associated with a particular order and displays a list.
I need to take this to the next step and display documents inline. It's a worksheet I am building - so it is 1 order, but can have multiple products - Each product can have 1 to 10 documents attached to it.
The end result is for someone to come to this page, view all the relevant content from the database AND view all related documents -
I was hoping to output this on 1 page so that 1 press of the print button will print all database info cfm pages, all docs, excels and jpgs associated with it.
Furthermore - ideally I would like to take all these items and compile into 1 pdf.
The problem is that I can have multiple.doc and a .pdf and a .txt file associated.
I tested the following code - deep down knowing it wouldn't work.
Anyone have any suggestions?
Again - goal is
1) Output db dynamic content & all related documents so user can print out all the pages and files associated with 1 press of the print.
2) Having all those items inline - I wanted to create 1 complete PDF ( essentially so I can email or spawn the PDF so user can use that PDF to print)
Sample code I tried -
P.S. - the cfcontent's are commented out because uncommented - they take over the entire browser and I can display that underneath the dynamic output query data...
Thanks for any suggestions!!!
jay miller
<cfoutput query="GetAssociatedOrderFiles">
<!--- set path to receive docs --->
<cfset variable.DocumentPath = "/Secure/dataupload/InspectorUpload/" & GetOrders.OrderID & "/OrderDocs/">
<cfset variable.DocumentAndPath = variable.DocumentPath & GetAssociatedOrderFiles.FileName>
#right(variable.DocumentAndPath, 4)#<br>
<cfif right(variable.DocumentAndPath, 3) EQ "jpg" OR right(variable.DocumentAndPath, 3) EQ "gif">
<h6>Inline Review of Graphical Formats</h6>
<p><img src="">
<cfelseif right(variable.DocumentAndPath, 3) EQ "txt">
<h6>Spawn inline content for txt</h6>
<a href="" target="_blank">#variable.DocumentAndPath#</a><br>
<cfcontent file="d:/webs/secureinspections.com#variable.DocumentAndPath#" type="text/plain" deletefile="No">
<br><hr><br>
<cfelseif right(variable.DocumentAndPath, 3) EQ "pdf">
<h6>Spawn inline content pdf</h6>
<a href="" target="_blank">#variable.DocumentAndPath#</a><br>
<!---<cfcontent file="#variable.DocumentAndPath#" type="application/pdf"> --->
<br><hr><br>
<cfelseif right(variable.DocumentAndPath, 3) EQ "doc">
<h6>Spawn inline content doc</h6>
<a href="" target="_blank">#variable.DocumentAndPath#</a><br>
<!---<cfcontent file="#variable.DocumentAndPath#" type="application/msword"> --->
<br><hr><br>
<cfelse>
<h6>inline not supported - please spawn and print document</h6>
<a href="" target="_blank">#variable.DocumentPath##GetAssociatedOrderFiles.FileName#</a><br>
<!--- do nothing --->
<br><hr><br>
</cfif>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
