Since you are using the Image Charts<http://code.google.com/apis/chart/index.html>, you'll need to fetch the data from the database yourself and build the URL, as was mentioned in this thread. If you were using the Interactive Charts<http://code.google.com/apis/visualization/interactive_charts.html>, you could have used the data source protocol and library<http://code.google.com/apis/visualization/documentation/dev/implementing_data_source_overview.html>, which goes well with the interactive charts, but this may be irrelevant for you at the moment.
On Thu, Jan 13, 2011 at 1:51 AM, Stecin Leadership Solutions LLC < [email protected]> wrote: > I literally only need to pull 8 numbers (both + and -) from each record to > input into that image script. So is that possible with the example you sent? > > I'm on my Blackberry and didn't open it yet, sorry. > > Sent via BlackBerry from T-Mobile > ------------------------------ > *From: * Rolan Yang <[email protected]> > *Sender: * [email protected] > *Date: *Wed, 12 Jan 2011 18:47:13 -0500 > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *Re: [visualization-api] How can i convert this into an array > that pull from a database? > > On Tue, Jan 11, 2011 at 2:27 PM, stecin <[email protected]>wrote: > >> <img src="http://chart.apis.google.com/chart?chf=c,ls,0,FDFCFC, >> 0.25,EFEFEF, >> >> 0.25&chs=150x150&cht=lxy&chco=080809,3CC33C&chds=-44,44,-44,44,-44,44,-44,44&chm=r, >> 666666,0,0.49,0.51&chd=t:-35,-12,12,35|19,27,-31,-8|-35,-12,12,35| >> 5,15,-5,-3&chdl=Mine|Theirs&chdlp=b&chg=25,25,0,0&chls=2| >> 2,15,5&chma=5,5,5,25&chtt=D++++++++I++++++++S++++++++C&chts=0A0A0A, >> 11.5" alt="D I S C" width="150" height="150" >> border="1" /> >> >> >> This line... >> chd=t:-35,-12,12,35|19,27,-31,-8|-35,-12,12,35|5,15,-5,-3 >> >> Needs to pull these variables... >> chd=t:-35,-12,12,35|varD,varI,varS,varC-8|-35,-12,12,35| >> var2D,var2I,var2S,var2C >> >> Graph is beautiful!!!! I hope I can auto populate it with data. >> >> > > Your scripting language needs to fetch the data from the database, > construct the url, and output it. > If you can fit all your data into the url, that's nice. If you have > hundreds of data points, you may need to resort to loading a javascript > array. I have some sample code here: > > http://omnistep.com/furnacemonitor/googleviz-direct.phps > > It was written several years ago. The api might have changed since then. > > ~Rolan > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
