Lazareth threads
ilssac Apr 30, 2010 2:20 PMIs it a known issue with our highly touted Jive Forum software that new posts to ancient (I.E. one, two, more year old) threads send the orginal thread post out to e-mail subscribers instead of the latest post?
An example of the most recent incident of this for me was a post today to this thread [http://forums.adobe.com/thread/209449] that was started on March 6th 2009 sent me the following email of the original post, not the reply submitted today. I find this quite confusing as I use the e-mail as a primery filter on whether I am going to come to the site to answer a question or not. (Since I do not yet trust the reply by e-mail feature) Only to find the question long discussed and that there is nothing really for me to add to it.
For several years we have succesfully used code like the following to open excel spreadsheets in the browser:
<!--- testExcelExport.cfm --->
<cfquery name="q1 ...
<CFHEADER NAME="Content-Disposition" VALUE='inline; filename="test.xls"'>
<CFCONTENT TYPE="application/msexcel">
<table>
<tr><td>hdg1</td><td>hdg2</td>
<cfoutput query="q1">
<tr><td>#col1#</td><td>#col1#</td>
</cfoutput>
</table>
Now some of our users have moved up to IE7 and have Office 2007 installed and for them the above no longer works properly. Instead of opening the file inline they now get a dialog box asking if they want to open or save the file 'test'xls' which it indicates is an Excel 97-2003 worksheet.
If they elect to save the file they can do so succesfully but when they open it they get a message that the file "is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source...". Despite the warning the file opens correctly.
If they elect to open the file they get the same message as above but now the file has the name of the cfm file which called CFContent, e.g. testExcelExport.cfm. The file can be opened however and has the correct content.
Question 1: How can I get Excel to use the excel filename rather than cfm filename.
Question 2: what do I needd to do so that Excel will not complain that the file is in a different format than specified by the file extension.
I have tried the following with no success:
saving the file using using CFFile then opening it with:
<CFCONTENT TYPE="application/vnd.ms-excel" FILE="#full file path#" deletefile="yes">
creating the table data with xml.
P.S. Is some type of file attachement feature gone, or did I just imagine that these forums once have that feature?



