Hi Alan, Many thanks for the quick response and advice however to give you an idea... If i use the code you suggest as is I simply get a Firefox page error "File not found" If i then amend the cfcontent line from "file=" to "variable=" it does throw up the dialog box but because there are no quotes around the filename the "You have chosen to open" filename seems to be truncated to 2 characters and although it picks up the fact that it's a .csv file there is no "open with" suggestion (which is a nice to have).
So sadly if i want the full filename displayed, the .csv recognised as such and a suggestion to open in Excel i have to revert back to the original code which like i say seems to run fine on the test server. Testing is fine using http and not fine using https so like you say everything now seems to point towards the SSL setup I don't "think" it's a case of hitting different machines, but i do believe now that there are different versions of blue dragon running which obviously could have some bearing. Any joy and i'll let you know. Best Regards, Mark On May 5, 7:20 pm, Alan Holden <[email protected]> wrote: > I don't recall a need for the dot within the content type of the MIME spec. > Try "text/csv" > > The format is "content type/subtype" > Here is a list of many mime types:http://www.iana.org/assignments/media-types/ > > Also, I do not use quotes about the file name. > > Here is a set of tags that works for me: > <cfheader name="Content-Disposition" value="attachment; > filename=#reportFileName#"> > <cfcontent type="text/csv" file="#fileTargetPathFile#" deletefile="true"> > > The problem might also have something to do with your SSL setup. Test > using http first, and then https. > Investigate whether or not your production environment has a different > file system or network setup than your development environment. > For example, if you have one request that creates the file, and another > one to download it, you could be hitting different machines in a > clustered environment. > > Al Holden > > On 5/5/2010 4:49 AM, Mark Vallely wrote: > > > (snip) > > <cfheader name="Content-Disposition" value='attachment; > > filename="Export.cvs"'> > > <cfcontent type="text/.csv" variable="#mainCVS#"> > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > mailing list -http://groups.google.com/group/openbd?hl=en > > !! save a network - please trim replies before posting !! -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
