You could show a bit more respect to the forum. You are fast giving me the impression you want to come here with a list of requirements and have fellow developers do your work for you.
I have given suggestions in a number of your threads. There was always silence whenever it reached the point where you needed to give more information. Here are recent examples:
You don't even have to thank colleagues. However, you owe it to the forum to simply acknowledge whether or not a suggestion has helped.
"please give me any advice/suggestion, maybe a article i can read online (havent found anything that can help me)"
Change your approach to the problem. First of all make your script create the data you require and then write it into a database for the appropriate month/year. Then you can just make cse_newsletter.cfm ask the user for a date/month/year and then generate the report (defaulting it to the current month/year perhaps.) That way, the end-user can request a newsletter for any valid month/year that exists in the database. If you want, you can also make the script accept URL parameters e.g. cse_newsletter.cfm?month=1&year=2014 and serve up the newsletter that way too. It will be a nice little project, good luck.
what do you mean by
"can just make cse_newsletter.cfm ask the user for a date/month/year"?
I mean that your cse_newsletter.cfm template can be designed to accept parameters to show a newsletter for a certain month and year. If it accepts URL parameters then you can create a link to it like this:
And, if parameters are not passed, you could make it show the user a list of months and years (via form controls e.g. selection list) so that they can select the month and year that they require. That's how I would design it anyway. Unless your data is stored somewhere in a database, your template will only ever work for one scenario (the last month), and that is a big limitation since people cannot then see past newsletters. You may not need to write files to disk etc, since the template just needs to show the correct newsletter. You can create whatever link to the newsletter you require once it has been designed to accept month and year parameters (which are in turn fed to your CFQUERY tags to get the data).
thank you i been thinking about this the wrong way, now i know how i should do it and go about it
There are many ways to tackle this, so I am not sure I gave you the correct answer, rather an answer. Good luck with it anyway.
well your answer help me find out how i should do it, after i read your comment i did some research and figure out how to approch the problem , so thanks