CFMAIL and CFCHART

Hello,
  I have a CFMAIL process that is working fine.

I can pass data from SQL Server and send to our Executive Management the Sales information they need.

Now....

They want to see the data in a bar chart.

I have a page that returns the data fine in a regular page...
But when I try and pass it through CFMAIL...there are no errors...but no chart either.

I'm sending the page in HTML format.

Can this be done?

Thanks
Larry Bristersr. DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mrichmonCommented:
You need to either embed the image in the message or have it an <image src="http://yourdomain.com/pathtochart.jpg"> in the message
0
Larry Bristersr. DeveloperAuthor Commented:
mrichman,
  That chart is dynamic and looking at live data.

So the page that has the chart is http://mnydomain/chart.cfm
0
mrichmonCommented:
But the chart is actually generating into something.  Or if not you can force it to do so with the output attribute.  Then that is what you send in the email - otherwise the best you can do is link to the page.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Larry Bristersr. DeveloperAuthor Commented:
mrichman...
  I plan on awarding you the points momentarily.  The chart is returned to the page with the code below.

Are you saying I can change the output some way?

<cfchart
    xAxisTitle="My Company Sales By QTR"
    yAxisTitle="Sales"
      chartwidth="500"
      showygridlines="yes"
           scaleFrom="0"
           scaleTo="400000"
      gridlines="5"
      show3d="yes">
      <cfchartseries type="bar"
      seriesLabel="This Year" seriescolor="336699">
                                                 <cfchartData item="QTR1" value="#sby.QTR1#">      
                                                  <cfchartData item="QTR2" value="#sby.QTR2#">
                                                  <cfchartData item="QTR3" value="#sby.QTR3#">            
                                                     <cfchartData item="QTR4" value="#sby.QTR4#">
                                        </cfchartseries>                  
                        </cfchart>
0
Larry Bristersr. DeveloperAuthor Commented:
mrichman,
  Looks like even when I make those changes and have the output as a jpg format I get the red x image blank page.

Whether I run it on the cfmail page or include it.

Thanks for trying...looks like the effort may not be worth the return.  CEO will just have to learn to live with his disappointment. :-)

Points being awarded now.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.